ETL Data Engineer - Healthcare, SQL, Python, DBT, Snowflake Job at PEOPLE FORCE CONSULTING INC, Portland, OR

MnE1djVETWF4RnliMTZ5NGxWRXpkVHJjYkE9PQ==
  • PEOPLE FORCE CONSULTING INC
  • Portland, OR

Job Description

Location Portland, OR(Hybrid) / REMOTE

Experience - 10+ Years

We are seeking a results-driven and analytical Data Engineer. This role will focus on measuring, analyzing, and improving clinical, operational, and financial outcomes across the enterprise. The ideal candidate will bring deep expertise in healthcare analytics, outcomes measurement, and performance improvement to help drive data-informed strategies that enhance member health and organizational effectiveness.

Key Responsibilities:

  • Data profiling to identify primary keys and issues with the data.
  • Write ETL to bring data onto the Data Platform, de-duplicate data, create or update dimensional data structures, and produce use case-specific output.
  • Unit testing, functional testing, and performance testing and tuning.
  • Interacting with the Product team to understand and refine requirements.
  • Interacting with QA to address reported findings.
  • Working individually and as a team to achieve our goals.
  • Taking initiative to take on additional work if the present work stream slows down.
  • Mentor junior team members and help to bring new team members onto the team
  • Other similar or related activities.

MUST HAVE Healthcare, SQL, Python, DBT, Snowflake

  • Proficient in data engineering and data pipeline development, testing, documentation, deployment, and support.
  • SQL: Highly skilled to expert level.
  • Must be familiar with common table elements (CTEs), complex joins, and analytic & windowing functions.
  • Snowflake:
  • Prefer candidates with real-world experience using Snowflake.
  • Data Profiling:
  • Must be able to identify unique and primary keys and determine cardinality, data type, precision, and scale, and skew.
  • Effective communication skills to communicate internally within our team and externally across other teams, notably Product and QA
  • Understands the scope and context of the work and takes initiative to achieve the goals, rather than waiting to take specific direction.

Preferred skills

  • Healthcare Industry Experience: Some experience is desired, preferably Payer experience.
  • Data Modeling Experience desired.

Specific technologies/proficiency

  • SQL: Highly skilled to expert level.
  • Python: Some experience is required with a preference for intermediate or higher skill.
  • DBT: Prefer candidates with real-world DBT experience.
  • Snowflake: Prefer candidates with real-world experience using Snowflake.

Job Tags

Remote work

Similar Jobs

Chicago Public Schools

School Assistant Job at Chicago Public Schools

 ...: School Assistant Job Number: 2400006C Posting Date : Jan 29, 2024, 3:13:21 PM Primary Location : North/Northwest Side-1250 East Erie Street (William B Ogden Branch) - School Assistant - COVID Support Chicago Public Schools (CPS) is the third-largest school... 

FetchMe

Catering Delivery Driver Job at FetchMe

 ...most dynamic business hubs, and the demand for reliable delivery here runs all week long. FetchMe-Cosmic Delivery is expanding its driver network in the Tysons area and looking for polished, dependable part-time drivers who can match the pace of this market. Deliveries... 

Korzen Health

Psychiatrist - 100% Outpatient | Ally Psychiatry | Birmingham, AL Job at Korzen Health

 ...Korzen Health isseeking a dedicated Board-Certified or Board-Eligible Psychiatrist to join our growing behavioral health team in Birmingham, AL. This opportunity offers a dynamic practice environment where you will provide high-quality psychiatric care across multiple... 

CDK Global

Call Center Support Rep Job at CDK Global

 ...financial and operational performance. Position Summary: Call Center Remote Work From Home: Alabama, Arizona, Florida, Georgia, Indiana, Kansas,...  ...high-quality calls 100% of the time and consistently represent an automotive dealership positively and professionally.... 

Capital Insurance Group

Regional Underwriter - Commercial Job at Capital Insurance Group

Why CIG?At Capital Insurance Group we offer our employees more than just a job. We foster...  ...insurer. CIG is certified as a Great Place to Work and provides a collaborative, inclusive,...  ...~Employee Referral Bonus Program~Home and Auto Insurance Discount Program.~Paid...