Business Intelligence Developer

Bargaining Unit: Non Represented - Professional

Rate of Pay: $46.19/hour + DOE

Summary

The Business Intelligence Developer will play a vital role in developing and maintaining the data infrastructure that powers strategic and operational decision-making. This position will focus on advanced SQL development using SQL Server Management Studio (SSMS), working with the EPIC Clarity Database and other enterprise data sources. The ideal candidate will be proficient in creating optimized SQL scripts, developing ETL processes, and designing data models to support dashboards, reports, and

ad hoc analysis. Collaboration with cross-functional teams is essential to identify reporting needs and deliver automated, scalable BI solutions.

Essential Duties And Responsibilities

• Develop and maintain complex SQL queries to extract and manipulate data from the EPIC Clarity Database and Skilled Nursing database.
• Collaborate with departments to gather and understand report requests and data requirements.
• Design and develop data specifications and write code for reporting and analytics.
• Create and maintain data models that support efficient data retrieval and analysis.
• Develop automated processes for data extraction, transformation, and loading (ETL) to streamline data operations.
• Ensure the accuracy and integrity of data by performing regular data quality checks and troubleshooting data discrepancies.
• Generate and distribute timely and accurate reports and dashboards to stakeholders.
• Provide technical support and training to end-users to ensure effective use of BI tools and data.
• Stay up to date with industry trends and advancements in BI technologies and practices.
• Demonstrate efficient work habits, meet deadlines, honor schedules, and coordinate resources and meetings in an effective and timely manner while demonstrating respect for others.
• Adhere to high standards in HIPAA privacy practices. Job duties require access to and availability of PHI on a daily basis.
• Demonstrate System Values in performance and behavior. Design, develop, and optimize advanced SQL queries and stored procedures in SQL Server Management Studio (SSMS) for data extraction, transformation, and analysis.
• Manage ETL workflows using SQL and other tools to integrate data from multiple sources including EPIC Clarity, Skilled Nursing databases, and external datasets.
• Collaborate with stakeholders to gather business requirements and translate them into scalable, automated BI solutions.
• Build and maintain relational data models, views, and indexes to support performance reporting, cost analytics, and operational dashboards.
• Ensure data accuracy and integrity through routine validation, troubleshooting, and reconciliation processes.
• Develop and maintain interactive dashboards and scheduled reports using BI tools (e.g., Power BI, Axiom).
• Document and standardize BI processes, queries, and logic to support long-term maintainability and knowledge transfer.
• Provide ongoing support, training, and consultation to users for self-service analytics and data literacy.
• Stay current with industry trends, emerging data technologies, and best practices to continuously improve BI capabilities.
• Demonstrate commitment to HIPAA compliance, data governance, and system security protocols.
• Participate in cross-functional initiatives that align BI efforts with organizational strategic goals.
• Comply with System policies and procedures.
• Perform other duties as assigned.
  
  

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Supervisory Responsibilities

No supervisory responsibilities.

Minimum Education/Experience

Bachelor's Degree (in Finance, Math, Computer Science or relevant field) and 3 or more years relevant experience.

Required Licenses/Certifications

EPIC Clarity Certification - Upon Hire

Other Experience/Qualifications

Required:

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or a related field.
• Minimum of 3 years of experience working with SQL and database management, preferably in a healthcare environment.
  
  

Preferred:

• Knowledge of programming languages such as Python or R
• Proficiency in writing complex SQL queries and working with large relational databases.
• Experience with EPIC Clarity Database and familiarity with healthcare data standards and regulations.
• Strong analytical skills and the ability to translate business requirements into technical specifications.
• Strong attention to detail and a commitment to data accuracy and integrity.
• Ability to manage multiple projects and priorities in a fast-paced environment.