Sunshine Behavioral Health · 14 hours ago
Analytics Engineer
Denver, CO
Full-time
Hybrid
Mid Level
$90K/yr - $110K/yr
3+ years expSunshine Behavioral Health is a leader in recovery, aiming to provide high-quality substance abuse treatment services. They are seeking an Analytics Engineer to manage the transformation layer of their data platform, build and maintain DBT models, and collaborate with various teams to ensure reliable data delivery for informed decision-making.
HealthcareAddiction TreatmentHealth Care
Responsibilities
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 and optimize reports 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, validate transformations, 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 help establish analytics 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
Qualification
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 connections, published data sources, and building reports
Experience monitoring data pipelines and troubleshooting data quality or transformation issues
Preferred
Experience in healthcare, particularly with EMR systems, billing data, or clinical operations
Familiarity with AWS data services (Athena, Glue, S3, MWAA) and cloud concepts
Experience with Apache Airflow or similar orchestration tools
Python experience for data tasks and pipeline development
Understanding of healthcare data compliance requirements (HIPAA)
Exposure to data lakehouse architectures
Experience with version control (Git) and CI/CD practices
Knowledge of dimensional modeling and data warehouse design principles
Benefits
PTO
Health Insurance
401k match
Annual bonus potential based on company performance
A hybrid work model with flexibility to balance office and remote work, with3 days in office and 2 days remote.
Opportunities for professional growth and development in analytics engineering and modern data technologies.
A collaborative, mission-driven environment where your work directly supports patient care and treatment outcomes.
Access to mentorship from experienced senior engineering team members.
Company
Sunshine Behavioral Health
Substance abuse treatment in California with centers across the country. Our staff is capable of offering multiple treatment styles at once.
201-500 employees
H1B Sponsorship
Sunshine Behavioral Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2023 (1)
2021 (2)
Funding
Current Stage
Growth StageLeadership Team
J. Brandon Turner
Chief Financial Officer
Company data provided by crunchbase