Senior Analytics Engineer

This is a fully remote position, open to applicants in Arizona, +21 more states.

📋 Description

• Take ownership of the interface between the data platform and the business, encompassing models, metrics, and dashboards.

• Design and develop dbt staging, intermediate, and mart models incorporating incremental logic, tests, and comprehensive documentation.

• Implement dimensional modeling and grain discipline to generate accurate, efficient, and reusable models.

• Establish core business metrics as reliable sources of truth.

• Categorize sensitive data, ensure lineage and documentation are maintained, and set model-level data quality expectations.

• Create and sustain the semantic layer linking marts and dashboards.

• Collaborate with the business to harmonize conflicting metric definitions.

• Develop dashboards and reporting in Omni utilizing well-structured data.

• Oversee row-level security, performance, and access in a regulated, multi-tenant environment.

• Convert ambiguous business inquiries into modeled metrics and practical dashboards.

• Investigate dashboard or reconciliation issues through the BI layer, models, and source data to identify root causes.

• Set conventions for analytics structure, testing, deployment, project layout, CI/CD, and the logic between dbt and BI.

• Evaluate analytics work and refine modeling and BI practices.

• Disseminate knowledge through code reviews, collaborative work, and documentation.

⛳️ Requirements

• 7–9+ years in analytics engineering, data engineering, or BI, with significant hands-on experience in the modeling and reporting layer.

• Extensive dbt knowledge: project design, incremental models, tests, macros, exposures, and thorough documentation.

• Proficient in dimensional and semantic modeling, including design, grain decisions, metric definition, and establishing a reusable single source of truth.

• Advanced SQL skills and proficiency with a cloud warehouse like Snowflake or a similar platform.

• Strong BI/dashboarding capabilities in tools such as Omni, Looker, Power BI, Tableau, or similar, with expertise in row-level security and performance optimization.

• Clear project organization and conventions, robust Git and CI/CD practices, and sound judgment regarding logic placement across dbt and BI layers.

• Ability to interpret ambiguous business questions and convert them into modeled metrics and clear dashboards.

• Excellent communication skills with non-technical stakeholders.

• Experience with AI-assisted development tools such as Claude Code, Cursor, or Copilot.

• Quick, iterative working style; adaptability to ambiguity and commitment to enhancing existing systems.

• Nice to have: experience in regulated industries and familiarity with sensitive or PHI data.

• Nice to have: experience with a dedicated semantic or metrics layer.

• Nice to have: experience in decision-support or analytical workloads.

• Nice to have: experience as an early or primary dedicated analytics engineer.

• Nice to have: mentoring experience or involvement in establishing analytics standards.

🏝️ Benefits

• A comprehensive benefits package designed to support employees both professionally and personally.

• Employees are encouraged to work from the Chicago office, whether they are local or just passing through.