Business Intelligence Architect - Behavioral Healthcare

At Discovery Behavioral Health, we know the best way to predict the future of healthcare is to create it.  As a member of our growing team, you will have a voice in the creation of life-changing programs and treatment centers nationwide.  Working collaboratively with the best and the brightest in our industry, you will be part of an innovative team of professionals committed to generating positive and remarkable outcomes for the clients we serve. If you are looking for an organization that thrives on growth, celebrates diversity of thought, and rewards passionate execution, you’ve come to the right place.  Because we put clients first, it is our honor to support and reward those who serve them.

Compensation Range: $114-123k per year

Compensation will be dependent upon geographic region, education, and experience 

Our Offer to You!

We are dedicated to empowering our employees with their professional and personal development by providing:

• 401(k) 
• Healthcare benefits
• Vacation and sick days
• Employee referral program
• Employee discounts to various stores, amusement parks, events, etc.
• Continuing education (CE) programs and training
• Weekly training opportunities
• Advancement opportunities within the organization

Reporting to the VP of Information Services, the BI Architect plays a crucial role in developing and supporting data management systems, including integration with Access Information Management System (AIMS) and other clinical/financial systems.  The BI Architect is responsible for directly supporting the daily administration of the Business Intelligence solutions, developing advanced administration, and reporting management tools, and guiding the aggressive expansion of our complex Business Intelligence and Data Warehouse (BI/DW) environment. They prioritize data quality through governance measures, ensuring that the information is reliable and accurate. The BI Architect collaborates with cross-functional teams to design, develop, and implement BI reports and dashboards, utilizing underlying data sources to meet business needs. They are also responsible for the technical design, development, documentation, testing, implementation, and support of various data models, ensuring seamless operations. 

Essential Job Functions: This role requires a self-motivated, detail oriented, positive, collaborative, and organized individual with the ability to maintain flexibility and take ownership of projects and processes. Must be a problem solver and address issues in a timely manner. Additionally: 

• Develop, design, and maintain Power BI dashboards, reports, and data models. 

• Develop and implement stored procedures. 

• Develop, maintain, and administer complex ETL processes within the Azure SQL database environment utilizing SSIS. 

• Develop, troubleshoot, and fine tune existing and new reports. 

• Facilitate the development of data integration efforts. 

• Develop, manage, and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements. 

• Perform database administration tasks, including application performance tuning, workload management, disaster recovery strategies, and application architecture enhancements. 

• Proactively monitor and report on system performance key performance indicators (KPIs), providing visibility into resource utilization for different workloads, such as ETL and BI tools. 

• Execute database development tasks, such as loading/unloading data, managing external tables, optimizing table distribution, identifying, and resolving data skew issues, and optimizing query plans for improved performance. 

• Collaborate with cross-functional teams to gather requirements and build solutions. 

• Develop and implement best practices for data visualization and report design. 

• Keep up to date with the latest developments in Power BI, data warehouse, and related technologies.  

• Travel may be required to support company locations. 

• Other duties as assigned. 

• Bachelor's degree in computer science, Information Systems, or related field. 

• Minimum 5-7 years’ related experience working with healthcare business analytics. 

• At least 8 years of experience in developing and implementing Power BI solutions. 

• At least 5 years of experience in Azure Analysis Services. 

• At least 5 years of experience in advanced SQL queries. 

• At least 4 years of experience in stored procedures. 

• Experience in creation and management of data warehouse API integrations. 

• Experience in designing and developing data visualizations using Power BI. 

• Strong analytical and problem-solving skills. 

• Knowledge of DAX, M, and Power Query is a plus. 

We are proud to be an EEO employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, or national origin.

For more information about our company benefits, please visit us at discoverybehavioralhealth.com/careers/

Discovery Behavioral Health seeks to build a diverse staff that is reflective of the patients we serve and the communities where we work. DBH encourages multiple perspectives, experiences, and strives to hire and retain a diverse workforce.