Note: The job is a remote job and is open to candidates in USA. Jefferson Center for Mental Health is an inclusive mental health organization seeking a Senior Analytics Engineer. The role designs trusted data products, dimensional models, semantic layers, and curated datasets while enabling self-service reporting, predictive modeling, and AI applications. It also partners with clinical and operational leaders to identify analytics opportunities and provides technical leadership on cloud and AI technologies.
Responsibilities
- 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
- 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
- Integrate automated ML and forecasting outputs into enterprise data structures for downstream reporting
- Build user-friendly semantic models to support self-service analytics across Power BI, Microsoft Fabric, and modern cloud platforms
- Educate and coach business users on report consumption, governance standards, and analytical tools
- Collaborate with clinical and operational leadership to identify high-value analytics opportunities and translate complex findings into business recommendations
- Serve as a technical SME for analytics engineering, evaluating emerging cloud and AI technologies to elevate team maturity
Skills
- 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
- 3+ years in healthcare analytics
- 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
- Experience with behavioral health, Medicaid, claims, or value-based care preferred
Benefits
- This position can be fully remote, although occasional onsite work may be required.
Company Overview