Department:
12295 Advocate Aurora Health Corporate - Enterprise Cloud Data Engineering
Status:
Full time
Benefits Eligible:
Yes
Hours Per Week:
40
Schedule Details/Additional Information:
Regular
Major Responsibilities
Responsible for building repeatable framework to ingest data into Azure data lake.
Develop data transformation and movement pipelines using approved AH technology (using Python or GUI based ETL /ELT tools)
Design parameter driven orchestration to allow for change data capture and monitoring using ETL/ELT tools
Assemble large, complex data sets that meet functional / non-functional business requirements
Drive technical design, application build, product configuration, unit testing, and production deployment
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Python and complementing technologies
Build processes supporting data transformation, data structures, metadata, dependency, and workload management
Ensure delivered solutions are realized in time frame committed; work in conjunction with project sponsors to size and manage scope and risk
Minimum Job Requirements
Education
Bachelor's Degree in Computer Science or related field
Certification / License
None
Work Experience
Typically requires 2 years of experience in at least two IT disciplines, including database development, pipeline development, data engineering. Must have experience in data transformation and data pipeline development using GUI based tools or programming languages like Python.
Knowledge / Skills / Abilities
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
Experience building and optimizing data pipelines, architectures, and data sets
Understanding of Azure SQL Database, Azure Functions, Logic Apps, Azure DevOps
#Remote
#LIRemote
#CloudDataEngineer
Preferred remote locations in IL, WI, NC, GA
Fully Remote Role from these states: AL, AK, AR, AZ, DE, FL, GA, IA, ID, IL, IN, LA, KS, KY, ME, MI, MO, MS, MT, NC, ND, NE, NH, NM, NV, OH, OK, PA, SC, SD, TN, TX, UT, VA, WI, WV, WY.
Due to complex requirements, remote work is NOT permitted for short or long periods in: CA, CO, CT, HI, MA, MD, MN, NJ, NY, OR, RI, VT, WA and working Internationally (this includes working while on vacation).
No relocation, No Sponsorship for this position.
Physical Requirements and Working Conditions
This position does not require travel.
Operates all equipment necessary to perform the job.
Exposed to a normal office environment.
Preferred Job Requirements
Education
Certification / License
Experience
Knowledge / Skills / Abilities
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.
Pay Range
$40.30 - $60.45
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
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.
Top Skills
Similar Jobs
What you need to know about the Colorado Tech Scene
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
