Senior Analytics Engineer: Data Modeling & BI Lead

Moser Consulting; Indianapolis (IN); Hybrid; USD 115,000 - 149,000; Full time

Benefits offered by this job

Fully Invested 401K Plan

PPO and HDHP Medical Plans

Employer-Paid Dental and Vision Plans

Onsite Fitness Center

Catered Lunches

Training Opportunities

Job summary

Moser Consulting in Indianapolis is seeking a Senior Analytics Engineer to own the transformation layer of data platforms, designing, building, and maintaining data models powering dashboards and AI solutions.

You will collaborate with data engineers and business stakeholders to turn raw data into clean, well-documented datasets, exploring new tools and approaches while advocating data-driven decisions.

Qualifications

• 5+ years of experience in analytics engineering, data engineering, or a closely related role.
• Experience with a cloud data warehouse, such as Snowflake, Databricks, or similar.
• Strong SQL skills with the ability to write transformations that are performant, readable, and maintainable.
• Deep knowledge of dimensional modeling (Kimball), including SCD handling and fact table selection.
• Experience working with BI tools (Power BI, Tableau, Sigma, or similar) and understanding semantic/metric layers.
• Ability to investigate anomalies and demonstrate problem-solving skills to resolve data issues.
• Comfort using agentic AI workflows to accelerate development and problem-solving.
• Demonstrated ability to document data models clearly for both technical and non-technical audiences.
• Excellent communication skills and a track record of partnering with business stakeholders.

Responsibilities

• Design, build, and maintain scalable data models that serve as the foundation for analytics.
• Partner with analysts and business teams to translate requirements into clean, reusable data assets.
• Establish and enforce data modeling best practices, testing standards, and documentation conventions.
• Implement data quality tests and own resolution of data issues.
• Collaborate with data engineers on ingestion pipelines and warehouse architecture decisions.
• Build and maintain BI semantic layers and expose clean interfaces for reporting and self-serve analytics.
• Review and mentor analytics engineers and analysts on SQL, modeling patterns, and tooling.
• Drive the adoption of analytics engineering standards across the organization.
• Contribute to the evaluation and rollout of new data tooling (e.g., orchestration, observability, BI platforms).

Skills

SQL

Data Modeling

Python

dbt

Power BI

DAX

Airflow

GitHub

Cloud Data Warehouse

Analytical Thinking

Tools

Dagster

Dagster

Spark

Tableau

Sigma

Job description

Moser Consulting in Indianapolis is seeking a Senior Analytics Engineer to own the transformation layer of data platforms, designing, building, and maintaining data models powering dashboards and AI solutions.

You will collaborate with data engineers and business stakeholders to turn raw data into clean, well-documented datasets, exploring new tools and approaches while advocating data-driven decisions.