Lead Architect

Fractal Labs
New York
Workplace: OnsiteFull timeUSD 150,000 - 200,000 annuallyFunction: Data Analytics & Business IntelligenceExperience: 8+ yearsSkills: []

Architect and deliver large-scale, cloud-native data solutions on Azure and Snowflake for Fortune 500 clients. Build and optimize end-to-end data pipelines and ETL/ELT workflows using Azure Data Factory, Databricks, Spark, and production-grade Python/PySpark and SQL. Design Snowflake warehousing and performance, implement data governance, lineage, and quality frameworks, and drive DevOps CI/CD for resilient analytics, DataMart/Data Lake, and ML/AI-ready data.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Fractal Labs
Fractal Labs
1 month ago

Lead Architect

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Status: Live

Job Summary

Architect and deliver large-scale, cloud-native data solutions on Azure and Snowflake for Fortune 500 clients. Build and optimize end-to-end data pipelines and ETL/ELT workflows using Azure Data Factory, Databricks, Spark, and production-grade Python/PySpark and SQL. Design Snowflake warehousing and performance, implement data governance, lineage, and quality frameworks, and drive DevOps CI/CD for resilient analytics, DataMart/Data Lake, and ML/AI-ready data.
Location: New York
Workplace: Onsite
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence

Key Responsibilities

  • •Design, build, and optimize end-to-end data pipelines using Azure Data Factory, Databricks, and Snowflake for large-scale ingestion and transformation.
  • •Develop ETL/ELT workflows for structured, semi-structured, and unstructured data from on-premises systems, APIs, flat files, RDBMS, and streaming sources.
  • •Write production-grade Python (PySpark) and SQL for data transformations, workflow orchestration, and automation.
  • •Architect Snowflake solutions including schema design, Virtual Warehouse configuration, query performance tuning, and cost-efficient storage/retrieval.
  • •Implement data quality, governance, lineage tracking, and metadata management across multiple environments, plus DevOps CI/CD deployment practices.

Pay and Benefits

Salary: USD 150,000 - 200,000 annually
Perks:Health InsuranceDentalVisionLife InsuranceDisability401kPaid HolidaysParental LeavePaid Leave

Key Requirements

  • •8+ years as a Data Engineer with deep expertise in Azure Data Services (ADF, Synapse, Databricks) and Snowflake.
  • •Hands-on Azure Data Engineering experience in the Insurance domain.
  • •Strong proficiency in SQL (stored procedures, functions, views) and Python/PySpark for data transformations and orchestration.
  • •Experience designing and implementing ETL/ELT pipelines with Azure Data Factory for multi-step workflows.
  • •Comprehensive Snowflake expertise (schema design, role-based security, performance tuning, and pipeline features).
Experience:8+ yearsInsuranceCloud data platformsEnterprise analyticsML/AIData governanceETL/ELT
Certifications:Azure Data Engineer Associate (DP-200/201/203)SnowPro CoreSnowPro Advanced Architect
Tech Stack:Azure Data FactoryDatabricksSnowflakePythonPySparkSQLAzure SynapseSparkAzure Cognitive SearchElasticsearchGitAzure DevOpsJenkinsCosmos DBMongoDBJSONXMLParquetSFTPAPIs

Company Brief

Fractal Labs
Provides AI-driven analytics, decision intelligence, and engineering solutions to Fortune 500 companies, helping enterprises apply advanced analytics and machine learning for marketing, supply chain, finance, and customer experience transformation.
Industry: Consulting
Company Size: Enterprise (1,001+ employees)
Growth: Established Company
Headquarters: New York, United States
Founded: 2000
WebsiteLinkedIn