Data Architect

This is a fully remote position, open to applicants in New Jersey.

📋 Description

• Design and create scalable, secure, and high-performance data architectures on Microsoft Azure.

• Architect comprehensive data platforms utilizing Azure services, Snowflake, and dbt.

• Define enterprise data models, integration patterns, architecture standards, and reusable frameworks.

• Lead data migration and modernization projects from legacy systems to Azure and Snowflake.

• Design and enhance 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.

⛳️ Requirements

• Bachelor's degree in engineering, computer science, or a related field.

• 8+ 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.

• Significant experience in 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 both dimensional and normalized approaches.

• Experience in 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.

• 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 the BFSI or Insurance domain is a plus.

• Azure and/or Snowflake certifications are preferred.

🏝️ Benefits

• Benefits information provided at https://www.exlservice.com/us-careers-and-benefits.

• Work from home.