Analytics Engineer II

Analytics Engineer II oversees the full data and analytics lifecycle at Kootenai Health, focusing on designing, developing, and optimizing SQL code, ETL pipelines, and advanced data models across on premise and cloud platforms while mentoring teammates and upholding data governance.

Responsibilities

• Design, develop, and optimize advanced SQL code and complex data models independently to support data integration, transformation, and reporting across multiple healthcare data systems, including Epic and non Epic platforms.
• Lead the development and maintenance of robust ETL pipelines using modern tools such as SSIS, Data Factory, WhereScape, APIs, and more to ensure reliable and scalable data movement and transformation.
• Build and maintain analytics solutions on cloud platforms such as Microsoft Fabric, Azure, AWS, or equivalents following guidance from the Data Architect.
• Develop logical and physical data models aligned with enterprise data architecture and governance standards.
• Collaborate with business and technology stakeholders to gather requirements, validate data, and deliver actionable insights.
• Create, maintain, and document scalable data models, reports, and dashboards using BI tools such as Power BI, Tableau, SSRS, and Crystal Reports.
• Troubleshoot and resolve complex issues in production data pipelines and analytics solutions, escalating as necessary.
• Contribute to the development and enforcement of standard operating procedures and best practices within the analytics team.
• Mentor Analytics Engineer I and other team members, providing technical guidance.
• Plan and accomplish goals using experience and judgment.
• Regular and predictable attendance is an essential job function.
• Performs other related duties as assigned.
• Competent to meet age-specific needs of the assigned unit.

Requirements

• Bachelor's degree in a related field or equivalent education/experience; 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 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 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.
• Participation in after-hours on-call rotation and service recovery efforts as required.

Technologies

• SQL
• SSIS
• Data Factory
• WhereScape
• APIs
• Microsoft Fabric
• Azure
• AWS
• Epic Caboodle
• Epic Clarity
• Power BI
• Tableau
• SSRS
• Crystal Reports
• DP-600
• DP-700

Benefits

• Comprehensive medical plan options with fully paid employer premiums for full-time employees; affordable premiums for part-time employees.
• Voluntary benefits including dental, vision, life, and pet insurance; well-being resources and telemedicine options for all employees.
• Tuition assistance after 90 days to support continuing education.
• Retirement plans with pre-tax and Roth after-tax options; employer matching contributions based on years of service (3–6%).
• Competitive salaries with night, weekend, and PRN shift differentials.
• Wellness program with MyHealth corporate team, on-site financial seminars, and coaching.
• Discounts at The Wellness Bar, PEAK Fitness, various cell phone carriers, and more.
• Employee referral program that rewards helping great people join the team.
• And more.

Your Location

• US remote eligible
• Not eligible to work 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

Schedule

• Full Time, Days

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 office environment and equipment
• Repetitive movements

About Kootenai Health

• Recognized as a Gallup Great Workplace
• No. 1 Best Place to Work in Large Healthcare Organizations
• Magnet status for Nursing Excellence
• Serving patients across northern Idaho and the Inland Northwest

Location and Schedule

• Location: Kootenai Health Analytics Administration
• Schedule: Full Time, Days