"Alerted.org

Description

Senior Data Engineer, Snowflake

As a Senior Data Engineer you will be actively engaged in changing the way PHP utilizes and interacts with data. This role represents a unique opportunity to shape the way the business units and the company as a whole creates, interacts with, augments, and governs their data ecosystem. This role provides senior level data engineering expertise in a cloud-based environment as a part of an agile software development and delivery team. This position focuses on using data engineering tools and theory as part of a holistic end-to-end approach to delivering highly available solutions to users. A senior data engineer leads exploration and adoption of new technologies, paradigms and architectures that help to continuously improve the capabilities of the team. This includes working closely with end users and other developers to design, build and deliver complete products and supporting infrastructure.

Providence caregivers are not simply valued – they’re invaluable. Join our team at Providence Health Plan Partners and thrive in our culture of patient-focused, whole-person care built on understanding, commitment, and mutual respect. Your voice matters here, because we know that to inspire and retain the best people, we must empower them.

Providence welcomes virtual work for applicants who reside in one of the following States:

+ Washington

+ Oregon

+ California

Required Qualifications:

+ Demonstrated experience in data engineering as noted above in correspondence with education level.

+ Extensive experience in data engineering using modern python based frameworks such as pandas, numpy, great expectations, pyarrow, s3fs, boto3, pytest.

+ Experience implementing, and maintaining enterprise scale data lakes.

+ Experience with Automation including Unit and Integration Testing.

+ Experience with data warehouse technologies such as Redshift, MySQL, SQL Server, Athena, dbt, Aurora, and Snowflake.

+ Experience with administering and utilizing orchestration platforms such as Apache Airflow, and AWS Step Functions.

+ Experience with applying data engineering theory and best practices to solve business problems.

+ Experience with data security paradigms and their role in data engineering architectures.

+ Experience with Apache data formats for big data such as Avro, Parquet, Orc.

Preferred Qualifications:

+ Associate's Degree & 6 or more years of demonstrated experience in data engineering **-OR-**

+ Bachelor's Degree & 4 or more years of demonstrated experience in data engineering **-OR-** a combination of equivalent education and work experience

+ Experienced in SQL query writing, ideally across multiple databases and servers

+ 4 or more years of experience working in data engineering

+ 2 or more years’ experience working with MS Sql Server and SSIS

+ 2 or more years’ experience developing data pipelines and data products in Snowflake

+ 2 or more years’ experience utilizing python in data pipelines and data product development

+ 2 or more years’ data modeling experience

+ Experience with Health Insurance Payer preferred

+ Experience with advanced data integration tools like CDATA, FiveTran, Matmillion

+ Prior experience with HEDIS

Salary Range by Location: 

+ California: Humboldt: Min: $54.40, Max: $85.88

+ California: All Northern California - Except Humboldt: Min: $61.04, Max: $96.35

+ California: Southern California: Min: $54.40, Max: $85.88

+ Oregon: Non-Portland Service Area: Min: $48.65, Max: $76.80

+ Oregon: Portland Service Area: Min: $52.19, Max: $82.39

+ Washington: Western: Min: $54.40, Max: $85.88

+ Washington: Southwest - Olympia, Centralia: Min: $52.19, Max: $82.39

+ Washington: Clark County: Min: $52.19, Max: $82.39

+ Washington: Eastern: Min: $46.44, Max: $73.31

+ Washington: Southeastern: Min: $48.65, Max: $76.80

Why Join Providence?

Our best-in-class benefits are uniquely designed to support you and your family in staying well, growing professionally, and achieving financial security. We take care of you, so you can focus on delivering our Mission of caring for everyone, especially the most vulnerable in our communities.

About Providence

At Providence, our strength lies in Our Promise of “Know me, care for me, ease my way.” Working at our family of organizations means that regardless of your role, we’ll walk alongside you in your career, supporting you so you can support others. We provide best-in-class benefits and we foster an inclusive workplace where diversity is valued, and everyone is essential, heard and respected. Together, our 120,000 caregivers (all employees) serve in over 50 hospitals, over 1,000 clinics and a full range of health and social services across Alaska, California, Montana, New Mexico, Oregon, Texas and Washington. As a comprehensive health care organization, we are serving more people, advancing best practices and continuing our more than 100-year tradition of serving the poor and vulnerable.

The amounts listed are the base pay range; additional compensation may be available for this role, such as shift differentials, standby/on-call, overtime, premiums, extra shift incentives, or bonus opportunities.

Providence offers a comprehensive benefits package including a retirement 401(k) Savings Plan with employer matching, health care benefits (medical, dental, vision), life insurance, disability insurance, time off benefits (paid parental leave, vacations, holidays, health issues), voluntary benefits, well-being resources and much more. Learn more at providence.jobs/benefits.

Applicants in the Unincorporated County of Los Angeles: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Unincorporated Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act."

About the Team

Providence Shared Services is a service line within Providence that provides a variety of functional and system support services for our family of organizations across Alaska, California, Montana, New Mexico, Oregon, Texas and Washington. We are focused on supporting our Mission by delivering a robust foundation of services and sharing of specialized expertise.

Providence is proud to be an Equal Opportunity Employer. We are committed to the principle that every workforce member has the right to work in surroundings that are free from all forms of unlawful discrimination and harassment on the basis of race, color, gender, disability, veteran, military status, religion, age, creed, national origin, sexual identity or expression, sexual orientation, marital status, genetic information, or any other basis prohibited by local, state, or federal law. We believe diversity makes us stronger, so we are dedicated to shaping an inclusive workforce, learning from each other, and creating equal opportunities for advancement.

**Requsition ID:** 395920

**Company:** Providence Jobs

**Job Category:** Development/Engineering

**Job Function:** Information Technology

**Job Schedule:** Full time

**Job Shift:** Day

**Career Track:** Business Professional

**Department:** 5018 IT DEVELOPMENT TEAM OR REGION

**Address:** OR Beaverton 3601 SW Murray Blvd

**Work Location:** Murray Business Ctr Beaverton-Beaverton

**Workplace Type:** On-site

**Pay Range:** $See Job Posting - $See Job Posting

The amounts listed are the base pay range; additional compensation may be available for this role, such as shift differentials, standby/on-call, overtime, premiums, extra shift incentives, or bonus opportunities.