Business Intelligence Developer III - CommonSpirit Health

***This position is remote.

The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and geographies and will lead the effort in developing Dignity Health’s Medicaid population health care management pathways. Dignity Health MSO is dedicated to providing quality managed care administrative and clinical services to medical groups hospitals health plans and employers with a business objective to excel in coordinating patient care in a manner that supports containing costs while continually improving quality of care and levels of service. Dignity Health MSO accomplishes this by capitalizing on industry-leading technology and integrated administrative systems powered by local human resources that put patient care first.

Dignity Health MSO offers an outstanding Total Rewards package that integrates competitive pay with a state-of-the-art flexible Health & Welfare benefits package. Our cafeteria-style benefit program gives employees the ability to choose the benefits they want from a variety of options including medical dental and vision plans for the employee and their dependents Health Spending Account (HSA) Life Insurance and Long Term Disability. We also offer a 401k retirement plan with a generous employer-match. Other benefits include Paid Time Off and Sick Leave.

***This position is remote.

Position Summary:

The Business Intelligence Developer III develops reports and data warehouses to monitor Population Health Services Organization's (PHSO) key performance indicators and meet regulatory reporting requirements by providing the necessary data to business stakeholders. This expert role is responsible for creating and maintaining computer-based analytics solutions to support the company's financial, clinical, and operational projects.

Responsibilities may include:
- Support and maintenance of custom and third-party business intelligence applications, reviews business requirements, reviews system capabilities, analyzes product performance, determines product requirements, schedules software installation and upgrades, troubleshoots problems, trains end users, works with department directors, managers and end users to assess software application needs and provides input and recommendations to IT Management.
- Works closely with Business Analytics and Project Management staff, identifies data requirements of both internal and external requestors and develops solutions to ensure that those requirements are met.
- Performs data extracts from databases in response to internal requests for data and/or reports, validates extracted data set to ensure that the requestor's needs are met,formats extracted data based on the requestor's requirements and provides report writing support to the organization by developing requested reports, assisting individuals with their report requirements, and instructing groups of users in classroom training sessions.
- Completes routine tasks related to database performance and maintenance, writing stored procedures, creates custom views and manages automated jobs.
- Designs, develops, tests, documents, implements and maintains data warehouses and reports, consults with current and proposed systems users to discuss and document requests for new and/or modified system changes,identifies design alternatives and recommends computer-based solutions. Drives quality improvements through Python-based automation, implementing robust testing frameworks and monitoring solutions to optimize data reliability and performance. Develops predictive and prescriptive models to enhance population health performance.
- Project Planning, prepares routine project descriptions and needs assessments for new and/or enhanced system modifications.
- Assists with the administration of the company-wide data warehouse by performing validation on the warehouse data, populating data cubes for online analytical processing (OLAP) as required by company analysis needs, writing SQL statements to generate proper data extracts and train end users on 3rd-party OLAP tools.
- Performs less complex database and spreadsheet tasks associated with business intelligence including modifying OLAP cubes and data models,creating database queries and stored procedures, extracting, transforming and loading data and generating pivot tables or cross tabs.
- Provides routine support and maintenance of basic electronic data interchange (EDI) solutions, monitors and works EDI transaction sets on a daily basis ensuring accurate and timely communication of data, ensures the automated transfer of files, claims and requests to and from vendors and other partners, are received and processed according to specification. Evaluates daily and weekly EDI transactions and takes appropriate action to resolve errors or discrepancies in a timely manner, develops new and modifies existing EDI transactions as directed and ensures EDI policies and procedures comply with corporate policies and objectives.
- Establishes, develops, documents, and maintain EDI procedures including management of document repository, identification of errors and corrective action and reconciliation of EDI transactions through coordination of information with internal and external customers, and trading partners.

Minimum Qualifications:

- 5-7 years of industry experience working in a role requiring knowledge and management of business intelligence concepts and processes is required. Experience in design, development, testing, documentation, implementation and maintainence of data warehouses and reports.
- Experience using Microsoft Excel, Google Workspace, and third-party reporting tools such as Crystal Reports, Business Objects, or Cognos, and/or ETL tools such as Microsoft SSIS or BizTalk, and/or relational database management systems such as Oracle, Microsoft SQL Server or MySQL.
- Associate degree required with coursework including, but not limited to, database modeling, design, and querying, business information systems, business statistics, e-commerce systems, or related course.
- Expert knowledge of data governance, data management, data modeling, data cleansing, data extraction and transformation, data migration, data integration and data mapping.

- Expert knowledge of standard HIPAA EDI transaction sets and secure communications. Abliity to write advanced SQL statements to generate proper data extracts and training end users on 3rd- party OLAP tools. Ensures EDI policies and procedures comply with corporate policies and objectives.

- Expert-level understanding of theoretical and practical aspects of data information systems: Spreadsheet manipulation, management, and reporting.  Database structure and design Database querying, ETL, index management, and SQL performance tuning and monitoring.  Installation, implementation, integration, training, and support for custom and third-party software solutions.
- Expert-level proficiency in Python for data manipulation, analysis, and automation tasks. Deep understanding of SQL for performance optimization, database administration, and advanced querying. Extensive experience with multiple BI tools and platforms, with the ability to architect and implement complex BI solutions. Strong leadership skills to lead BI development teams and projects. Knowledge of advanced analytics techniques and machine learning concepts.

Preferred Qualifications:

- 5+ years of experience for additional software utilized by Business Intelligence Developers such as SQL, Tableau, Power BI and Python is preferred.
- Bachelor's or Master's degree in computer science, mathematics, management information systems, or a closely related field preferred.
- 5+ years of advanced certifications or coursework in Python programming, data science, and machine learning preferred. Significant professional experience in BI development, including Python development preferred.
- Experience in leadership roles is preferred.

#LI-DH