• Analyze integrated and extensive datasets to extract value, which directly impacts and influences business decisions • Work collaboratively with key business stakeholders to identify areas of value, develop solutions, and deliver insights to reduce overall cost of care for members and improve their clinical outcomes • Interpret and analyze data from multiple sources including claims, provider, member, and encounters data • Identify and assess the business impact of trends • Develop, maintain, and troubleshoot complex scripts and reports developed using SQL, Microsoft Excel, or other analytics tools • Contribute to the planning and execution of large-scale projects with limited direction from leadership • Assist in the design, testing, and implementation of process enhancements and identify opportunities for automation • Identify and perform root-cause analysis of data irregularities and present findings and proposed solutions to leadership and/or customers • Manage multiple, variable tasks and data review processes with limited supervision within targeted timelines and thrive in a demanding, quickly changing environment • Demonstrate a sense of ownership over projects and ask probing questions to understand the business value of tasks • Apply expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand how customers interact with analytic products • Partner cross-functionally at all levels of the organization and effectively, both verbally and visually, communicate findings and insights to non-technical business partners • Independently engage with customers and business partners to gather requirements and validate results • Communicate and present data-driven insights and recommendations to both internal and external stakeholders, soliciting and incorporating feedback when required • Provide technical guidance to junior analysts

• Analyze integrated and extensive datasets to extract value, which directly impacts and influences business decisions. • Work collaboratively with key business stakeholders to identify areas of value, develop solutions, and deliver insights to reduce overall cost of care for members and improve their clinical outcomes. • Interpret and analyze data from multiple sources including claims, provider, member, and encounters data. • Identify and assess the business impact of trends. • Develop, maintain, and troubleshoot complex scripts and reports developed using SQL, Microsoft Excel, or other analytics tools. • Contribute to the planning and execution of large-scale projects with limited direction from leadership. • Assist in the design, testing, and implementation of process enhancements and identify opportunities for automation. • Identify and perform root-cause analysis of data irregularities and present findings and proposed solutions to leadership and/or customers. • Manage multiple, variable tasks and data review processes with limited supervision within targeted timelines and thrive in a demanding, quickly changing environment. • Demonstrate a sense of ownership over projects and ask probing questions to understand the business value of tasks. • Apply expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand how customers interact with analytic products. • Partner cross-functionally at all levels of the organization and effectively, both verbally and visually, communicate findings and insights to non-technical business partners. • Independently engage with customers and business partners to gather requirements and validate results. • Communicate and present data-driven insights and recommendations to both internal and external stakeholders, soliciting and incorporating feedback when required. • Provide technical guidance to junior analysts.

• Utilize technical, analytical, and programming skills to support all areas of pharmacy services • Maintain the pharmacy’s data warehouse • Design, build and troubleshoot data Extract, Transfer Load (ETL) processes • Design, build and troubleshoot highly functional data visualizations utilizing Microsoft PowerBI or similar tools • Collaborate with pharmacy clinical and operational staff to understand health system needs and devise possible solutions • Keep up to date with the latest technology trends • Collaborate in the design on business processes to allow for appropriate and efficient data collection • Work jointly with stakeholders through the healthcare organization • Take part in and complete technological project work

Lead Data & Analytics Architect (Exempt) Company Overview: Ethos Pet Brands is the parent company of Natural Balance® and Canidae® pet brands. By joining forces under Ethos Pet Brands, these premium Pet Food brands strengthen their commitment to delivering the highest quality nutrition. We believe in the power of strong brands to connect with pet parents and create meaningful experiences. The Lead Data & Analytics Architect will work remotely, and report to the VP, ERP, Integration & IT. This role plays a critical role in ensuring the accuracy, reliability, and usability of the enterprise data platform that powers reporting, analytics, and decision‑making across the company. While our third‑party partner (Accordion) manages data ingestion, modeling, and dashboard development, this role focuses on governing and validating the work, strengthening data trust, and enabling business stakeholders through high‑quality data, documentation, analysis, and training. This person sits within the Data Architecture & Engineering Team and partners closely with Marketing, Sales, Operations, Finance, IT, and our consulting partners. The key responsibilities and duties of this position include, but are not limited to: Data Quality & Governance: - Own data quality validation across certified datasets, KPIs, and semantic layers. - Design, maintain, and monitor Data quality rules, alerts, and issue resolution workflows. - Perform root‑cause analysis and partner with Accordion or source‑system owners to resolve defects. - Ensure correctness, consistency, and alignment of KPI definitions across the organization. Testing and Release Management: - Develop and execute test plans for new datasets, transformations, and reporting assets. - Validate Snowflake models (built by Accordion) before promotion to staging/production. - Conduct regression testing, automated quality checks, and data reconciliation processes. - Manage release documentation and contribute to a clean, governed SDLC. Documentation & Technical Standards: - Maintain clear, comprehensive documentation for datasets, metrics, lineage, and data contracts. - Establish and enforce technical standards for naming conventions, transformations, and certification. - Build and maintain the enterprise KPI catalog and data dictionary. Change Management & Business Enablement: - Support data governance committees and steward groups. - Translate business needs into structured data requirements and acceptance criteria. - Lead training sessions and user enablement for Snowflake, Sigma, KPIs, and certified datasets. - Serve as a subject‑matter expert representing DIG across cross‑functional initiatives. Ad-Hoc Data Analysis & Insights: - Deliver high‑quality analysis using Snowflake, Sigma, and SQL for fast‑turn business questions. - Partner with Finance, Commercial, and Supply Chain to provide insights using certified data. - Support root-cause analytics, variance explanations, operational KPIs, and special projects. Cross-Functional Partnership: - Operate as the primary liaison between DIG, Accordion, and business users for data quality and certification. - Ensure transformation logic and data models meet business requirements and follow governance standards. - Collaborate with business teams to improve data literacy and promote self‑service analytics. What Success Looks Like: - High trust in DIG’s certified datasets and KPIs. - Influence and/or design data architecture foundations that analysts help shape and leverage to accelerate time to insight. - Improved data literacy and adoption of governed self‑service analytics. - Clean, consistent documentation accessible to all analysts. - Strong partnership with Accordion and internal functions to deliver reliable, accurate, and timely insights. MINIMUM QUALIFICATIONS - 5+ years in data analytics, data quality, data engineering support, or BI-focused roles - Advanced SQL proficiency (Snowflake preferred). - Strong analytical skills with ability to translate data into meaningful business insights. - Experience working in CPG, retail, or manufacturing, with deep business acumen in areas such as marketing, planning, sales, manufacturing, or financial analysis. - Hands-on experience with Snowflake, dbt (reading/understanding models), Sigma, or similar BI tools. - Strong documentation, testing, and data governance capabilities. - Excellent communication skills; able to partner across technical and non-technical teams. - Understanding of data lineage, semantic modeling, and KPI frameworks. - Must be willing to submit a background check and pre-employment drug screening - Must be eligible to work in the US Nice to have: - Experience collaborating with third‑party analytics partners or offshore teams. - Familiarity with ELT/ETL concepts even if not hands-on (Fivetran, dbt). - Knowledge of change management frameworks (Prosci, ADKAR, or similar). - Exposure to AI/ML‑ready data architectures. ESSENTIAL FUNCTIONS - Must be able to relay accurate information via multiple communication channels including verbal and written mechanisms - Ability to remain in a stationary position for up to 8 hours - Ability to operate a computer and other office technology - Ability to observe details at close range - Occasionally travel for work up to 10% BENEFITS - 401K matching - Medical - Dental - Vision - Short Term Disability - Long Term Disability - HSA & FSA - Pet Insurance - Life Insurance - Employee Assistant Program - Referral Program - And more! Ethos is proud to be an Equal Employment Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. All employment is decided on the basis of qualifications, merit, and business need.