Lead Data Engineer

We’re Hiring: Lead Data Engineer Location: California, USA (Bay Area – Local Candidates Only) - Onsite Employment Type: W2 Only - NO H1 Experience: 6+ Years of Genuine Hands-on Experience Required We are seeking an experienced, hands-on Senior Data Engineer to design, build, and scale modern data platforms supporting enterprise analytics, business intelligence, and healthcare data integrations. This role involves working with SQL Server, Azure, Databricks, Snowflake, and Python in real-world production environments, with a strong focus on cloud modernization and scalable data architecture. Key Responsibilities:- Design and maintain scalable ETL/ELT pipelines across cloud platforms Lead migration of on-prem SQL Server workloads to Azure (ADF, Synapse, ADLS, Fabric) Architect and optimize data warehouses, data marts, and lakehouse architectures Work with healthcare data systems (EHR, HL7, FHIR, HIPAA-compliant environments) Develop integrations using REST APIs, CDC, and event-driven architectures Implement dimensional modeling and performance tuning strategies Build batch and streaming pipelines using Spark and Kafka Collaborate with BI, ML, and business stakeholders Establish monitoring, data quality checks, and CI/CD processes Core Skills:- Advanced SQL and performance tuning Azure (ADF, Synapse, Azure SQL, ADLS, Fabric) Databricks, Snowflake, BigQuery Python (PySpark), Scala Spark (batch & streaming), Kafka ETL tools (ADF, SSIS, Airflow, dbt) BI tools (Power BI preferred) DevOps and data governance best practices Nice to have: Healthcare domain experience, Databricks administration, real-time architecture experience, ML pipeline exposure. Interested candidates (local to Bay Area only, with 6+ years of genuine experience) may share their resume at: devang@acrtechnology.com Pay: $55.00 - $65.00 per hour Work Location: In person