Business Intelligence Developer

The Business Intelligence Developer will play a vital role in designing, developing and maintaining the data solution that powers strategic and operational decision-making.

Requirements

• 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.
• Demonstrate System Values in performance and behavior.
• Design, develop, and optimize advanced SQL queries and stored procedures 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. Microsoft Fabric, 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.
• Demonstrates System Values in performance and behavior.
• Complies with System policies and procedures.
• Other duties as may be assigned.