Role Description Under the direction of data & analytics engineering leadership, the Analytics Engineer II will own and operationalize analytics artifacts for one or more domains (e.g. pharmacy, pediatrics service line, supply chain), build and maintain metrics stores/semantic layers, improve reuse and performance of data models, and enable domain adoption in a federated model. This role will work closely with operational stakeholders, product team members, and data stewards to ensure successful delivery of analytics products that support business goals. - Prepare and model analytically ready datasets. - Implement and maintain semantic layers, metrics stores or data marts. - Apply data engineering best practices to analytics (version control, CI/CD, environment management). - Collaborate with BI analysts, data scientists and domain stakeholders to operationalize analytics products. - Ensure alignment with governance and data quality requirements. Qualifications - At least 3 years in analytics/data roles with demonstrated delivery of analytics artifacts. - Experience with dbt or other analytics engineering tools. - Hands-on CI/CD and orchestration tool usage. - At least 3 years advanced SQL, dbt or equivalent transformation frameworks. - Familiarity with metrics store concepts and knowledge-graph/ontology basics for semantic enrichment where applicable. - At least 3 years ability to implement CI/CD for analytics, automated testing, environment promotion and metadata/catalog integration. - At least 3 years proficiency with at least one cloud data platform (Snowflake, Databricks, MS Fabric) and BI tool optimizations (Power BI/Tableau performance tuning). - At least 1 year exposure to machine learning, data science, or artificial intelligence concepts preferred. - At least 1 year experience working in healthcare or other regulated industry preferred. Requirements - Four-year Bachelor's degree or equivalent experience in Computer Science, MIS, Engineering, or related field required. - Analytics related certifications (e.g. Dbt Analytics Engineering, Microsoft Fabric Analytics Engineer Associate, Snowflake SnowPro, Databricks, Epic Cogito) or a learning plan requirement to be provided with offer includes missing relevant certifications needed to perform role, and certifications must be obtained within 180 days of starting first class. Benefits - Employee portion of medical plan premiums are covered after 3 years. - 4%-10% employee savings plan match based on tenure. - Paid Parental Leave (up to 12 weeks). - Caregiver Leave. - Adoption and surrogacy reimbursement.

• Define and manage data product roadmap, epics, and tasks needed to deliver client outcomes • Transform raw data into actionable insights that drive strategic business decisions • Analyze data to identify trends, patterns, and insights • Leverage your expertise in data visualization in tools such as Databricks, Tableau, Power BI and MS Excel to create compelling visual representations of your findings • Assist the client in dashboarding, ensuring that stakeholders can easily understand and act on the insights you provide • Develop detailed reports that summarize your analyses, offering clear and concise recommendations to support decision-making processes

• Design and develop interactive reports and dashboards using Power BI to visualize complex data sets. • Develop and optimize Power BI DAX measures to calculate key performance indicators (KPIs) and metrics. • Leverage Microsoft Power Query for data transformations and cleansing tasks. • Explore and integrate additional data sources, including those from Snowflake. • Ensure data accuracy, consistency, and reliability in all reporting outputs. • Continuously improve and optimize existing reports and dashboards based on user feedback and evolving business requirements. • Drive the adoption of reports and dashboards by monitoring report usage and customer feedback. • Perform full end-to-end development of BI reporting needs, from requirements gathering, schema creation and ultimately publishing production ready dashboards and reports. • Translate business requirements into production reports for designated internal departments and business users. • Manage designated Microsoft Teams channel and communication with business and stakeholders. • Manage Power BI Workspaces including access to specific reports utilizing RLS (Role Level Security). • Assist with updating and maintaining departmental confluence pages. • Leverage Jira ticketing system to track and update requests from the business. • Stay up-to-date with industry best practices and emerging trends in business intelligence and data visualizations. • Responsible for maintaining regular communication with designated business units on a regular basis to foster communication and set delivery expectations.

• Design, develop, and maintain complex data models in our Snowflake data warehouse. • Leverage Snowflake Intelligence features to implement conversational data queries and AI-driven insights. • Design and build advanced SQL queries to retrieve and manipulate complex data sets. • Develop, maintain, and optimize Looker dashboards and LookML to effectively communicate data insights. • Communicate effectively with stakeholders to understand business requirements and deliver data-driven solutions. • Write efficient Python code for data analysis, data processing, and automation of recurring tasks. • Create compelling visualizations and presentations to deliver analytical insights and actionable recommendations. • Stay up-to-date with industry trends, emerging tools, and best practices in data engineering and analytics.