Senior BI Engineer (REMOTE)

Jefferson Center for Mental Health; Wheat Ridge (CO); Presencial; USD 120.000 - 170.000; Jornada completa

Descripción de la vacante

Jefferson Center for Mental Health seeks a Senior Analytics Engineer to bridge data engineering, BI, and AI, building trusted data products and self-service reporting. You will enable predictive analytics, curate data pipelines, and collaborate with stakeholders to transform healthcare data into actionable insights.

The role emphasizes dimensional modelling, star schemas, and scalable data architectures across Power BI and modern cloud platforms.

Formación

• Bachelor's degree or higher in Analytics, Computer Science, Information Systems, or related quantitative field (or equivalent practical experience).
• 5+ years in Analytics Engineering, Data Engineering, or Senior BI/Data Modeling roles.
• Experience with behavioral health, Medicaid, claims, or value-based care preferred.

Responsabilidades

• Design, develop, and maintain analytics-ready data models and curated data marts.
• Translate business requirements into scalable data structures and standards.
• Curate feature tables and datasets for predictive modeling and AI-enabled analytics.
• Prepare data pipelines and semantic layers for AI-enabled experiences and self-service analytics.
• Serve as a technical SME for analytics engineering and evaluate cloud/AI technologies.

Conocimientos

SQL

Python

R

Dimensional modeling

Star schemas

Enterprise data warehouse

Semantic models

Time-series forecasting

Trend analysis

AutoML

Predictive feature store

GitHub Copilot

Claude

Educación

Bachelor's degree or higher in Analytics/CS/IS

Herramientas

Azure Data Factory

Microsoft Fabric

dbt

Snowflake

Databricks

AzureML

REST APIs

Descripción del empleo

Job Description At Jefferson Center, it is our policy and our mission to be inclusive and mindful of the diversity of everyone who comes through our doors. We are passionate about building a community where mental health matters and equitable care is accessible to all races, ethnicities, abilities, socioeconomic statuses, ages, sexual orientations, gender expressions, religions, cultures, and languages.
The Senior Analytics Engineer bridges data engineering, business intelligence, advanced analytics, and emerging AI capabilities. This role designs and develops trusted data products, enables self-service reporting, prepares data for predictive modeling and AI-applications, and partners with stakeholders to turn healthcare data into actionable insights.

Analytics Engineering & Data Architecture

Design, develop, and maintain analytics-ready dimensional models (star schemas, semantic layers) and curated data marts.
Translate business requirements into scalable, performant data structures that promote consistency across analytics solutions.
Establish standards and best practices for data modeling, metric definitions, performance tuning, and data governance.

Advanced Analytics & AI Enablement

Curate feature tables and datasets for predictive modeling, time-series forecasting, risk scoring, and population health analysis.
Prepare and optimize data pipelines and semantic layers for AI-driven experiences, Microsoft Fabric Copilots, and RAG/knowledge retrieval tools.
Build user-friendly semantic models to support self-service analytics across Power BI, Microsoft Fabric, and modern cloud platforms.

• Integrate automated ML and forecasting outputs into enterprise data structures for downstream reporting.

Business Partnership & Technical Leadership

Serve as a technical SME for analytics engineering, evaluating emerging cloud and AI technologies to elevate team maturity.

Work Experience

Bachelor's degree or higher in Analytics, Computer Science, Information Systems, or related quantitative field (or equivalent practical experience).

• 5+ years in Analytics Engineering, Data Engineering, or Senior BI/Data Modeling roles.
• Experience with behavioral health, Medicaid, claims, or value-based care preferred.

Expert-level SQL, Python, R.
Dimensional modeling (Kimball), star schemas, enterprise data warehouse architecture, semantic models.
Experience with Azure Data Factory, Microsoft Fabric, dbt, Snowflake, Databricks, AzureML, REST APIs
Time-series forecasting, trend analysis, exposure to Automated ML (AutoML), and predictive feature store construction.
Proficiency with AI-assisted development tools (e.g., GitHub Copilot, Claude) for code generation, documentation, and pipeline optimization.

Application Deadline : This position will remain posted until filled.