Lead Data Engineer

Analytical Mechanics Associates

. Lead analytics product design, including dashboard layouts, visualization approaches, and semantic model architecture .

Posted 9/22/2026full-timeRemote • California • United StatesSenior💰 $130,000 - $155,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in analytics product design, including dashboard development and data governance frameworks, while effectively engaging stakeholders to translate business needs into scalable technical solutions. Proficient in implementing data pipelines and ensuring data quality through advanced SQL and Python skills.

Highest-signal resume keywords

Power BI VisualizationDatabricks Data EngineeringAdvanced SQL SkillsData Governance ImplementationCI/CD Pipeline Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonData Pipeline DevelopmentData Quality MonitoringData Vault 2.0Azure Data FactorySnowflakeGitSSISDashboard Design

Soft Skills

Effective CommunicationProblem-SolvingTroubleshootingMentoringCollaboration

Tools & Technologies

Power BITableauDOMOAzure DevOpsCI/CDNotebooksOperational ReportingData LineageRole-Based Access ControlsProduction Support

Industry Keywords

Business AnalyticsData EngineeringTechnical DirectionLegacy System ModernizationCentral Time Zone

Tech Stack

Tools & technologies

AzureCloudPythonSQLSSISTableauVault

About the role

Key responsibilities & impact

Lead analytics product design, including dashboard layouts, visualization approaches, and semantic model architecture
Design and develop production-grade reports and dashboards
Engage stakeholders directly and validate KPIs
Build certified Power BI semantic models, executive dashboards, operational reporting, and governed self-service analytics
Design and implement layered data pipelines using Databricks, Azure Data Factory, Snowflake, or comparable tools
Implement automated data quality checks, reconciliation, pipeline monitoring, alerts, and operational support dashboards
Reverse-engineer and modernize legacy SQL, SSIS, or integration workloads
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 documentation, role-based access controls, metric definitions, and data lineage
Translate business and analytical needs into scalable technical solutions
Assist with technical direction across data environment and data presentation work streams
Mentor team members and help establish a collaborative engineering culture
Troubleshoot technical issues and proactively detect data issues through validation and monitoring

Requirements

What you’ll need

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
Minimum 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 Data Vault 2.0 or another governed historical modeling approach
Ability to communicate effectively with 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
Must be a US citizen or Permanent Resident

Benefits

Comp & perks

Paid personal leave
Federally recognized holiday leave
Salary deferrals into a 401(k)-matching plan with immediate vesting
Tuition reimbursement
Short-term disability plan
Long-term disability plan
Medical insurance options
Dental insurance options
Vision insurance options
Professional growth opportunities
Engaging, collaborative, and supportive work environment