Lead Data Engineer: Modernize Pipelines & Analytics (Hybrid)

Analytical Mechanics Associates Inc.; United States; Hybrid; USD 130,000 - 155,000; Full time

Benefits offered by this job

401(k) matching plan

Tuition reimbursement

Short/long-term disability plans

Medical/dental/vision insurance

Job summary

Analytical Mechanics Associates (AMA) seeks a Lead Data Engineer to advance end-to-end data platform development in a hybrid Central Time Zone team. You will drive analytics product design, build production dashboards, and modernize data pipelines using Databricks, Snowflake, and Azure Data Factory.

Strong SQL/Python and governance expertise are required to deliver governed analytics across stakeholders. You will mentor engineers, establish standards, and partner with business leaders to

Qualifications

• BA/BS in a technical field including but not limited to mathematics, information technology, engineering, accounting, or computational finance.
• 5+ years of professional experience in business analytics or data engineering with hands-on BI tool experience.
• 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 and non-technical stakeholders.
• 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.

Responsibilities

• Brainstorm and lead analytics product design including dashboard layouts, visualization approaches, and semantic model architecture.
• Design and develop production-grade reports and dashboards with KPI validation.
• Build certified Power BI semantic models, executive dashboards, and governed self-service analytics.
• Design and implement data pipelines using Databricks, Azure Data Factory, or Snowflake with layered architecture.
• Implement automated data quality checks, reconciliation, pipeline monitoring, alerts, and operational dashboards.
• Reverse-engineer and modernize legacy SQL, SSIS, or integration workloads.
• Establish and enforce engineering standards for SQL, Python, notebooks, repositories, testing, and documentation.
• Implement Azure DevOps branching strategies, CI/CD pipelines, release management, and environments.
• Design enterprise data governance frameworks with data lineage and access controls.
• Partner with business leaders to translate needs into scalable technical solutions.
• Mentor team members and guide two primary work streams: data environment and data presentation.
• Help troubleshoot, detect data issues through automated validation and monitoring.

Skills

Power BI

Tableau

DOMO

SQL

Python

Data governance

CI/CD

Git

Azure DevOps

Data Vault 2.0

Stakeholder communication

Education

BA/BS in a technical field

Master’s degree (preferred)

Tools

Databricks

Snowflake

Azure Data Factory

Spark

dbt-fabric

Microsoft Fabric Lakehouse

Job description

Analytical Mechanics Associates (AMA) seeks a Lead Data Engineer to advance end-to-end data platform development in a hybrid Central Time Zone team. You will drive analytics product design, build production dashboards, and modernize data pipelines using Databricks, Snowflake, and Azure Data Factory.

Strong SQL/Python and governance expertise are required to deliver governed analytics across stakeholders. You will mentor engineers, establish standards, and partner with business leaders to