Data Engineer - GCP
About the position Responsibilities • Develop, maintain, and optimize streaming, near real-time, and batch GCP data pipelines for enterprise-wise analysis of structured, semi-structured, and unstructured data. • Collaborate closely with the Senior Engineers, Lead Architect, and Product Owner to define, design, and build new features and improve existing data products. • 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. • Work with Project Managers to estimate, establish, and meet target dates. • Work independently, and complete tasks on-schedule by exercising strong judgment and critical thinking skills. • Create and maintain technical documentation, including source-to-target mappings, job scheduling and dependency details, and business-driven transformation rules. • Participate in the deployment, change, configuration, management, administration, and maintenance of deployment processes and systems. • Participate in technical group discussions and adopt innovative technologies to improve development and operations. Requirements • Bachelors degree preferred. • 1+ year(s) of experience in Data Warehouse ETL/ELT Data Engineering required. • 1+ year(s) of experience in Google Cloud Platform (GCP) Data Engineering required. • 1+ year(s) of experience in Healthcare IT preferred. • Experience with Google Cloud Storage (GCS), BigQuery, and Cloud Composer (Airflow), Cloud Functions, Dataflow, and Dataproc GCP services. • Experience writing optimized BigQuery SQL transformation queries and scripts. • Experience with raw data formats such as JSON, Avro, and Parquet. • Experience with Oracle, SQL Server, and other database platforms. • Experience writing and maintaining Unix/Linux and Python scripts. • Experience with GitHub source control and CI/CD workflows. • Knowledge of issue tracking tools such as Jira and ServiceNow. • Ability to troubleshoot, maintain, reverse engineer, and optimize existing data pipelines. • Ability to analyze and interpret complex data and offer solutions to complex 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. Benefits • Comprehensive medical coverage that covers many common services at no cost or for a low copay. • 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. Apply tot his job