Department:

12295 Advocate Aurora Health Corporate - Enterprise Cloud Data Engineering

Status:

Full time

Benefits Eligible:

Yes

Hours Per Week:

40

Schedule Details/Additional Information:

Remote - work in CST time (9-5)

Major Responsibilities:

• Design and implement efficient data models and schemas within enterprise cloud data warehouse to support reporting, analytics, and business intelligence needs.
• Develop and implement ELT/ETL processes using Cloud data warehouse-based features and functionalities.
• Work with a wide range of stakeholders to support use cases and gather requirements for analysis, reporting, and automation.
• Troubleshoot and resolve data-related issues, ensuring the reliability of the enterprise cloud data warehouse.

Licensure, Registration, and/or Certification Required:

• Any cloud data warehouse related certifications are preferred.

Education Required:

• Bachelor’s degree in computer science or related field.

Experience Required:

• Typically requires 3 years of experience in at least two IT disciplines, including technical architecture, application development, database management or operations.
• 2 years of work experience with Cloud data warehouses, including experience with data modeling and performance optimization.
• 2 years of work experience with data visualization tools.

Knowledge, Skills & Abilities Required:

• Capable of communicating and presenting complex information to technical and non-technical stakeholders, both verbally and in written form.
• Experience with clinical healthcare data is a plus.
• Knowledge of DevOps tool chains and processes.
• Experience in SaaS tools like Snowflake, Microsoft Fabric, dbt Cloud, FiveTran/HVR, Azure DevOps is preferred.
• Proficiency in SQL for scripting and building data transformation processes is preferred.
• Experience developing, deploying, and maintaining enterprise level reports using BI tools such as Streamlit, Tableau, Power BI, Looker, or other relevant technologies is preferred.

#Remote

#LI-Remote

#CloudIntelligenceEngineer

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 now or in the future.

Physical Requirements and Working Conditions:

• Operates all equipment necessary to perform the job.
• Exposed to a normal office environment.

This job description indicates the general nature and level of work expected of the incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent may be required to perform other related duties.

Pay Range

$37.50 - $56.25

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, dent