What are the responsibilities and job description for the IT Cloud Business Intelligence Engineer position at Advocate Health?
Major Responsibilities
#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
- 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.
- Any cloud data warehouse related certifications are preferred.
- 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.
- 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.
#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.
