Advocate Aurora Health · 5 hours ago

IT Cloud Business Intelligence Engineer

Oak Brook, IL

Full-time

Remote

Mid Level

3+ years exp

Maximize your interview chances

Health Care

No H1B

Insider Connection @Advocate Aurora Health

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Cloud data warehouseData modelingSQLData visualization toolsSaaS toolsBI toolsETL processesDevOps tool chainsClinical healthcare data

Required

Bachelor’s degree in computer science or related field.

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.

Capable of communicating and presenting complex information to technical and non-technical stakeholders, both verbally and in written form.

Preferred

Any cloud data warehouse related certifications are preferred.

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.