Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Lead Architect

$150k - $200k

Fractal Analytics

Role Overview

We are looking for a Lead Architect – Azure & AI to join our growing data engineering practice. In this role, you will architect and deliver large-scale, cloud-native data solutions on Azure and Snowflake, enabling advanced analytics, ML/AI workloads, and enterprise data governance.

Key Responsibilities
  • Design, build, and optimize end-to-end data pipelines leveraging Azure Data Factory, Databricks, and Snowflake for large-scale data ingestion, transformation, and loading.
  • Develop and maintain ETL/ELT workflows for structured, semi-structured (JSON, XML, Parquet), and unstructured data from on-premises systems, cloud platforms, APIs, flat files, RDBMS, and streaming sources.
  • Write efficient, production-grade code in Python (PySpark) and SQL for advanced data transformations, workflow orchestration, and automation.
  • Architect scalable Snowflake solutions including schema design, Virtual Warehouse configuration, query performance tuning, and cost-efficient data storage and retrieval strategies.
  • Leverage Azure Synapse and Snowflake for advanced analytics and data warehouse solutions, including MPP (Massively Parallel Processing) architectures.
  • Partner with business and technology stakeholders to design DataMart and Data Lake solutions supporting analytics, reporting, and ML/AI use cases.
  • Implement data quality frameworks, governance policies, lineage tracking, and metadata management across multiple environments.
  • Optimize Spark workloads on Databricks for distributed processing at scale; deploy and manage reusable Notebooks and Jobs in production.
  • Integrate NoSQL stores (Cosmos DB, MongoDB, etc.) and build hybrid solutions spanning Snowflake and Azure services.
  • Leverage Azure Cognitive Search and Elasticsearch for indexing and unstructured data search integration.
  • Drive DevOps best practices including CI/CD pipelines, source control (Git), and automated deployments via Azure DevOps and Jenkins.
  • Ensure adherence to enterprise data security, cataloging, and access-control policies across all data assets.
Required Skills
  • 8+ years of experience as a Data Engineer with deep expertise in Azure Data Services (ADF, Synapse, Databricks) and Snowflake.
  • Strong background in the Insurance domain with hands‑on Azure Data Engineering experience (ADB + PySpark/Python + Snowflake).
  • Proficiency in SQL (complex queries, stored procedures, functions, views) and Python/PySpark programming.
  • Proven experience designing and implementing ETL/ELT pipelines with Azure Data Factory and orchestrating complex, multi‑step workflows.
  • Comprehensive Snowflake expertise: Star/Snowflake schema design, role‑based security, performance tuning, query optimization, and pipeline features (Snowpipe, Tasks, Streams).
  • Solid understanding of Spark architecture with hands‑on experience in performance tuning, data partitioning, and distributed processing.
  • Experience integrating data from RDBMS, SFTP, APIs, Kafka, Event Hub, and big‑data platforms (Hadoop, Hive).
  • Familiarity with NoSQL database design (Cosmos DB or equivalent) and streaming data pipeline patterns.
  • Knowledge of ML/AI data preparation workflows; ability to refactor traditional ML code for distributed execution on Spark/Databricks.
  • Strong command of Agile methodologies, DevOps practices, and CI/CD deployment frameworks.
Preferred Skills
  • Exposure to data search and indexing technologies such as Elasticsearch or Azure Cognitive Search.
  • Azure Data Engineer Associate certification (DP-200/201/203) or SnowPro Core/Advanced Architect certification.
  • Experience working on data platforms serving analytics and AI use cases in large enterprise environments.
Pay

The wage range for this role is $150,000 – $200,000, adjusted for geographic differential and other factors. You may also be eligible for a discretionary bonus for the current performance period.

Benefits

As a full‑time employee or a salaried employee working more than 30 hours per week, you will be eligible to participate in health, dental, vision, life insurance, and disability plans in accordance with the plan documents. You will be eligible for benefits on the first day of employment with the Company. Additionally, you are eligible to participate in the Company 401(k) Plan after 30 days of employment. The Company provides 11 paid holidays, 12 weeks of Parental Leave, and a “free time” PTO policy that allows flexibility for sick time or vacation.

EEO Statement

Fractal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

#J-18808-Ljbffr
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Lead Architect in New York, NY vacancy
  •  ...Lead Frontend Architect – React.js (Equities Trading & Risk Platform) ~ This is the most appropriate title because the role requires hands-on React development, enterprise UI architecture, technical leadership, and experience building data-intensive trading applications... 
    Suggested
    Full time
    Part time
    Work experience placement

    PTR Global

    New York, NY
    17 days ago
  • $125k - $150k

     ...Role: AI Lead Architect – RAG & Python Location: NYC, NY/Charlotte, NC We are At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry... 
    Suggested
    Full time
    Temporary work
    Flexible hours

    Synechron

    New York, NY
    10 hours ago
  • $150k - $170k

     ...Lead Architect, HayloARC HayloARC is looking for a talented Lead Architect to join our growing team. This position is located in our New York City office on a hybrid work schedule; three (3) days in office depending on business needs. This is a technical leadership... 
    Suggested
    Work at office
    Local area
    Immediate start

    Haymarket Media Group

    New York, NY
    1 day ago
  • $201.68k - $322.69k

     ...culture designed to celebrate differences. We believe that belonging leads to better outcomes and a stronger community of associates...  ...existing skills and learn new ones "I can succeed as a Lead Data Architect at Capital Group." As a Lead Data & AI Platform Architect,... 
    Suggested
    Temporary work
    Local area
    Flexible hours

    Capital Group

    New York, NY
    2 days ago
  •  ...Accenture helps the world's leading enterprises reinvent by building their digital core and unleashing the power of AI to create value at speed for organizations across industries. Our strategy is to be the reinvention partner of choice for our clients and lead in the... 
    Suggested
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    New York, NY
    2 days ago
  • $130.3k - $260.59k

    Lead Architect We're building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you'll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable... 
    Hourly pay
    Full time
    Temporary work
    Local area
    Immediate start
    Remote work

    Oak St. Health

    New York, NY
    2 days ago
  • Principal Ai Architect We're building a world of health around every individual — shaping a more connected, convenient and compassionate...  ...Summary We are looking for a Principal AI Architect to serve as the Lead Architect and top AI/ML technical authority for the Finance... 

    CVS Health

    New York, NY
    2 days ago
  • $157k - $235k

     ...wholly-owned subsidiary dedicated to making computing more human, in addition to Bitmoji, Saturn, and other digital services.SMC GTM Architect team is the engine driving growth across Snap's long tail small-customer business. Operating across the full advertiser lifecycle... 
    Full time
    Live in
    Work at office
    Local area

    Snap

    New York, NY
    1 day ago
  • $190k

     ...of perspectives to spark change. BCG delivers solutions through leading-edge management consulting along with technology and design,...  ...at the intersection of people and technology. As a Lead AI Tech Architect, you will collaborate on interdisciplinary teams of designers,... 
    Contract work
    Work at office
    Local area

    The Boston Consulting Group

    New York, NY
    3 days ago
  • $157k - $190k

     ...About the RoleYou join the Revenue Operations team, building and owning the data infrastructure that powers reliable reporting and leading a small team of analysts. You report to the Director of Business Intelligence and work closely with Sales, Finance, and Operations.... 
    Temporary work

    Samba TV

    New York, NY
    1 day ago
  • $141.2k - $278.3k

     ...scale operational outcomes without adding systems or complexity. Recruiting for this role ends on 12/31/2026. Work you’ll do The Lead Architect owns the technical vision for IntelligentOps solutions and is accountable for architectures that scale across clients,... 
    Work experience placement
    Local area

    Deloitte

    New York, NY
    1 day ago
  •  ...capabilities to provide even greater opportunities for our clients to differentiate and scale business growth.You Are:The Integration Lead Architect playing a pivotal role in ensuring that diverse software applications within an organization work seamlessly together.This... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    New York, NY
    1 day ago
  • $134.5k - $265.1k

     ...commercial strategy, data and analytics, Generative AI, digital products, marketing, commerce, sales, and service. As a Lead Business Transformation Architect specializing in Adobe Commerce, you will help clients define scalable commerce architectures that connect business... 
    Local area
    Visa sponsorship

    Deloitte

    New York, NY
    2 days ago
  • $190k

     ...and Risk functions. We balance vision with a pragmatic path to change transforming strategies into leading-edge tech platforms, at scale.What You'll DoLead AI Tech Architects - AI Platforms at BCG Platinion are:Collaborative. They are interdisciplinary team players who... 
    Work at office
    Local area

    The Boston Consulting Group

    New York, NY
    10 hours ago
  • A leading U.S. marketing firm is seeking a Social Media Manager to be the voice of its prepaid brands and architect of its digital presence. This role involves managing an editorial calendar, developing creative content that resonates with consumers, and driving brand engagement... 

    Mad

    New York, NY
    1 day ago
  • $124.42k - $201.85k

    Lead Pre-Sales Solutioner - Senior Portfolio Architect Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world... 
    Full time
    Local area
    Remote work

    Capgemini

    New York, NY
    2 days ago
  •  ...The Role: Lead Design Architect As The Lead Design Architect, you will define the look and feel of the new generation of the American Rowhome. You will drive the design from concept to construction. You will lead the design of a new residential catalogue, bespoke style... 
    Full time
    Relocation

    american-housing

    New York, NY
    8 days ago
  • The Manhattan Strategy Group (MSG) is seeking an Agenda Development and Speaker Coordinator to support USTDA with event management, logistics, outreach and related activities, including reverse trade missions, conferences, forums, workshops and trainings. This role develops...

    Manhattan Strategy Group

    New York, NY
    2 days ago
  •  ...Pega Lead Business Architect (LBA) - Iselin NJ or Charlotte NC - 2 days per week onsite - Start ASAP Requirements for LBA (Must) # Experience working on Pega projects # Minimum 10 years of experience as a BA, including 5–6 years in Pega # Experience in the... 
    Temporary work
    Work experience placement
    Immediate start
    2 days per week

    Next Ventures

    New York, NY
    a month ago
  •  ...evident and independently verifiable auditing. Migrate the team's existing agents onto the Core, launch new per-department agents and lead security reviews for continuous read access. Extend the Core from read to bounded write: logged actions, idempotency keys,... 
    Work from home

    Zero Hash

    New York, NY
    2 days ago
  • Integrations Architect Lead Cornerstone Building Brands, headquartered in Cary, North Carolina, is the largest manufacturer of external building products in North America with over $6 billion in annual revenue and an expansive national footprint that includes almost 20... 
    Work at office

    Cornerstone Building Brands

    New York, NY
    2 days ago
  • Job Title: Senior AWS Connect Solutions Architect & Lead Developer Location: Onsite Experience: 5-7 Years experience in Amazon Connect CX Transformation Project Duration: 9 Months (June 2026 - March 2027) Role Objective We are seeking a hands-on AWS Connect Architect... 
    Immediate start

    Pacer Group

    New York, NY
    2 days ago
  • GRC Lead Architect We are looking for an GRC Lead Architect to design and implement cloud governance, risk, and compliance architecture. The role will translate GRC requirements into enforceable technical policies and controls across cloud environments, ensuring security... 

    ATYETI

    New York, NY
    2 days ago
  •  ...located in Chicago. Job Description Act as the IT/SAP business architect supporting Supply Chain Operations Finance, designing and delivering technology solutions that improve business performance. Lead SAP Product Costing (CO-PC) processes, including standard costing... 
    Remote job
    Permanent employment
    Local area

    Michael Page International Inc.

    New York, NY
    2 days ago
  • Databricks Architect Role Overview: We are looking for a highly skilled Databricks Architect to design, build, and scale enterprise-grade...  ..., Gold layers) as a standard. Databricks Platform Leadership: Lead deployment and optimization of: Azure Databricks / AWS Databricks... 

    iLink Multitech Solutions

    New York, NY
    2 days ago
  • The Rosdev Group seeks an experienced editor to plan, coordinate, and edit written material for publication. You will verify facts, read and revise manuscripts, and develop compelling content ideas for diverse audiences. You will supervise reporters and editors, manage ...

    The Rosdev Group

    New York, NY
    10 hours ago
  • £75k - £90k per year

    Lead Building Regulations Principal Designer An established, independent Building Consultancy with a growing Building Safety offering is seeking a Lead Building Regulations Principal Designer to take ownership of its developing Building Regulations Principal Designer service... 

    Brandon James

    New York, NY
    2 days ago
  • $153.16k - $340k

     ...organization, apply now. We are currently seeking a Sr. Healthcare Architect and Transformation Leader (Remote) to join our team in Dallas,...  ...will serve as the senior technology executive responsible for leading all technology services, platforms, infrastructure,... 
    Remote job
    Temporary work
    Work at office
    Flexible hours

    The Nippon Telegraph and Telephone Corporation (NTT)

    New York, NY
    2 days ago
  • Sr. Healthcare Architect and Transformation Leader (Remote) NTT DATA Services is seeking a Sr. Healthcare Architect and Transformation Leader...  ...will serve as the senior technology executive responsible for leading all technology services, platforms, infrastructure,... 
    Remote job

    Sierra Systems, An Ntt Data Company

    New York, NY
    2 days ago
  • $190k

     ...of perspectives to spark change. BCG delivers solutions through leading-edge management consulting along with technology and design,...  ...at the intersection of people and technology. As a Lead AI Tech Architect, you will collaborate on interdisciplinary teams of designers,... 
    Full time
    Contract work
    Work at office
    Local area

    Boston Consulting Group

    New York, NY
    2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Lead Architect. Be the first to apply!