IT Cloud Business Intelligence Engineer

Advocate Aurora Health; United States; Remote; Full time

Job summary

A leading health system is hiring a Cloud Intelligence Engineer to enhance its enterprise cloud data warehouse. This full-time remote role involves designing and implementing efficient data models, along with working closely with stakeholders to support reporting and analytics needs. Candidates should have a bachelor's degree in computer science, experience in cloud data warehouses, and communication skills to present findings effectively.

Benefits

Paid Time Off programs

Health and welfare benefits

Flexible Spending Accounts

Educational Assistance Program

Defined contribution retirement plans with employer match

Qualifications

• Typically requires 3 years of experience in IT disciplines.
• Strong background in cloud data warehouses.
• Proficient in data visualization tools.

Responsibilities

• Design and implement data models and schemas.
• Develop and implement ELT/ETL processes.
• Troubleshoot data-related issues.

Skills

Communication skills

Data visualization

Data modeling

SQL

Problem solving

Education

Bachelor’s degree in computer science or related field

Tools

Snowflake

Microsoft Fabric

dbt Cloud

FiveTran/HVR

Azure DevOps

Tableau

Power BI

Job description

Department:

12295 Advocate Aurora Health Corporate - Enterprise Cloud Data Engineering

Status:

Full time

Benefits Eligible:

Yes

Hou rs 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 CommitmenttoYou:

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, andShort- 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.