Data Engineer Etl Gcp

Description

Introduction

Are you looking for a work environment where diversity and inclusion thrive? Submit your application for our Data Engineer opening with HCA Healthcare today and find out what it truly means to be a part of the HCA Healthcare team.

Benefits

HCA Healthcare, offers a total rewards package that supports the health, life, career and retirement of our colleagues. The available plans and programs include:

• Comprehensive medical coverage that covers many common services at no cost or for a low copay. Plans include prescription drug and behavioral health coverage as well as free telemedicine services and free AirMed medical transportation.
• Additional options for dental and vision benefits, life and disability coverage, flexible spending accounts, supplemental health protection plans (accident, critical illness, hospital indemnity), auto and home insurance, identity theft protection, legal counseling, long-term care coverage, moving assistance, pet insurance and more.
• Free counseling services and resources for emotional, physical and financial wellbeing
  
• 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service)
  
• Employee Stock Purchase Plan with 10% off HCA Healthcare stock
  
• Family support through fertility and family building benefits with Progyny and adoption assistance.
  
• Referral services for child, elder and pet care, home and auto repair, event planning and more
  
• Consumer discounts through Abenity and Consumer Discounts
  
• Retirement readiness, rollover assistance services and preferred banking partnerships
  
• Education assistance (tuition, student loan, certification support, dependent scholarships)
  
• Colleague recognition program
  
• Time Away From Work Program (paid time off, paid family leave, long- and short-term disability coverage and leaves of absence)
  
• Employee Health Assistance Fund that offers free employee-only coverage to full-time and part-time colleagues based on income.

Learn more about Employee Benefits

Note: Eligibility for benefits may vary by location.

We are seeking a Data Engineer for our team to ensure that we continue to provide all patients with high quality, efficient care. Did you get into our industry for these reasons? We are an amazing team that works hard to support each other and are seeking a phenomenal addition like you who feels patient care is as meaningful as we do. We want you to apply!

Job Summary and Qualifications

This position is part of an ETL development team responsible for analysis, design, development, and support of Data Warehouse ETL pipelines. The Data Engineer will spend time writing, testing, and reviewing ETL pipelines alongside other developers. Other tasks include researching, architecting, requirements gathering, designing, documenting, and modifying software throughout the complete production life cycle.

This position works with business analysts and project managers on business requirement reviews, task breakdown and estimation, and technical documentation.

Major Responsibilities:

Our Purpose

Applied to this position, your skills will help transform healthcare through technology and solutions that dramatically improve patient care and business operations.

At HCA ITG, your deliverables will influence patient care. Every process, technology and decision matters.

• Develop, maintain, and optimize streaming, near real-time, and batch ETL pipelines using a combination of SQL, Teradata BTEQ and TPT scripts, Unix/Linux shell scripts, and Python scripts.

• Contribute to and participate in peer code reviews.

• Participate in on-call support rotation.

• Adhere to established development guidelines.

• Translate business requirements into technical design specifications.

• Estimate, establish, and meet target dates.

• Create and maintain technical documentation, including source-to-target mappings, job scheduling and dependency details, and business-driven transformation rules.

• Propose and implement process improvements with reporting applications and the overall development process.

• Mentor and assist junior team members during onboarding and day-to-day tasks.

• Practices and adheres to the “Code of Conduct” philosophy and “Mission and Value Statement.”

Education & Experience:

•  Bachelor's degree preferred

•  5+ years of experience in Information Technology required

•  3+ years of experience in Data Warehouse ETL/ELT Development required

•  1+ year(s) of experience in Google Cloud Platform (GCP) Data Engineering required

•  1+ year(s) of experience in Healthcare IT preferred

Or equivalent combination of education and/or experience

Knowledge, Skills, Abilities, Behaviors:

• Data Warehouse experience on Teradata and GCP BigQuery

• Experience with ETL tools such as ConnectETL/DMExpress, DataStage, and/or StreamSets.

• Experience with orchestration tools such as Apache Airflow.

• Experience with Oracle, SQL Server, and other database platforms.

• Scripting experience with Unix/Linux shell and Python.

• Experience with Git and GitHub source control.

• Knowledge of issue tracking tools such as Jira and ServiceNow.

• Ability to troubleshoot, maintain, reverse engineer and optimize existing ETL pipelines.

• Ability to analyze and interpret complex data, and offer solutions to complex clinical problems.

• Ability to work independently on assigned tasks.

• Strong written and verbal communication skills including the ability to explain complex technical issues in a way that non-technical people may understand.

• Excellent problem-solving and critical thinking skills.

• Knowledge of IT governance and operations. 

HCA Healthcare has been recognized as one of the World’s Most Ethical Companies® by the Ethisphere Institute more than ten times.  In recent years, HCA Healthcare spent an estimated $3.7 billion in cost for the delivery of charitable care, uninsured discounts, and other uncompensated expenses.

"Across HCA Healthcare’s more than 2,000 sites of care, our nurses and colleagues have a positive impact on patients, communities and healthcare.
Together, we uplift and elevate our purpose to give people a healthier tomorrow."- Jane Englebright, PhD, RN CENP, FAAN
Senior Vice President and Chief Nursing Executive

If you find this opportunity compelling, we encourage you to apply for our Data Engineer opening. We promptly review all applications. Highly qualified candidates will be directly contacted by a member of our team. We are interviewing apply today!

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.