Business Intelligence Developer III

Alameda Health System; California (MO); On-site; USD 72,000 - 120,000; Full time

Job summary

Alameda Health System is seeking a BI Developer to translate business needs into data solutions, design and deploy reporting tools, and maintain data analytic platforms. You will build dashboards, ETL processes, and data warehouses while mentoring junior BI staff.

A key focus is enabling data-driven decisions in healthcare with Epic Cogito, Clarity, and Caboodle. The role requires an Associate’s degree, five years of BI experience in healthcare, and Epic certifications; compensation includes a

Qualifications

• Associate’s degree required.
• Bachelor’s degree preferred.
• Five years of BI/analytics experience, preferably in healthcare.
• Certifications: Epic Cogito, Clarity, Caboodle, and a Clinical, Access, or Revenue Cycle data model.

Responsibilities

• Collect and analyze business requirements to design BI solutions.
• Develop interactive reporting and data solutions using BI tools.
• Create, maintain, and support reports, dashboards, and metrics for business insight.
• Maintain data environments and data sets for data users including Data Scientists and Analysts.
• Perform ETL to pull data from source systems and place in data warehouse.

Skills

ETL development

SQL / T-SQL

SSIS

SSAS

Data modeling

Education

Associate’s degree in related technology field

Bachelor’s degree in related field

Tools

Epic Cogito

Epic Clarity

Epic Caboodle

Clinical Data Model

Access

Job description

Summary

Responsible for translating business needs into technical specifications and building data solutions, and for the design and deployment of reporting tools, maintenance of data analytic platforms, and the creation of database objects to store and transform data.

DUTIES & ESSENTIAL JOB FUNCTIONS

NOTE: Following are the duties performed by employees in this classification. However, employees may perform other related duties at an equivalent level. Not all duties listed are necessarily performed by each individual in the classification.

• Collect and analyze business requirements in order to develop, design, and build BI solutions.
• Leverages best practices and industry standards to develop interactive reporting and data solutions using business intelligence tools.
• Creates, maintains, and support reports, visualizations, dashboards, and metrics that provide business insight and aid business decision-making.
• Creates, maintains, and supports data environments and/or data sets to serve a wide range of data users, including but not limited to Data Scientists, Data Analysts, Business Analysts, etc.
• Extends, supports, and maintains existing data warehouse infrastructures with new dimensionality and new data sources using SSIS, T-SQL, and SSAS.
• Improves data governance and data quality using Master Data Management systems (MDS, DQS and others).
• Performs ETL work to pull data from source systems (both on prem and hosted), including manipulating data, and placing in the data warehouse environment.
• Programs complex SQL queries and stored procedures.
• Mentors activities of BI Developer I/II incumbents, providing guidance and both formal and informal training.
• Performs other duties as assigned.

Minimum Qualifications

Any combination of education and experience that would likely provide the required knowledge, skills and abilities as well as possession of any required licenses or certifications is qualifying.

Required Education: Associate’s degree in related technology field: Information Systems, Software Engineering, Computer Programming, Computer Science, Database Management, or related field.

Preferred Education: Bachelor’s degree in Information Management, Computer Science, Project Management, Engineering, or related field.

Required Experience: Five years of technical experience in a business intelligence related position; technical experience working with data analytics in a healthcare related field.

Required Licenses/Certifications: Epic Cogito, Clarity, Caboodle, and Clinical, Access, or Revenue Cycle Data Model certifications.

Pay Range: $52.46 - $87.44 / Hour

The pay range for this position reflects the base pay scale for the role at Alameda Health System. Final compensation will be determined based on several factors, including but not limited to a candidate’s experience, education, skills, licensure and certifications, departmental equity, applicable collective bargaining agreements, and the operational needs of the organization. Alameda Health System also offers eligible positions a generous comprehensive benefits program.