Data Architect

Job Summary

We are seeking an experienced Azure Data Architect with 10+ years of expertise in designing and delivering enterprise-scale cloud data platforms on Microsoft Azure. The ideal candidate will have strong hands-on experience with Azure Data Factory (ADF), Snowflake, and dbt, along with deep knowledge of data architecture, data modeling, governance, and cloud modernization. This role will define data architecture standards and design scalable solutions that support analytics and business intelligence requirements.

Key Responsibilities

• Design and implement scalable, secure, and high-performing data architectures on Microsoft Azure.
• Architect end-to-end data platforms leveraging Azure services, Snowflake, and dbt.
• Define enterprise data models, integration patterns, architecture standards, and reusable frameworks.
• Lead data migration and modernization initiatives from legacy platforms to Azure and Snowflake.
• Design and optimize ETL/ELT pipelines and orchestration frameworks using Azure Data Factory and dbt.
• Establish best practices for data governance, security, metadata management, lineage, and data quality.
• Collaborate with business stakeholders, solution architects, and engineering teams to translate requirements into scalable technical solutions.
• Drive architecture reviews, performance optimization, technology roadmap planning, and design governance.
• Provide technical leadership, guidance, and mentoring to data engineering teams.

Required Skills and Qualifications

• 10+ years of experience in data engineering, data warehousing, data platforms, or data architecture.
• Strong expertise in Microsoft Azure data services and cloud-native data architecture.
• Hands-on experience with Azure Data Factory for data integration, pipeline development, and orchestration.
• Strong experience architecting, implementing, and optimizing Snowflake data warehouse solutions.
• Expertise in dbt for data transformation, modeling, testing, documentation, and deployment.
• Strong proficiency in SQL, Python and enterprise data modeling, including dimensional and normalized approaches.
• Experience designing modern data lakes, data warehouses, and cloud-based analytics platforms.
• Strong understanding of data governance, security, lineage, quality, and performance tuning.
• Experience with CI/CD, Azure DevOps, version control, and deployment automation.
• Excellent stakeholder management, communication, solution design, and technical leadership skills.

Preferred Skills

• Experience with Azure Databricks and Spark/PySpark.
• Knowledge of Azure Data Lake Storage Gen2 and Azure Synapse Analytics.
• Exposure to Power BI and enterprise analytics platforms.
• Experience in BFSI or Insurance domain is an advantage.
• Azure and/or Snowflake certifications are preferred.

Technology Stack

Category

Technologies

Cloud Platform

Microsoft Azure

Data Integration

Azure Data Factory (ADF)

Data Warehouse

Snowflake

Transformation

dbt

Storage

Azure Data Lake Storage Gen2

Data Processing

Azure Databricks, Spark/PySpark (preferred)

Database and Querying

SQL

DevOps

Azure DevOps, CI/CD

Reporting and Analytics

Power BI (preferred)

Key Competencies

• Azure Data Architecture
• Cloud Data Modernization
• Enterprise Data Modeling and Governance
• Data Platform and Solution Design
• Architecture Standards and Best Practices
• Technical Leadership and Mentoring
• Stakeholder Management and Communication

The posted range is the hiring range for this role — a subset of the broader range available to employees over time — and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process