Ampstek

Compensation

Full Description

Role: Data Architect Location: Iselin, NJ (Local candidates only) Onsite role Job Type : Contract Role Summary: Lead the design, development, and maintenance of a scalable reconciliation framework across EDW, FDR, CKGL, and SAP systems. Act as the technical anchor for the POD, ensuring robust monitoring, defect logging, and collaboration with SMEs for resolution. Key Responsibilities: Architect and implement end-to-end reconciliation workflows. Build and maintain SSIS packages and Python-based scripts for data validation and integrity checks. Design a dashboard/UI for real-time monitoring of throughput, defect rates, and data drops. Collaborate with Finance, SAP, EDW, and Data Engineering teams to align on data lineage and resolution paths. Ensure the framework is extensible to support evolving integrations post go-live. Mentor offshore engineers and ensure consistent delivery quality. Required Skills: 10+ years of experience in data engineering and ETL development. Strong hands-on expertise in SSIS, SQL, and Python. Proven experience in building reconciliation frameworks and dashboards. Familiarity with financial systems and SAP data structures. Excellent problem-solving and stakeholder communication skills. Job Description: • Strong working experience as a Data Architect. • Key Skills: • SSIS, SQL, Python, Pipelines, AWS • Years of experience: 15 yrs exp • excellent communication skills must