Department:
Status:
Benefits Eligible:
Hours Per Week:
Schedule Details/Additional Information:
Remote
Normal Business Hours
Pay Range:
$40.30 - $60.45Major Responsibilities:
Drive scope definition, requirements analysis, data and technical design, pipeline build, product configuration, unit testing, and production deployment.
Design scalable ingestion processes to bring on-prem, API drive, 3rd party, end user generated data sources to integrate in common cloud infrastructure.
Design reusable assets, components, standards, frameworks, and processes to accelerate and facilitate data integration projects.
Develop data integration and transformation jobs using Python, SQL and ETL /ELT tools.
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources.
Build processes supporting data transformation, data structures, metadata, dependency and workload management.
Develop and implement scripts for data process maintenance, monitoring, and performance tuning.
Test and document data processes through data validation and verification procedures.
Ensure delivered solutions meet/perform to technical and functional/non-functional requirements.
Provide technical guidance and mentorship to junior engineers, ensuring best practices in data engineering.
Licensure, Registration, and/or Certification Required:
None required.
Education Required:
Bachelor's Degree in Computer Science or related field.
Experience Required:
Typically requires 5 years of experience in at least two IT disciplines, including database management, cloud engineering, data engineering and middleware technologies. Includes 2 years of work experience with cloud platforms, including experience with data integration, performance optimization, and platform administration.
Knowledge, Skills & Abilities Required:
Experience defining, designing, and developing solutions with data integration platforms/tools.
Proven experience building and optimizing data pipelines, and data sets.
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Must have experience in data transformation and data pipeline development using GUI based tools or programming languages like SQL and Python.
Proficiency in Python and SQL for scripting and building data transformation processes is preferred.
Must have experience with DevOps tool chains and processes.
Physical Requirements and Working Conditions:
DISCLAIMER
All responsibilities and requirements are subject to possible modification to reasonably accommodate individuals with disabilities.
This job description in no way states or implies that these are the only responsibilities to be performed by an employee occupying this job or position. Employees must follow any other job-related instructions and perform any other job-related duties requested by their leaders.
Our Commitment to You:
Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs, competitive compensation, generous retirement offerings, programs that invest in your career development and so much more – so you can live fully at and away from work, including:
Compensation
Base compensation listed within the listed pay range based on factors such as qualifications, skills, relevant experience, and/or training
Premium pay such as shift, on call, and more based on a teammate's job
Incentive pay for select positions
Opportunity for annual increases based on performance
Benefits and more
Paid Time Off programs
Health and welfare benefits such as medical, dental, vision, life, and Short- and Long-Term Disability
Flexible Spending Accounts for eligible health care and dependent care expenses
Family benefits such as adoption assistance and paid parental leave
Defined contribution retirement plans with employer match and other financial wellness programs
Educational Assistance Program
Note: Eligibility for programs listed above may depend on your FTE or status (e.g., full-time, part-time, per diem, temporary, etc.); please ask a Recruiter for more information during an interview.
About Advocate Health
Advocate Health is the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas, Georgia and Alabama; and Aurora Health Care in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation’s largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits.
Skills Required
- Bachelor's Degree in Computer Science or related field
- 5 years of experience in at least two IT disciplines (database management, cloud engineering, data engineering, middleware)
- Minimum 2 years working with cloud platforms including data integration, performance optimization, and platform administration
- Experience defining, designing, and developing solutions with data integration platforms/tools
- Experience building and optimizing data pipelines and data sets
- Advanced SQL knowledge and experience with relational databases and query authoring
- Experience in data transformation and pipeline development using GUI tools or programming languages like SQL and Python
- Proficiency in Python and SQL for scripting and building data transformation processes
- Experience with DevOps tool chains and processes
Similar Jobs
What We Do
Advocate Aurora Health is the 11th largest not-for-profit, integrated health system in the United States. As a leading employer in the Midwest, Advocate Aurora Health employs more than 75,000 individuals including more than 22,000 nurses. Advocate Aurora is engaged in hundreds of clinical trials and research studies, and is nationally recognized for its expertise in cardiology, neurosciences, oncology and pediatrics. The organization contributed nearly $2.2 billion in charitable care and services to its communities in 2019.
