Job summary:

Title:

Data Architect - Onsite

Location:

Berkeley Heights, NJ, USA

Length and terms:

Long term - W2 or C2C

Position created on 02/05/2025 06:42 pm

Job description:

* Webcam interview; * Long term project Onsite

Job Description:

We seek a highly skilled Data Architect with expertise in Data Modeling, Data Architecture, Data Lineage, and Pipeline Development. The ideal candidate will have hands-on experience in building data pipelines, working with Snowflake, writing optimized SQL queries, and developing solutions in Python.

Key Responsibilities

• Design and implement data models supporting business intelligence, analytics, and operational reporting needs.

• Develop enterprise data architectures, ensuring scalability, security, and performance.

• Work closely with business teams to define logical and physical data models and ensure alignment with industry standards like ISO20022/BIAN.

• Build and optimize data pipelines for ingestion, transformation, and processing in Snowflake and other cloud data platforms.

• Automate data integration workflows using Python and SQL.

• Ensure efficient ETL/ELT processes that support business intelligence and reporting needs.

• Implement and manage Data Catalog solutions (Alation preferred) to enhance data discovery, metadata management, and governance.

• Define and maintain data lineage using tools like Manta, ensuring end-to-end visibility of data flows.

• Establish data governance policies and best practices for data stewardship and data quality.

• Write, optimize, and maintain complex SQL queries for data extraction, transformation, and analysis.

• Utilize advanced Excel capabilities, including macros (VBA), data automation, and reporting functions.

• Develop and maintain Excel-based analytical models and reporting solutions as needed.

• Ensure efficient query performance tuning in Snowflake and relational databases.

• Ensure data security, compliance, and governance as per enterprise and regulatory standards.

• Align data architectures with financial industry standards like ISO20022/BIAN.

Qualifications and Skills Required

• Experience Needed:12+ Years

• Bachelors or Masters degree in Computer Science, Data Science, Information Technology, or a related field.

• 10+ years of experience in Data Architecture, Data Modeling, and Data Pipeline Development.

• Hands-on experience in Snowflake, SQL development, and Python scripting.

• Prior experience working with Data Catalog and Lineage tools (Alation, Manta) is a strong plus.

• Expertise in data modeling (conceptual, logical, physical).

• Experience in building and managing data pipelines.

• Hands-on experience with Snowflake, ETL/ELT processes.

• Proficiency in Python for data transformation and automation.

• Hands-on experience with Data Catalog tools (Alation preferred).

• Experience with Data Lineage tools like Manta.

• Strong SQL skills for data manipulation, querying, and optimization.

• Proficiency in Excel Macros (VBA), Pivot Tables, and advanced reporting techniques.

• Understanding of ISO20022/BIAN standards for financial data exchange and architecture.

• Strong grasp of data security and regulatory compliance.

  Contact the recruiter working on this position:

The recruiter working on this position is Nadeem Ahmed Razvi(Shaji Team)

His/her contact number is +(1) (202) 7381674 His/her contact email is nadeem@msysinc.com

Our recruiters will be more than happy to help you to get this contract.