CURRENT SPECTRUM HEALTH TEAM MEMBERS – Please apply through Find Jobs from your Workday team member account. This career site is for Non-Spectrum Health team members only.

Job Description

Job Summary

Under minimal supervision and collaborating across members of multiple teams develops, tests, and deploys ELT/ETL processes and self-service reporting assets to provide data exploration capabilities to end users, while adhering to organizational, departmental, team and governmental standards and regulations.

Actively participates in communication with data consumers to improve performance of processes connecting to data. Builds aggregated data marts, data sources and data models to support reporting from core Medical Management business systems, following enterprise architectural standards and designs.

Participates in providing operational support for systems and applications troubleshooting and maintenance, and ad-hoc support for incidents related to data warehouses, data sets and data pipelines. Participates in organizational Data Governance for data assets. Team members in this position are competent to work self-sufficiently in most activities but require instruction or guidance in others. Provides coaching to less-experienced Data Engineers

Essential Functions

• Under minimal supervision, develops, tests, and deploys ELT/ETL processes across multiple sources, targets and tools, and self-service reporting assets to provide data exploration capabilities to end users.
• Participates in communications with data consumers with a skill growth mindset, to improve performance of processes connecting to data, and shares best practices. Develops relationships and collaboration across teams to deliver timely and reliable information that enables users to uncover insight from information.
• Participates in providing operational support for systems and applications troubleshooting and maintenance support, and ad-hoc support for incidents related to data warehouses, datasets, and data pipelines. Provides support for data platforms, reporting assets, and ETL processes.
• Builds data marts and models, using a variety of sources and target systems, growing a better understanding of enterprise architectural standards and designs.
• Applies best practices and organizational standards of the Software Development Lifecycle, to ensure the production of high quality, reliable data assets. Participates in data cleansing and profiling to ensure accuracy and quality of information. Applies the organizational standards and laws governing use of sensitive data relating to Protected Health Information (PHI) and Personally Identifiable Information (PII). Participates in organizational Data Governance for data asset management.
• Demonstrates deep understanding of one or more data domains, the processes that generate the associated data, and the potential biases within those data sets. Learns Continuous Integration and Continuous Development (CI/CD) principles and best practices.
• Actively pursues opportunities to grow their business acumen and skills from more experienced team members. Provides coaching to less experienced team members.

Qualifications

• Required Bachelor's Degree or equivalent
• 2 years of relevant experience 2 to 5 years in related field Required
• 3 to 5 years relevant experience in related field preferred

Skills and Tools:

• Advanced level SQL/PLSQL skills are required
• Experience using Alteryx Designer or Informatica or ELT tool like DBT is required
• Experience with cloud platforms such as AWS and Snowflake
• Oracle or any other RDBMS such as MS SQL Server
• Experience with Toad
• Health care data experience is required
• Experience using Tableau or other BI tools like Business Objects Webi or QlikView or PowerBI
• Experience with scripting languages such as R and Python (Preferred)
• Familiarity with project management workflow tracking software such as JIRA/Trello.
• Familiarity with Collibra

Primary Location

Department Name

Employment Type

Shift

Weekly Scheduled Hours

Hours of Work

Days Worked

Weekend Frequency

Spectrum Health requires all team members to receive the COVID-19 vaccinations subject to certain exclusions based on the team member’s job category. Spectrum Health is committed to granting reasonable accommodations in accordance with applicable laws.

Accommodation Notice: If you are a qualified individual with a disability, you may request a reasonable accommodation in Spectrum Health's application process. Contact us at 616-486-SHHR (7447).

Spectrum Health grants equal employment opportunity to all qualified persons without regard to race, color, national origin, sex, disability, age, religion, genetic information, marital status, height, weight, sexual orientation, veteran status, or any other legally protected

category. See more here.