Sr. Business Intelligence Engineer

Overview

Senior Business Intelligence Engineer

Location
:
Franklin, TN, or Remote

Our Mission

Acadia Healthcare’s purpose is to Lead Care With Light and our mission is to be a world-class organization that sets the standard for excellence in the treatment of mental health and addiction concerns. We strive to maintain our standing as a thought leader in the behavioral healthcare industry, providing treatment that is synonymous with compassion and innovation.

About the Role

We are looking for an experienced Senior Business Intelligence Engineer to architect, build, and maintain the data infrastructure of our reporting stack. In this role, you will collaborate with stakeholders across business units to understand data needs and then design optimal technical solutions leveraging tools like Snowflake, Airflow, etc. on Cloud platforms (Azure preferred).

Compensation & Benefits

We value your expertise and dedication—and we invest in your success.

• Competitive Base Salary commensurate with experience
• Comprehensive Medical, Dental, and Vision Insurance
• 401(k) Plan with Company Match
• Paid Time Off (PTO) and recognized holidays
• Company-paid Basic Life and AD&D Insurance
• Employee Assistance Program (EAP) and mental wellness resources
• Opportunities for professional growth and advancement within Acadia’s nationwide network

Essential Functions

Data Modeling and Integration

• Develop and maintain complex data models, including relationships, hierarchies, and calculated columns.
• Integrate data from multiple sources, ensuring consistency and accuracy

Report and Dashboard Development

• Design and create interactive, visually compelling reports and dashboards using Power BI Desktop.
• Implement advanced features like bookmarks, drill-through actions, and custom visuals

Advanced Data Analysis

• Perform complex data analysis using DAX (Data Analysis Expressions) to create calculated measures and solve intricate business problems
• Develop advanced DAX calculations for financial, statistical, or performance analysis

Performance Optimization

• Optimize report and dashboard performance by improving data queries, data model efficiency, and report rendering speed
• Identify and address bottlenecks and resource constraints

Data Transformation and ETL

• Handle complex data transformation and ETL (Extract, Transform, Load) processes, including handling data from multiple sources and dealing with complex data structures

Data Governance and Security

• Implement data governance practices, including data access controls, role-level security, and data lineage documentation
• Ensure compliance with data protection regulations

Collaboration and Requirements Gathering

• Collaborate closely with business analysts, stakeholders, and end-users to gather and refine requirements for reports and dashboards
• Act as a bridge between technical and non-technical stakeholders

Mentoring and Leadership

• Guide and mentor junior developers and team members in best practices and advanced techniques in Power BI
• Lead projects and ensure the delivery of high-quality business intelligence solutions

Standard Expectations

• Complies with organizational policies, procedures, performance improvement initiatives and maintains organizational and industry policies regarding confidentiality
• Communicate clearly and effectively to person(s) receiving services and their family members, guests, and other members of the health care team
• Develops constructive and cooperative working relationships with others and maintains them over time
• Encourages and builds mutual trust, respect, and cooperation among team members
• Maintains regular and predictable attendance

Education/Experience/Skill Requirements

• BS degree in Computer Science, Engineering or equivalent field
• Deep hands-on development and administration experience with Snowflake
• 5+ years hands-on engineering and administration experience in data engineering on cloud platforms (Azure preferred) with RDBMS such as SQL Server, Postgre
  
  SQL, MySQL.
• Extensive working experience with Azure ADF, ADLS and Synapse
• Expert knowledge of the Microsoft Power Platform Suite is REQUIRED
• Experience building and optimizing data pipelines at scale with orchestration tools like…