Business Intelligence Developer

Kootenai Hospital; Coeur d'Alene (ID); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Medical coverage

Dental & vision

Tuition assistance

Retirement plan with employer match

Competitive pay with shift different

Wellness program

PerkSpot discounts

Referral bonus

Job summary

Kootenai Health is seeking a Business Intelligence Developer (BID) to own the BI lifecycle from requirements to deployment. You will design SQL scripts, build data models, and develop data extraction processes for CAH and clinic reporting.

The role supports data validation and production monitoring, with remote-friendly options within the United States. Collaborate with CAH and Clinic leaders to design reports, test deployments, and ensure data accuracy.

Qualifications

• Bachelor’s degree in related field preferred, or equivalent education/experience required
• 5 years’ of professional experience, with 3 years’ experience in health care required
• 3 years’ experience writing SQL reports required
• Experience with relational databases required (ex: SQLServer, PostgreSQL, Oracle)
• Experience with Meditech Expanse Data Repository strongly preferred
• Experience with ETL tools preferred (SSIS, Data Factory, etc.)
• Strong interpersonal skills with an ability to independently manage customer expectations

Responsibilities

• Designs, develops, and optimizes data extraction processes to support CAH and Clinic reporting, including generating data for third-party extract files and data visualizations
• Uses various software applications such as Microsoft SSMS, Microsoft SSIS, spreadsheets, data visualization software, and other Business Intelligence applications to assemble, manipulate and/or format data
• Creates and maintains logical data models as needed for reporting solutions using best practices within the BI environments
• Creates and maintains process or procedure documentation
• Creates and maintains documentation explaining developed data models, column business logic, field mapping, etc., in accordance with team data governance standards
• Collaborates with CAH and Clinic Quality, Financial, and Business leaders on report requirements, design, validation and optimization to meet quality, safety, financial, and efficiency needs
• Collaborates with team analysts to test and validate CAH and clinic reports after installation and implementation of system patches, service utilities, and version upgrades as assigned
• Troubleshoots and resolves issues in production jobs and other related solutions, escalation as necessary
• Participates in the after hours team on-call rotation and performs service recovery efforts as required
• Manages multiple tasks simultaneously and reacts to problems quickly
• Performs other related duties as assigned
• Familiar with standard concepts, practices, and procedures within the field
• Relies on experience and judgment to plan and accomplish goals
• Regular and predictable attendance is an essential job function
• Competent to meet age specific needs of the unit assigned

Skills

SQL reports

Relational databases

ETL tools

Data visualization

Education

Bachelor’s degree in related field

Tools

SSMS

SSIS

Data Factory

Job description

Business Intelligence Developer

Position Summary

The Business Intelligence Developer (BID) is responsible for all stages of the business intelligence lifecycle: understanding business objectives, gathering and translating requirements into technical solutions, designing and developing SQL scripts, scheduling and deployment of business intelligence components in accordance with supplied standards and best practices, and completing accurate and timely documentation. This position collaborates with business and technology departments to understand system data and its use, data analysis and validation, and providing support around the data and how it is integrated. This position monitors production systems for issues and resolves issues or elevates them for resolution when necessary. This position will be supporting reporting needs for the Critical Access Hospitals (CAHs) and Clinics.

This position is US-Remote Eligible. Currently,KootenaiHealth employees cannot be located in: California, Hawaii, Massachusetts, Minnesota, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Dakota, Rhode Island, Vermont, Washington D.C., West Virginia, or Wyoming. This list is continuously evolving and may be updated.

Responsibilities

• Designs, develops, and optimizes data extraction processes to support CAH and Clinic reporting, including generating data for third-party extract files and data visualizations
• Uses various software applications such as Microsoft SSMS, Microsoft SSIS, spreadsheets, data visualization software, and other Business Intelligence applications to assemble, manipulate and/or format data
• Creates and maintains logical data models as needed for reporting solutions using best practices within the business intelligence environments
• Creates and maintains process or procedure documentation
• Creates and maintains documentation explaining developed data models, column business logic, field mapping., etc., in accordance with team data governance standards
• Collaborates with CAH and Clinic Quality, Financial, and Business leaders on report requirements, design, validation and optimization to meet quality, safety, financial, and efficiency needs
• Collaborates with team analysts to test and validate CAH and clinic reports after installation and implementation of system patches, service utilities, and version upgrades as assigned
• Troubleshoots and resolves issues in production jobs and other related solutions, escalation as necessary
• Participates in the after hours team on-call rotation and performs service recovery efforts as required
• Manages multiple tasks simultaneously and reacts to problems quickly
• Performs other related duties as assigned
• Familiar with standard concepts, practices, and procedures within the field
• Relies on experience and judgment to plan and accomplish goals
• Regular and predictable attendance is an essential job function
• Competent to meet age specific needs of the unit assigned

Requirements and Minimum Qualifications

• Bachelor’s degree in related field preferred, or equivalent education/experience required
• 5 years’ of professional experience, with 3 years’ experience in health care required
• 3 years’ experience writing SQL reports required
• Experience with relational databases required (ex: SQLServer, PostgreSQL, Oracle)
• Experience with Meditech Expanse Data Repository strongly preferred
• Experience with ETL tools preferred (SSIS, Data Factory, etc.)
• Strong interpersonal skills with an ability to independently manage customer expectations

Working Conditions

• Must be able to maintain a sitting position
• Must be able to lift and move up to 10 lbs
• Must be able to reach arms above or below shoulder height
• Typical equipment used in an office job
• Repetitive movements

About Kootenai Health

Kootenai Health is a highly esteemed healthcare organization serving patients throughout northern Idaho and the Inland Northwest. We have been recognized with many accolades and distinctions, including being a Gallup Great Workplace, No. 1 Best Place to Work in Large Healthcare Organizations, and Magnet Status for Nursing Excellence. We pride ourselves on our outstanding reputation as an employer and a healthcare provider.

As your next employer, we are excited to offer you:

• Comprehensive medical coverage, including fully employer-paid options for eligible full-time employees, plus affordable plans for part‑time staff.Benefits begin on the 1st of the month following 30 days of employment.
• Dental, vision, life, and pet insurance, with telemedicine and wellbeing resources available to all employees
• Tuition assistance after 90 days to support your professional growth
• Retirement plans with pre-tax and Roth options and employer matching from 3%-6%
• Competitive pay, plus night, weekend, and PRN shift differentials
• Award-winning wellness program with coaching, financial wellness resources, and free or discounted access to fitness centers and premium wellbeing apps
• PerkSpot discountsproviding access to thousands of exclusive deals in over 25 categories
• And an employee referral bonus program

Kootenai Health provides exceptional support for extraordinary careers. If you want to work on a high-quality, person-centered healthcare team, we can't wait to meet you!

Kootenai Health complies with applicable federal civil rights laws and does not discriminate on the basis of race, color, national origin, age, disability, veteran status, or sex. Kootenai Health does not exclude people or treat them differently because of race, color, national origin, age, disability, veteran status, or sex.

A variety of medical, dental, and vision insurance plans are available to both full and part-time employees, with some available at no cost to the employee. In addition, benefit-eligible employees also gain access to the following:

• Tuition assistance and career development programs
• Robust Retirement Plan
• Night, weekend and PRN shift differentials
• Employee referral bonus program

What makes a successful employee at Kootenai Health?