Lead Data Engineer – Databricks, Microsoft Fabric, Snowflake & Azure

Precision Technologies; New Jersey; Hybrid; USD 130,000 - 185,000; Full time

Job summary

Precision Technologies is seeking an experienced Lead Data Engineer to design, develop, and deliver scalable enterprise data platforms. The role requires hands-on expertise in Databricks, Snowflake, Azure Synapse, Fabric, and Power BI, with strong leadership capabilities.

Ideal candidates will have 8–12+ years in data engineering, with deep knowledge of ETL/ELT, lakehouse architecture, data modeling, and cloud data engineering. Hybrid work options are available with W2 full-time employment.

Qualifications

• Experience leading data engineering teams and projects.
• Strong hands-on expertise with Databricks and modern cloud data platforms.
• Proficiency in building scalable ETL/ELT pipelines and data models.

Responsibilities

• Lead design and development of ETL/ELT pipelines, data lake, lakehouse, and data warehouse solutions.
• Develop and optimize data pipelines with Azure Databricks, PySpark, Python, SQL, ADF, and Synapse.
• Design and optimize Snowflake data warehouses and analytical models.
• Implement Delta Lake, medallion architecture, CDC, and incremental processing.
• Build curated datasets and semantic models to support Power BI analytics.
• Optimize Spark jobs, SQL queries, and cloud costs; ensure data quality and governance.
• Collaborate with architects, BI developers, data scientists, and stakeholders.

Job description

Employment Type: Full-Time (W2 Only)

Location: USA (Hybrid / Onsite)

Job Summary

We are seeking an experienced Lead Data Engineer with strong hands-on expertise in Databricks, Microsoft Fabric, Snowflake, Azure Synapse, Azure Data Factory, and Power BI to design, develop, and deliver scalable enterprise data platforms. The ideal candidate will have strong experience in ETL/ELT, Lakehouse Architecture, Data Warehousing, PySpark, SQL, Data Modeling, Delta Lake, and Cloud Data Engineering, along with proven technical leadership capabilities.

Key Responsibilities

• Lead the design and development of scalable ETL/ELT pipelines, Data Lake, Lakehouse, and Data Warehouse solutions.
• Develop and optimize data pipelines using Azure Databricks, PySpark, Python, SQL, Microsoft Fabric, Azure Data Factory (ADF), and Azure Synapse Analytics.
• Design, develop, and optimize Snowflake Data Warehouse solutions and analytical data models.
• Implement Delta Lake, Medallion Architecture, CDC, incremental data processing, schema evolution, and data quality frameworks.
• Build curated datasets, semantic models, and analytical data layers supporting Power BI reporting and enterprise analytics.
• Optimize Spark jobs, SQL queries, data pipelines, cluster utilization, storage, and cloud costs.
• Implement data integration solutions across Azure services, Snowflake, Databricks, Microsoft Fabric, and enterprise source systems.
• Develop batch and near real-time data processing solutions using modern cloud data engineering technologies.
• Implement CI/CD pipelines, Git-based development, automated deployments, monitoring, logging, and production support.
• Establish data governance, security, lineage, metadata, and access-control best practices.
• Conduct code reviews, architecture discussions, technical design sessions, and mentor Data Engineers.
• Collaborate with Data Architects, BI Developers, Data Scientists, Business Analysts, and business stakeholders to deliver enterprise data solutions.

Required Skills

• 8–12+ years of Data Engineering experience.
• Strong hands-on expertise in Databricks, PySpark, Python, and SQL.
• Strong experience with Microsoft Fabric, OneLake, Fabric Data Factory, Fabric Lakehouse, and Fabric Warehouse.
• Strong hands-on Snowflake experience including data warehousing and analytical workloads.
• Experience with Azure Synapse Analytics and Azure Data Factory (ADF).
• Strong understanding of Power BI, Semantic Models, Data Modeling, and DAX.
• Hands-on experience with Delta Lake, Lakehouse Architecture, Medallion Architecture, CDC, and incremental processing.
• Experience with Azure cloud services, CI/CD, Git, DevOps, data governance, and production support.
• Strong understanding of ETL/ELT, Data Warehousing, Data Lakes, Data Integration, and Distributed Data Processing.
• Strong communication, problem-solving, technical leadership, and stakeholder management skills.

Preferred Skills

• Unity Catalog
• Fabric Lakehouse / Fabric Warehouse
• Snowflake Streams & Tasks
• Microsoft Purview
• Terraform
• GitHub Actions
• Spark Structured Streaming
• Experience with Data Quality, Data Lineage, Metadata Management, and Data Governance

Technical Environment

Eligibility & Compliance

• W2 Full-Time Only
• No C2C
• No Third-Party Vendors or Consultancy Profiles