Analytics Engineer II
Position Summary
The Analytics Engineer II is a senior technical contributor responsible for the full data and analytics lifecycle, with a focus on independently designing, developing, and optimizing complex SQL code, ETL pipelines, and advanced data models. This role supports enterprise-wide analytics initiatives by building scalable, high-performance data solutions across both on-premises and cloud platforms. The Analytics Engineer II collaborates with business and technology teams, provides mentorship, and ensures best practices in data modeling, integration, and governance. Monitors production systems for issues and resolves issues or elevates them for resolution when necessary.
Your location:
This position is US-Remote Eligible. Currently, Kootenai Health 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 advanced SQL code and complex data models independently to support data integration, transformation, and reporting needs across multiple healthcare data systems, including Epic and non-Epic platforms
- Leads the development and maintenance of robust ETL pipelines using modern tools (e.g., SSIS, Data Factory, WhereScape, APIs, etc.) to ensure reliable and scalable data movement and transformation
- Builds and maintains analytics solutions on cloud platforms such as Microsoft Fabric, Azure, AWS, or equivalent following guidance and standards from the Data Architect
- Develops logical and physical data models, ensuring alignment with enterprise data architecture and governance standards
- Collaborates with business and technology stakeholders to gather requirements, validate data, and deliver actionable insights
- Creates, maintains, and documents scalable data models, reports, and dashboards using BI tools (e.g., Power BI, Tableau, SSRS, Crystal Reports)
- Troubleshoots and resolves complex issues in production data pipelines and analytics solutions, escalating as necessary
- Contributes to the development and enforcement of standard operating procedures and best practices within the analytics team
- Mentors and provides technical guidance to Analytics Engineer I and other team members
- Relies on experience and judgment to plan and accomplish goals
- Regular and predictable attendance is an essential job function
- Performs other related duties as assigned
- Competent to meet age-specific needs of the unit assigned
Requirements and Minimum Qualifications
- Bachelors’ degree in a related field or equivalent education/experience required; Master’s degree preferred
- Minimum 10 years of analytics experience, with at least 10 years focused on advanced SQL code writing and data modeling in large-scale environments
- Demonstrated ability to independently design and implement complex data models and ETL solutions
- Epic Caboodle and Clarity certification/accreditation required or obtained within 90 days of hire; must remain current in certification thereafter
- At least one additional Epic data model certification/accreditation required (Clinical Data Model, Revenue Data Model, Access Data Model, etc.)
- Other required system application training/certifications to complete assigned work as necessary
- Microsoft Fabric Analytics Engineer (DP-600 or DP-700) certification preferred
- Experience with ETL tools strongly preferred (SSIS, Data Factory, etc.)
- Data Warehousing experience with Microsoft Fabric toolset strongly preferred
- Data Visualization experience using a variety of BI tools preferred (Power BI, SSRS)
- Comprehensive understanding of clinical or business principles to evaluate information system and healthcare regulatory needs
- Experience with other healthcare EMRs and technology strongly preferred (Meditech, Nextgen, Greenway, Midas, etc.)
- Strong interpersonal skills with an ability to independently manage customer expectations
- Leadership and mentoring experience preferred
- Participate in after-hours on-call rotation and service recovery efforts as required
Working Conditions
- Must be able to lift and move up to 10 lbs
- Must be able to reach arms above or below shoulder height
- Must be able to maintain a sitting position
- Typical equipment used in an office job
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:
- Kootenai Health offers comprehensive medical plan options, including options for fully paid employer premiums for our full-time employees. For part-time employees, we offer the same plan options with affordable part-time premiums. In addition to medical insurance, we offer many voluntary benefits ranging from dental and vision to life and pet insurance. Kootenai Health also offers well-being resources and telemedicine service options to all employees, regardless of benefit eligibility. Benefits begin on the 1st of the month following 30 days of employment.
- Kootenai Health’s tuition assistance program is available after 90 days. If you want to further your education, we'll help you pay for it
- Kootenai Health sponsors retirement plans for employees that enable you to save money on a pre-tax and Roth after tax basis for your retirement. Kootenai Health will match your contributions based on years of service ranging from 3-6 percent.
- Competitive salaries with night, weekend, and PRN shift differentials
- An award-winning and incentive-driven wellness program. Including a MyHealth corporate team, onsite financial seminars, and coaching
- Employees receive discounts at The Wellness Bar, PEAK Fitness, various cell phone carriers, and more
- Employee referral program that pays you for helping great people join the team
- And much more
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!
Apply today!
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.
#KHHP25
Location: Kootenai Health · Analytics Administration
Schedule: Full Time, Days
