Lead Data Engineer
Manager
Analytics
Azure DevOps
Big Data
Business Analytics
Business Intelligence
Cloud Data Warehouse
Cloud Platform
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Governance
Data Integration
Data Management
Data Pipeline
Data Platform
Data Processing
Data Quality
Data Security
Data Vault
Data Visualization
Data Warehouse
Database
Databases
DevOps
Devops Tools
Digital Marketing
Engineer
ETL
Hr Technology
Informatica
Integration
Management
Microsoft
Power BI
Power Platform
Project Management
Reporting and Analytics
Software Development
SQL
Visual Design
Job Description
Analytical Mechanics Associates (AMA) is hiring a Lead Data Engineer for a full-time, hybrid role in California. This position focuses on end-to-end data platform development, reporting and analytics delivery, and leading analytics product design. You will work in a collaborative, agile environment aligned to the Central Time Zone, helping modernize pipelines, strengthen governance, and mentor engineers and analysts.
What you’ll do
- Drive analytics product design, including dashboard layouts, visualization approach, and semantic model architecture.
- Design and develop production-grade reports and dashboards, partnering with stakeholders to validate KPIs and ensure correct interpretation.
- Build Power BI semantic models for executive and operational dashboards, supporting governed self-service analytics.
- Design and implement data pipelines using tools such as Databricks, Azure Data Factory, or Snowflake, organized around a layered architecture: Raw, Transformed, and 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 engineering standards for SQL, Python, notebooks, repositories, testing, documentation, and naming conventions.
- Implement Azure DevOps branching strategies, CI/CD, release management, and environment separation.
- Design enterprise data governance frameworks, including column-level documentation, role-based access controls, standardized metric definitions, and end-to-end data lineage traceability.
- Translate business operational and analytical needs into scalable technical solutions with business leaders and stakeholders.
- Provide technical direction across two work streams: data environment and data presentation.
- Mentor team members and reinforce a consistent, collaborative engineering culture.
- Troubleshoot technical issues and proactively detect data problems using automated validation and monitoring.
What you bring
- BA/BS in a technical field, including mathematics, information technology, engineering, accounting, or computational finance.
- 5+ years of professional experience in business analytics or data engineering, including at least 5 years hands-on with BI visualization tools such as Power BI, Tableau, DOMO, or equivalents.
- 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 Data Vault 2.0 or another governed historical modeling approach.
- Ability to communicate effectively with technical teams and non-technical business stakeholders.
- Demonstrated ownership from design through production support, with strong documentation, troubleshooting, and problem-solving skills.
- Must have a primary place of business in the Central Time Zone.
Tools you’ll work with
Power BI, Tableau, DOMO, Databricks, Azure Data Factory, Snowflake, SQL, Python, SSIS, Azure DevOps, CI/CD, Git, Data Vault 2.0, DAX.
Preferred qualifications
- Power BI data visualization certification.
- 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.
Compensation: USD 130,000 - 155,000 per year.
Similar Jobs
