Analytics Engineer

Sunshine Behavioral Health is a leader in recovery. Our mission is to provide the highest quality substance abuse treatment services and deliver them with passion, integrity, and company spirit. Through our programs, individuals receive the tools to overcome their alcohol/drug dependencies and learn to manage co-occurring disorders.

As part of our mission, we rely on data to drive operational excellence, support clinical decision-making, and ensure we're delivering the best possible outcomes for our patients. Our modern data platform is at the core of this strategy, transforming data from EMRs, billing systems, and operational tools into actionable insights.

We are looking for an Analytics Engineer to own the transformation layer of our data platform, working closely with our senior data engineer who handles infrastructure and architecture. In this role, you will build andmaintainthe DBT models and data pipelines that power business intelligence across our organization, manage our Tableau Cloud environment, and collaborate directly with clinical, operational, and finance teams to ensure they have reliable, accessible data.

This position, based out of our Denver office, is perfect for someone who enjoys the technical challenge of data modeling and pipeline development while also working directly with stakeholders to understand their reporting needs. You'lltake ownership of analytics engineering workflows—from data transformation to dashboard management—while partnering with senior engineering on larger architectural initiatives. If you're passionate about using data to improve healthcare outcomes and want to grow your analytics engineeringexpertise, we'd love to hear from you!

• DBT Development:
  Build,maintain, and optimize
  
  DBT models that transform raw data from healthcare systems into clean, well-modeled datasets for analytics and reporting.
• Tableau Management:
  Manage Tableau Cloud including data connections, published data sources, and collaborate with stakeholders to build andoptimizereports and dashboards.
• Data Modeling:
  Design and implement data models (dimensional models, fact tables, aggregated views) that balance performance with usability for business reporting.
• Pipeline Monitoring:
  Monitor data pipeline health, troubleshoot data quality issues, and ensure reliable data delivery to downstream consumers.
• SQL Development:
  Write complex SQL queries to explore data,validatetransformations, build analytical views and tables, and support ad-hoc analysis requests.
• Stakeholder
  
  Collaboration:
  
  Partner with clinical operations, finance, admissions, and other departments to understand reporting requirements and translate them into data solutions.
• Documentation & Standards:
  Document data transformations,maintain data catalog, and helpestablishanalytics engineering best practices and standards.
• Data Quality:
  Implement data quality checks, validation rules, and testing within DBT to ensure accuracy and reliability of analytical datasets.

• Technical & Business-Minded:
  You understand both the technical aspects of data engineering and the business context of how data supports decision-making.
• Detail-Oriented:
  You have an exceptional eye for data quality and accuracy, and you take pride in building reliable, well-tested pipelines.
• Collaborative Communicator:
  You enjoy working directly with stakeholders and can translate business requirements into technical solutions while explaining technical concepts to non-technical audiences.
• Self-Sufficient & Resourceful:
  You're comfortable working independently, troubleshooting issues, and knowing when to elevate to senior engineering resources.
• Continuous Learner:
  You're eager to expand your skills in modern data engineering, cloud technologies, and analytics best practices.

Required:

• 3+ years of experience working with data, including building data models and ability to write complex
  
  SQL queries involving joins, aggregations, window functions, and CTEs in production environments.
• 3+ years of experience with DBT including writing, testing, and maintaining models.
• Mid-level Tableau experience, including managing Tableau Cloud…