IT Cloud Business Intelligence Engineer
Job ID:
R129905
Shift:
1st
Full/Part Time:
Full_time
Location:
Oak Brook Support Center – 2025 Windsor Dr
Oak Brook, IL 60523
Benefits Eligible:
Yes
Hours Per Week:
40
Schedule Details/Additional Information:
Fully Remote
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
#LIRemote
#CloudBIEngineer
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:
- 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.
Information Technology at Advocate Aurora
Advocate Health Care is the largest health system in Illinois and a national leader in clinical innovation, health outcomes, consumer experience and value-based care. One of the state’s largest private employers, the system serves patients across 11 hospital locations, including two children’s campuses, and more than 250 sites of care. Advocate Health Care, in addition to Aurora Health Care in Wisconsin and Atrium Health in the Carolinas, Georgia and Alabama, is now a part of Advocate Health, the third-largest nonprofit, integrated health system in the United States. Committed to providing equitable care for all, Advocate Health provides nearly $5 billion in annual community benefits.