What are the responsibilities and job description for the Data Architect - Onsite position at MSys Inc?
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.
