> Markdown version of [/jobs/ext/3339143-lead-data-engineer](https://www.wearedevelopers.com/jobs/ext/3339143-lead-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Data Engineer - **Company:** Analytical Mechanics Associates - **Location:** United States - **Experience:** Expert - **Salary:** $130,000.0 - $155,000.0 - **Contract:** Permanent contract - **Skills:** Amazon S3, Data Analysis, Microsoft Azure, Continuous Integration, Data as a Services, Information Engineering, Data Governance, Data Infrastructure, Data Presentation, Data Vault Modeling, Data Visualization, Executive Information Systems, Data Flow Control, Python (Programming Language), Key Management, Release Management, Power BI, Computational Finance, Reverse Engineering, SQL Databases, SQL Server Integration Services, Tableau (Software), Azure Data Factory, Sql Optimization, Snowflake, Apache Spark, Git, Microsoft Fabric, Data Lakes, Git Flow, Information Technology, Data Lineage, Domo, Data Pipelines, Api Management, Databricks - **Published:** September 23, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/18406929?backUrl=%2Fcareer%2F18406929%2FLead-Data-Engineer-California ## About the Role * BA/BS in a technical field including but not limited to mathematics, information technology, engineering, accounting, or computational finance. * 5 plus years of professional experience in business analytics or data engineering, with a minimum of 5 years of hands-on experience with BI visualization tools such as Power BI, Tableau, DOMO or equivalent platforms. * Strong production experience with Databricks, Snowflake, Azure Data Factory, or a comparable modern cloud data platform. * Advanced SQL and Python skills. * Experience building production ingestion, transformation, and analytics pipelines. * Experience implementing data governance, quality monitoring, lineage, and access controls. * Experience reverse-engineering and modernizing legacy SQL, SSIS, or integration workloads. * Experience with Git, Azure DevOps, CI/CD, testing, and controlled production releases. * Experience with Databricks, Snowflake, Azure Data Factory, or a comparable modern cloud data platform. * Experience with Data Vault 2.0 or another governed historical modeling approach. * Ability to communicate effectively with both technical teams and non-technical business stakeholders. * Demonstrated ownership of solutions from design through production support. * Strong documentation, troubleshooting, and problem-solving skills. * Must have a primary place of business in the Central Time Zone. Desired Qualifications: * Certification in data visualization with Power BI. * Experience with Microsoft Fabric Lakehouse, Warehouse, Data Pipelines, Dataflow Gen2, DirectLake, and semantic models. * Experience with Spark, Delta Lake, dbt, or dbt-fabric. * Proficiency in DAX, Tableau, or other BI visualization tools. * Experience with API integrations, vendor-file automation, and workflow automation. * Experience with AWS-based data services (Lambda, S3, Glue, Athena). * Familiarity with Azure Key Vault, service principals, managed identities, and Microsoft Purview. * Experience setting technical standards and mentoring engineers or analysts. * Master's degree in Data Science, Applied Mathematics, or a related field. ## Description Analytical Mechanics Associates (AMA) is seeking a full-time Lead Data Engineer with deep experience in data engineering, reporting, analytics, and end-to-end data platform development. The qualified candidate will join a hybrid project team (Central Time Zone) supporting dashboard development, data pipeline modernization, and governed analytics delivery in an agile environment., * Brainstorm and lead analytics product design including dashboard layouts, visualization approaches, and semantic model architecture. * Design and develop production-grade reports and dashboards, including direct stakeholder engagement and KPI validation. * Build certified Power BI semantic models, executive dashboards, operational reporting, and governed self-service analytics. * Design and implement data pipelines using tools such as Databricks, Azure Data Factory, or Snowflake, following a structured layered architecture (Raw, Transformed, Analytics). * Implement automated data quality checks, reconciliation, pipeline monitoring, alerts, and operational support dashboards. * Reverse-engineer and modernize legacy SQL, SSIS, or integration workloads into maintainable modern patterns. * Establish and enforce engineering standards for SQL, Python, notebooks, repositories, testing, documentation, and naming conventions. * Implement Azure DevOps branching strategies, CI/CD pipelines, release management, and environment separation. * Design enterprise data governance frameworks including column-level documentation, role-based access controls, standardized metric definitions, and full data lineage traceability. * Partner with business leaders and stakeholders to translate operational and analytical needs into scalable technical solutions. * Assist in the technical direction of the overall project team covering two primary work streams: data environment and data presentation. * Mentor team members and help establish a consistent, collaborative engineering culture. * Help troubleshoot and overcome technical issues, proactively detecting data issues through automated validation and monitoring. ## Related Videos - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Why Git Still Matters](https://www.wearedevelopers.com/videos/100288-why-git-still-matters) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [GitLab CI pipelines for a whole company](https://www.wearedevelopers.com/videos/143-gitlab-ci-pipelines-for-a-whole-company) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)