IT Cloud Business Intelligence Engineer
Job ID:
R149318
Shift:
1st
Full/Part Time:
Full_time
Pay Range:
$37.50 – $56.25
Location:
Remote
Benefits Eligible:
Yes
Hours Per Week:
40
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 within the position’s 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
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.
Information Technology at Advocate Aurora
Aurora Health Care is the largest health system in Wisconsin and a national leader in clinical innovation, health outcomes, consumer experience and value-based care. The state’s largest private employer, the system serves patients across 17 hospitals, more than 70 pharmacies and more than 150 sites of care. Aurora Health Care, in addition to Advocate Health Care in Illinois and Atrium Health in the Carolinas, Georgia and Alabama, is now 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.
