Business Intelligence Developer – Certified Caboodle Data Modeling

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, create, and maintain database objects such as tables, stored procedures, functions, and views.

• Develop intricate SQL queries for reporting, analytics, and data integration purposes.

• Ensure secure and automated delivery of file extracts through SFTP.

• Create custom reporting solutions within Epic Hyperspace, which includes Reporting Workbench and Cogito SQL reports.

• Develop Radar dashboards along with related Cogito build elements.

• Oversee the complete reporting lifecycle, encompassing design, development, testing, documentation, maintenance, and troubleshooting.

• Facilitate working sessions with OCHIN members, third-party vendors, and staff to design and implement technical solutions.

• Assist in requirements gathering, solution design, quality assurance testing, and user acceptance testing.

• Perform additional tasks as assigned.

⛳️ Requirements

• Certification or proficiency in Caboodle Data Modeling is preferred; proficiency must be achieved within the first 90 days if not already held.

• At least five years of experience in reporting within Epic.

• A minimum of five years of experience in complex SQL development.

• At least three years of experience with custom Caboodle data modeling.

• Experience with star schema.

• Minimum of three years of extensive knowledge utilizing SQL Hyperspace, SQL Metrix, and Cogito SQL.

• At least three years of experience with Slicer/Dicer.

• Completion of a 50–60-minute competency assessment is required prior to the team interview.

• Must be legally authorized to work in the United States on a permanent basis at the time of application.

• Proficiency in reading, speaking, writing, and understanding English is required.

• Ability to work independently and effectively from a home office.

• High-speed internet service is necessary.

• Must maintain a distraction-free workplace.

• COVID-19 vaccination or approved medical/religious exemption is required prior to the hire date.

• Must be able to appear on camera for all virtual meetings.

• Willingness to travel nationwide as needed for Go-Live installations or training.

🏝️ Benefits

• Competitive compensation package.

• Healthy work-life balance.

• Opportunities for professional growth and advancement.

• Comprehensive benefits package.

• Option to work remotely from home.

• COVID-19 vaccination or an approved medical/religious exemption.

• Work-from-home assistance to ensure a distraction-free home office environment and high-speed internet service.