Wherescape Data Jobs

1 job found

27d ago

Analytics Engineer II

Kootenai Health Coeur d'Alene, ID 🇺🇸 Remote

Coeur d'Alene, ID

27d ago

Full time Senior Analytics Business Analytics

Apply Now

Job Description

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

View full job page →

Get Job Alerts

New jobs delivered to your inbox.