• Design and implement complex data models, modeling metadata, building reports and dashboards and creating reporting tools for data science and ML products users. • Design and deploy data infrastructure needed to drive data-driven decision-making solutions • Be the company’s expert on data administration and master data management • Be a technical thought leader on the development of scalable data systems • Develop front end applications to expose analytical data sets enterprise wide • Write highly tuned, scalable SQL queries running over large-scale, heterogeneous data warehouses • Work with the Product and Enterprise Engineering system teams to structure source systems for reporting consumption across the enterprise • Help maintain the CDC pipeline to power customer reporting

Role Description The Data Engineer will design, build, and optimize modern data solutions using Microsoft Fabric. In this role, you will work closely with analytics, BI, and business teams to deliver scalable, secure, and high-performance data platforms that turn raw data into actionable insights. This position bridges business requirements and technical execution by translating data needs into scalable, secure, and high-quality analytics assets. The role combines hands-on development with cross-functional collaboration to ensure analytics solutions are reliable, governed, and aligned with business priorities. Essential Job Functions - Design, develop, and maintain end-to-end data pipelines using Microsoft Fabric (including Power BI, OneLake, semantic models, and data pipelines). - Build and maintain data models including relational, dimensional, star, and snowflake schemas. - Ingest, transform, and orchestrate data from multiple sources (SQL, APIs, SaaS applications, streaming sources). - Optimize data models and queries for performance, reliability, and cost efficiency. - Create dashboards, reports, scorecards, and visualizations for operational and executive audiences. - Collaborate with BI developers and analysts to support Power BI semantic models and reporting. - Administer and support enterprise Fabric environments, including workspace design, security, and lifecycle management. - Establish and enforce analytics standards and best practices within the Fabric ecosystem. - Conduct regular data profiling and quality assessments. - Partner with business stakeholders to gather, document, recommend, and refine analytics requirements. - Translate business questions into actionable data solutions. - Prepare process flows, data flow diagrams, and technical documentation. - Support metadata management, lineage, data security, and governance controls. - Automate deployments and data workflows using CI/CD pipelines. - Document data architecture, pipelines, and operational processes. - Contribute to project planning, scope definition, and milestone tracking. - Communicate progress, risks, and dependencies to technical and business stakeholders. - Respond to analytics-related user issues in alignment with service expectations. - Stay current with Microsoft Fabric updates and recommend improvements. - Other duties as assigned. Qualifications - Good Written and Verbal Communications Skills - Good Interpersonal and Multi-tasking skills - Self-Motivated and able to work with little supervision - Excellent Organization and Technical Skills, with the ability to prioritize - Ability to explain technical problems and offer solutions to non-technical users and leadership - Excellent problem-solving skills and the ability to think critically and analytically. - A genuine curiosity about data and a proactive approach to exploring new tools and techniques - Proven ability to form collaborative relationships with stakeholders across the organization - Expertise in relational and dimensional database modeling, data development and administration - Familiarity with data security, role-based access control, and analytics governance models. Requirements - Bachelor’s Degree in Computer Science, Data Analytics, or related field - Minimum 5 years of work experience with SQL Databases and Power BI - Strong experience as a Data Engineer in Azure-based environments. - Hands-on experience with Microsoft Fabric (or strong background in Azure Synapse, Data Factory, and Power BI with readiness to specialize in Fabric). - Familiarity with Azure services such as Azure Data Lake Storage, Azure SQL, and Azure DevOps. - Experience with version control and CI/CD practices. - Experience developing analytics using Power BI or comparable visualization tools - Extensive experience with ETL/ELT pipelines including any combination of modern tools such as SSIS, Azure Data Factory, Function Apps, Logic Apps, etc. - Microsoft certifications (e.g., Fabric Analytics Engineer Associate, Azure Data Engineer) a preferred Benefits - Health Insurance - Flexible Spending Plan - Health Savings Plan - Dental Insurance - Vision Insurance - Paid Time Off - Paid Sick Time - Paid Holidays - 401K/with matching - Overtime Pay (when offered)

Department: 12226 Enterprise Corporate - Enterprise Operational Reporting Status: Full time Benefits Eligible: Yes Hours Per Week: 40 Schedule Details/Additional Information: Remote- Salaried Pay Range $41.10 - $61.65 Major Responsibilities: - Analyze, develop, and enhance analytical and operational data solutions/platforms to meet complex business needs. - Lead metric and/or technical design and documentation efforts in collaboration with operational and IT teams, ensuring alignment with strategic objectives and effective use of data. - Lead multiple medium to large-scale projects and requests using standard project management tools and methodologies. - Translate business requirements into well-designed and validated data solutions that support organizational goals including analysis and validation of data from raw source to data solution. - Provide thorough and accurate documentation for all work, adhering to current industry standards. - Provide production support for ETL/ELT/data solutions, including problem analysis, design, implementation, and rigorous testing of data models, data integrations (ETL, ELT, API,etc.), and reports. - Perform data solutions administration activities including training, on call and/or participating in upgrades/changes through all phases with minimal oversight. - Identify and manage change effectively and efficiently in a changing environment through use of standard processes and tools, working with teammates to utilize change management processes and tools to create plans to support adoption of changes required by project or initiative. - Stay abreast of healthcare environment, EHR, ERP, Cloud, SQL, and BI technology, and industry trends to build professional skills and drive innovation. - Mentor junior team members and provide expertise in the analysis and development of Enterprise data solutions. Minimum Job Requirements Education Bachelor's degree in computer science or equivalent knowledge. Certification / Registration / License - Epic certification(s) in relevant Cogito/reporting application (status of Certified or Accredited) depending on system access - Workday certification(s) in relevant WD reporting application depending on system access - Learning plan requirements to be provided with offer includes any missing Epic Cogito and/or Workday certifications needed to perform role, and certifications must be obtained within 5 months of starting first class Experience Typically requires 2-4 years of experience in a healthcare or comparable setting working with report, data, or analytics development. Specifically, experience with some or all: enterprise EHR, Rev Cycle, and/or ERP application (depending on role); data/BI tools such as Business Objects, Epic Slicer Dicer, PowerBI, Tableau, etc.; database content creation (database tables, views, stored procedures); traditional database platforms such as Oracle, SqlServer, DB2, etc.; cloud data development platforms such as Snowflake, Fabric/Synapse, Redshift, BigQuery,etc.; significant SQL, Python, Java or other data manipulation, procedural, or scripting languages; ETL/ELT and data orchestration tools such as SSIS, ADF, DB2, Informatica, DataStage, etc.; healthcare knowledge (EHR, Quality or ERP data experience). Preferred remote locations in IL, WI, NC, GA Fully Remote Role from these states: AL, AK, AR, AZ, DE, FL, GA, IA, ID, IN, IL (Only WI/IL Division), 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, DC, 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 or transfer of visa for this position now or in the future. Knowledge / Skills / Abilities - Communicate effectively with stakeholders, and cross-functional teams at all organizational levels. - Show excellent analytical and logical thinking, creativity, self-reliance, communication skills, and the ability to work with various components of a system.   - Have experience in logical and physical database design, data modeling, complex queries, business intelligence and ETL tools, and change control methodology.   - Strong understanding of data visualization and data storytelling concepts and EHR and ERP workflows and reporting.   - Strong change management skills and understanding of change management processes. - Work independently or as part of a team and manage multiple priorities while completing tasks efficiently.   - Be a team player with a positive attitude, a strong commitment to customer service, and a willingness to learn healthcare systems and business processes.   - Perform independent analysis on key clinical, financial, ERP, and operational metrics.   - Manage multiple small to medium-sized projects and tasks effectively.   - Mentor and develop junior teammates - Create clear documentation to support education and presentation efforts.   - Self-motivated, solution-focused, and able to function with minimal supervision. - Understanding of software or data development lifecycle and process design - Proficiency with Microsoft products, EHR and ERP workflows and reporting, as well as hardware and software systems.  - Knowledge of ETL/ELT tools and principles, supporting robust data integration and transformation processes.  - Maintain technical currency and advanced certifications in specialized areas of responsibility Physical Requirements and Working Conditions - Travel outside of workplace is required and thus incumbent is exposed to weather and road conditions. - Operates all equipment necessary to perform the job. - Exposed to normal office environment. - Remote work 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. 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 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, 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 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.

• Architect Scalable Data Pipelines: Design, develop, and maintain reliable ETL/ELT workflows using Databricks, Spark, and Python. • Enable Data Access & Analytics: Partner with analytics, product, and engineering teams to ensure timely, accurate, and governed access to data for downstream reporting and analytics. • Optimize Data Workflows: Improve performance, reduce latency, and streamline processes by tuning SQL, optimizing Spark jobs, and enhancing cloud data pipelines. • Leverage Cloud Infrastructure: Utilize AWS services (e.g., S3, Glue, Lambda) to manage and scale data engineering workloads. • Drive Best Practices: Establish and maintain data engineering standards, including code quality, data security, version control, and documentation. • Build & Maintain Data Models: Construct and support dimensional and normalized data models that support cross-functional use cases and reporting needs. • Automation & Monitoring: Set up robust pipeline orchestration (e.g., with Airflow, Databricks Jobs, or AWS Step Functions) and monitoring/alerting systems. • Collaborate Cross-Functionally: Work with data analysts, scientists, and business users to understand requirements and transform raw data into business-ready datasets.