Data Architect (Need Local to New Jersey)
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Architect in Iselin, NJ, requiring 15 years of experience, strong skills in SSIS, SQL, Python, and AWS. The contract is onsite, focusing on building reconciliation frameworks and dashboards, with excellent communication skills essential.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
-
🗓️ - Date discovered
September 4, 2025
🕒 - Project duration
Unknown
-
🏝️ - Location type
On-site
-
📄 - Contract type
Unknown
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
Iselin, NJ
-
🧠 - Skills detailed
#SAP #"ETL (Extract #Transform #Load)" #Logging #Scala #Data Architecture #Monitoring #Python #EDW (Enterprise Data Warehouse) #SQL (Structured Query Language) #SSIS (SQL Server Integration Services) #Data Engineering #AWS (Amazon Web Services) #Data Lineage
Role description
Role: Data Architect
Location : Iselin, NJ (Local candidates only) Onsite role
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
Key Responsibility:
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.
Role: Data Architect
Location : Iselin, NJ (Local candidates only) Onsite role
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
Key Responsibility:
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.
