Sr Data Architect

Capco; United States; On-site; USD 85,000 - 121,000; Full time

Job summary

Capco seeks a Senior Data Architect in Jersey City, NJ to design and maintain scalable cloud data platforms using Snowflake.

You will define how data is stored, integrated, secured, and used to support analytics, reporting, and strategic decisions. Collaborate with data engineers, developers, product managers, and business stakeholders to drive enterprise data models and architecture standards.

Qualifications

• Extensive experience designing and implementing enterprise data platforms and data warehouses.
• Snowflake architecture expertise including data modelling, performance optimisation, and cost management.
• Experience with dimensional modelling: Star Schema, Snowflake Schema, Data Vault 2.0.
• Advanced SQL skills for data transformation and complex modelling.
• Knowledge of enterprise data warehousing, analytics architecture, and integration patterns.
• Hands-on dbt for production pipelines and data transformation.
• Experience with workflow orchestration and tools like Airflow or Dagster.
• AWS cloud services familiarity and cloud data platform architecture.

Responsibilities

• Design and implement scalable, secure, high‑performing enterprise data architectures using Snowflake and AWS.
• Define enterprise data models, schemas, and standards (Star/Snowflake/Data Vault 2.0).
• Architect data ingestion, integration, and transformation with ETL/ELT tools (dbt, Airflow, Kafka).
• Ensure scalability, reliability, and cost efficiency of data platforms.
• Establish data governance, security, and access controls.

Skills

Advanced SQL

Enterprise data architecture

Data modelling

Stakeholder collaboration

Education

Bachelor's or Master's in Computer Science or Data Engineering

Tools

Snowflake

AWS

dbt

Airflow

Kafka

Sigma

Qlik

Job description

Location: Jersey City, NJ | Contract | Onsite | Payrate: $75/hr

Job Summary

We are seeking an experienced and detail-oriented Senior Data Architect to join our cross-functional Agile team. In this role, you will design, build, and maintain scalable, high-performing cloud data platforms using Snowflake.

You will define how data is stored, integrated, secured, and used across the organisation, ensuring that data architecture aligns with business objectives and supports analytics, reporting, and strategic decision-making.

Working closely with data engineers, backend and frontend developers, product managers, and business stakeholders, you will develop enterprise data models and architecture solutions that support application development and business intelligence.

This role offers the opportunity to work with modern cloud technologies, establish architectural best practices, and contribute to enterprise-wide data transformation initiatives.

Key Responsibilities

• Enterprise Data Architecture: Design and implement scalable, secure, and high-performing enterprise data architecture using Snowflake and AWS cloud technologies.
• Data Modelling and Design: Define and maintain enterprise data models, schemas, and architectural standards, including Star Schema, Snowflake Schema, and Data Vault 2.0 methodologies.
• Data Integration and Transformation: Architect data ingestion, integration, and transformation strategies using ETL/ELT frameworks and technologies such as dbt, Airflow, Kafka, and related tools.
• Performance and Cost Optimisation: Ensure the scalability, reliability, performance, and cost efficiency of Snowflake data platforms through effective architecture and optimisation techniques.
• Data Governance and Security: Establish data security, governance, and compliance standards, including access controls, role-based permissions, data masking, and data protection policies.
• Technology Selection and Integration: Evaluate, select, and integrate appropriate data engineering, orchestration, and analytics tools to support enterprise requirements.
• Technical Guidance: Provide architectural guidance to data engineering teams, review technical designs, and promote consistent engineering standards.
• Architecture Standards and Documentation: Establish and maintain architectural best practices, technical documentation, and data design standards.
• Stakeholder Collaboration: Partner with engineering, analytics, product, and business teams to translate business requirements into effective technical solutions.
• Cloud Architecture: Design and support cloud-based data architecture across AWS, ensuring alignment with enterprise technology strategies.

Mandatory Qualifications & Skills

• Extensive experience designing and implementing enterprise-level data platforms and data warehouse architectures.
• In-depth knowledge of Snowflake architecture, including data modelling, performance optimisation, and cost management.
• Experience with dimensional modelling techniques, including Star Schema, Snowflake Schema, and Data Vault 2.0.
• Advanced SQL skills, including query optimisation, data transformation, and complex data modelling.
• Understanding of enterprise data warehousing, analytics architecture, and data integration patterns.
• Hands-on experience with dbt for data transformation, modelling, and maintaining production data pipelines.
• Experience with workflow orchestration and data integration tools such as Apache Airflow, Dagster, Kafka, or similar technologies.
• Experience designing and implementing ETL/ELT pipelines and data ingestion frameworks.
• Knowledge of AWS cloud services and cloud-based data platform architecture.
• Experience integrating Snowflake with data engineering, orchestration, and business intelligence tools such as Sigma and Qlik.

Data Governance, Security & Performance

• Understanding of enterprise data governance frameworks, data quality standards, and regulatory compliance requirements.
• Experience implementing data security controls, access management, and data protection policies.
• Knowledge of performance tuning, workload optimisation, and cost management within cloud data platforms.
• Ability to develop and maintain architectural documentation, design standards, and technical best practices.
• Ability to approach complex technical challenges with a strategic, enterprise-wide perspective.
• Experience providing technical guidance, mentoring engineers, and reviewing architecture designs.
• Effective communication and collaboration skills, with experience working across engineering, analytics, and business teams.
• Experience working in Agile/Scrum environments and managing delivery activities using Jira.

Education & Experience

• Bachelor's or master's degree in Computer Science, Data Engineering, Information Technology, or a related discipline, or equivalent practical experience.
• Typically 7–10+ years of relevant experience in data engineering, data architecture, or analytics.
• Demonstrated experience in a data architecture or technical leadership role.
• Experience building, deploying, and maintaining scalable dbt projects in production environments using Snowflake and Airflow.
• Experience maintaining high standards of technical documentation, data quality, governance, and platform performance.
• Snowflake and relevant cloud certifications are advantageous.

U.S. EQUAL OPPORTUNITY EMPLOYMENT INFORMATION

Individuals seeking employment at Capco are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirelyvoluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Form CC-305

OMB Control Number 1250-0005

Expires 04/30/2026

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Capco’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.