Onsite expectation 50 percent of the time in West Michigan

Not able to hire external candidate if currently in F-1 OPT status

Not able to sponsor external candidate in the future for H-1B, TN, or other visa type

Job Summary

Oversee, advise, and direct data flow for Priority Health within Snowflake on AWS. Include direction on landing raw data sources, and translating into data warehouse while establishing and enforcing standards and governance.

Essential Functions

• Translates business analytics problems into data frameworks and blueprints that data engineers can follow and execute across multiple domains.

• Analyzes structured and unstructured data to drive prototype ideas for new tools and products. Designs, prototypes, and implements on-prem and cloud-based data solutions.

• Develops standards and guidelines around code development, test strategies and naming conventions across data assets. Assists in selecting data management tools and developing the standards, usage guidelines, and procedures for using those tools.

• Develops and presents data strategies to IT and Business Executives.

• Optimizes legacy data models and re-engineer legacy frameworks. Highly proficient in tuning databases and ETL code for optimal performance.

• Helps to create and sustain a Data Engineering Community of Practice and mentors other team members on documentation and solution development aligned with overall data strategy. Guides data engineers as they build and test new systems per specifications.

• Understands and abides by the project management and solution development methodologies. Maintains industry leading technical skills and expertise through education and training.

• Highly organized with good time management skills, customer-service orientation, and strong interpersonal and presentations skills. Analytical thinker with creative problem-solving skills and attention to detail.

How Corewell Health cares for you

• Comprehensive benefits package to meet your financial, health, and work/life balance goals. Learn more here (https://careers.corewellhealth.org/us/en/benefits-new) .

• On-demand pay program powered by Payactiv

• Discounts directory with deals on the things that matter to you, like restaurants, phone plans, spas, and more!

• Optional identity theft protection, home and auto insurance, pet insurance

• Traditional and Roth retirement options with service contribution and match savings

Qualifications

Required

• Bachelor's Degree or equivalent

• 4 years of related experience

Preferred

• Master's Degree or equivalent

• 7 years of related experience

• AWS experience

• Snowflake experience

• SQL coding experience

• dbt experience

• Epic for payers experience

• Health plan experience

About Corewell Health

As a team member at Corewell Health, you will play an essential role in delivering personalized health care to our patients, members and our communities. We are committed to cultivating and investing in YOU. Our top-notch teams are comprised of collaborators, leaders and innovators that continue to build on one shared mission statement - to improve health, instill humanity and inspire hope. Join a nationally recognized health system with an ambitious vision of continued advancement and excellence.

Primary Location

SITE - Priority Health - 1241 E Beltline - Grand Rapids

Department Name

PH - Medical Cost Analysis

Employment Type

Full time

Shift

Day (United States of America)

Weekly Scheduled Hours

40

Hours of Work

8 a.m. to 5 p.m.

Days Worked

Monday to Friday

Weekend Frequency

N/A

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

Corewell Health is committed to providing a safe environment for our team members, patients, visitors, and community. We require a drug-free workplace and require team members to comply with the MMR, Varicella, Tdap, and Influenza vaccine requirement if in an on-site or hybrid workplace category. We are committed to supporting prospective team members who require reasonable accommodations to participate in the job application process, to perform the essential functions of a job, or to enjoy equal benefits and privileges of employment due to a disability, pregnancy, or sincerely held religious belief.

Corewell 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, gender, pregnancy, sexual orientation, gender identity or expression, veteran status, or any other legally protected category.

An interconnected, collaborative culture where all are encouraged to bring their whole selves to work, is vital to the health of our organization. As a health system, we advocate for equity as we care for our patients, our communities, and each other. From workshops that develop cultural intelligence, to our inclusion resource groups for people to find community and empowerment at work, we are dedicated to ongoing resources that advance our values of diversity, equity, and inclusion in all that we do. We invite those that share in our commitment to join our team.

You may request assistance in completing the application process by calling 616.486.7447.