Data Engineer

HCA Healthcare; Brentwood (TN); Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical & vision

401(k) match

Tuition assistance

Fertility support

Job summary

HCA Healthcare, Inc. is seeking a Database Engineer/Data Engineer to design, develop, and maintain enterprise data warehouse solutions within the PSC development team. The role emphasizes ETL processes, reporting, and collaboration with analysts to meet business needs.

The position is a Work from Home opportunity that requires residing within 60 miles of an HCA hospital and may include off-hours support for outages; remote work with enterprise standards and benefits is supported.

Qualifications

• Bachelor's Degree in Mathematics, Statistics, CS, Engineering or related field; 3+ years IT experience.
• 3+ years BI apps experience (MicroStrategy, Power BI, Essbase, Arcplan, BO).
• 2+ years BI or data management experience.
• 2+ years optimizing large databases (Teradata, Oracle, SQL Server).
• 2+ years data warehouse design, development and programming experience.
• 2+ years ETL design using Microsoft BI stack (SQL and SSIS) in data warehouse settings.
• BI tools certifications are a plus.

Responsibilities

• Develop, support, and maintain database and web applications.
• Design and develop data warehouse ETL processes and stored procedures.
• Design and develop reports from data warehouse.
• Document technical requirements with business users.
• Assist in developing prototypes/models and determine data sources.
• Follow standards when developing database components.
• Resolve data warehouse performance issues.
• Develop controls to mitigate operational and financial risks.
• Participate in database/application design sessions.
• Integrate new/existing software with the data warehouse.
• Participate in large-scale projects across multiple areas.
• Perform application monitoring and maintenance as needed.
• Provide off-hour support for outages.

Skills

ETL development

Data warehousing

Python data processing

GCP ETL

SQL/SSIS

BigQuery

Education

Bachelor's degree in relevant field

Tools

Google Cloud Platform

SQL

SSIS

Power BI

Teradata

Oracle

SQL Server

Job description

This Work from Home position requires that you live and will perform the duties of the position; within 60 miles of an HCA Healthcare Hospital (Our hospitals are located in the following states: FL, GA, ID, KS, KY, MO, NV, NH, NC, SC, TN, TX, UT, VA).

Do you want to join an organization that invests in you as a Data Engineer? At Parallon, you come first. HCA Healthcare has committed up to $300 million in programs to support our incredible team members over the course of three years.

Job Summary And Qualifications

The Database Engineer is part of the PSC development team, and designs, architects, and develops database solutions. The Database Engineer also provides infrastructure support and leads development efforts for strategic applications. This position works with technical users, business analysts, and business owners to understand requirements and identify solutions. This position has experience with the design, development, maintenance, and administration of enterprise data warehouses.

What you will do in this role:

• Working knowledge in developing, supporting, and maintaining database and web applications
• Design and develop data warehouse ETL processes and Stored Procedures
• Design and develop reports from data warehouse
• Document technical requirements by working with business users
• Assists in developing prototypes/models and determining data sources
• Follows technical and development standards when developing database components
• Resolves data warehouse performance issues when identified
• Develops appropriate application controls to mitigate operations and financial risks
• Actively participates in database/application design sessions
• Integrate new/existing software with existing data warehouse
• Participate in large-scale development projects involving multiple areas outside of core team
• Performs application monitoring and maintenance as needed
• Provide off hour support for high level outages

What qualifications you will need:

• Bachelor's Degree in Mathematics, Statistics, Computer Science, Engineering or related field is preferred 3+ years overall IT experience
• 3+ years of Experience in developing BI applications using MicroStrategy, Power BI, Essbase, Arcplan, Business Objects preferred
• 2+ years of business intelligence or data management experience
• 2+ years of Experience in optimizing large databases like Teradata, Oracle, SQL Server preferred
• 2+ years of database design, data warehousing and programming experience
• 2+ years of experience with ETL design and development using Microsoft BI stack, including SQL and SSIS in data warehouse setting
• Certificate/License(s) in various BI tools is a plus

GCP ETL Developer Experience:

• Strong hands-on experience developing ETL/ELT data pipelines on Google Cloud Platform (GCP)
• Proficiency in Python for data processing, transformation, automation, and pipeline development
• Hands-on experience with Google Cloud Dataflow and Apache Beam
• Experience designing and developing batch and streaming data pipelines
• Strong experience with Google BigQuery, including SQL development, data modeling, optimization, and large-scale data processing
• Experience with GCP data services such as Cloud Storage (GCS), Pub/Sub, Cloud Composer/Airflow, and Dataproc

Benefits

• Comprehensive benefits for medical, prescription drug, dental, vision, behavioral health and telemedicine services
• Wellbeing support, including free counseling and referral services
• Time away from work programs for paid time off, paid family leave, long- and short-term disability coverage and leaves of absence
• Savings and retirement resources, including a 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service), Employee Stock Purchase Plan, flexible spending accounts, preferred banking partnerships, retirement readiness tools, rollover support and financial wellbeing counseling
• Education support through tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing
• Additional benefits for fertility and family building, adoption assistance, life insurance, supplemental health protection plans, auto and home insurance, legal counseling, identity theft protection and consumer discounts

Learn More About Employee Benefits

Note: Eligibility for benefits may vary by location.

Parallon provides full-service revenue cycle management, or total patient account resolution, for HCA Healthcare. Our services include scheduling, registration, insurance verification, hospital billing, revenue integrity, collections, payment compliance, credentialing, health information management, customer service, payroll and physician billing. We also provide full-service revenue cycle management as well as targeted solutions, such as Medicaid Eligibility, for external clients across the country. Parallon has over 17,000 colleagues, and serves close to 1,000 hospitals and 3,000 physician practices, all making an impact on patients, providers and their communities.

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.

"Good people beget good people."- Dr. Thomas Frist, Sr.

HCA Healthcare Co-Founder

We are a family 270,000 dedicated professionals! Our Talent Acquisition team is reviewing applications for our Data Engineer opening. Qualified candidates will be contacted for interviews.

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