Sr. Business Intelligence Engineer

Acadia Healthcare•Franklin, TN

23h•Remote

About The Position

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).

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, PostgreSQL, 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 AirFlow and observability tools like ELK
Excellent communication skills collaborating cross-functionally with stakeholders
Self-directed and passionate about keeping up with latest innovations in the data space
Strong analytical and problem-solving skills to interpret complex data
Excellent communication skills to collaborate with stakeholders and present findings
Ability to manage multiple projects and meet deadlines
Experience in mentoring junior developers and leading BI projects
Extensive experience with Power BI Desktop, Power BI Service, and Power BI Mobile
Strong skills in creating complex reports, dashboards, and data visualizations
Proficiency in data modeling, including creating relationships, hierarchies, and calculated columns
Advanced knowledge of DAX (Data Analysis Expressions) for creating complex calculations
Experience with ETL (Extract, Transform, Load) processes using Power Query and other tools
Ability to handle data integration from multiple sources
Experiences with Azure cloud services such as ADLS, ADF, Fabric
Strong SQL skills for querying and managing databases
Familiarity with database management systems like Snowflake, Azure SQL, etc.
Experience with dbt modeling
Ability to develop automation and flows on Power platform using PowerApp and Power Automate
Experience with Airflow for data pipeline orchestration

Nice To Haves

API development experience is a plus

Responsibilities

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
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

Benefits

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume