Data & Reporting Analyst

Data & Reporting AnalystCollective Health is the leading health benefits platform that brings together medical, dental, vision, pharmacy, and program partners into an integrated solution that better enables employees and their families to understand, navigate, and pay for healthcare.Job DescriptionAt Collective Health, we're transforming how employers and their people engage with their health benefits by seamlessly integrating cutting-edge technology, compassionate service, and world-class user experience design.Collective Health is expanding its Customer Experience team! We believe health benefits should be simple, accessible, and technology-driven. But moreover, we believe healthcare should be grounded by the people that it serves. To accomplish this, we are reimagining the operational core of health insurance. We are seeking leaders to help deliver on this vision.We are looking for a Data and Reporting Analyst to help further develop and measure the customer experience delivered by our Customer Experience teams. In this role, you will work closely with the Customer Experience team, serving as a thought partner in coordinating and collaborating internally on the design, execution, and measurement of our customer experience. You will be responsible for driving the data and reporting strategy to help achieve our customer experience operational strategy.What you'll do:Data Analysis: Perform in-depth data analysis, interpreting complex datasets, identifying trends, and extracting actionable insights to support strategic decision-making. Guide users on visualization and data analysis best practices.Reporting Solutions: Design and develop sophisticated reports, dashboards, and visualizations primarily using Google's Looker data analytics platform. Experience with data analysis tools like Looker, Excel/Gsheets, Tableau, Power BI, or similar platforms is also valuable.SQL Knowledge: Write efficient SQL queries to retrieve and analyze data from various databases/data sources, ensuring data accuracy and reliability.Data Modeling: Implement efficient Looker LookML data models to integrate multiple data sources and create unified datasets for analysis and reporting.Data Validation: Ensure the accuracy and reliability of data by conducting thorough data validation and reconciliation processes.Performance Optimization: Enhance the performance of reports and Looker data models, optimizing data retrieval and processing.Strategic Business Partner: Serve as a consultative partner to CX leadership, translating high-level business goals into data strategies. You will facilitate discovery sessions, manage stakeholder expectations, and proactively advise on how data can solve operational challenges.Business Requirements: Collaborate with stakeholders to gather and document business requirements, translating them into actionable data solutions. Become a subject matter expert and consulting partner for our stakeholders. Partner with customer experience leadership to define key performance indicators (KPIs) that directly impact operational strategy.Data Presentation: Present findings and insights to non-technical audiences in a clear and compelling manner, enabling informed decision-making.Process Improvement: Identify opportunities to streamline data analysis and reporting processes, implementing best practices to improve efficiency.Data Governance: Uphold data governance, quality, and security standards, ensuring data compliance and confidentiality.Additional project work as assigned.To be successful in this role, you'll need:Proven experience (3-5 years) as a Data Analyst, Reporting Analyst, or in a similar role.Advanced proficiency in data analysis and visualization tools (Google Looker / LookML is strongly preferred). Candidates with equivalent proficiency in tools such as Tableau, Power BI, or equivalent will also be considered if they have a strong aptitude for learning looker quickly.Strong analytical and problem-solving skills, with the ability to translate data into actionable insights.Experience with data integration and data modeling to consolidate data from various sources.Excellent SQL skills to retrieve and manipulate data efficiently.Knowledge of data visualization best practices, enabling effective communication of insights.Strong attention to detail and a commitment to data accuracy.Ability to work independently and collaboratively within a team environment.Exceptional interpersonal communication and presentation skills, with the ability to convey technical information to non-technical stakeholders.Pay Transparency StatementThis is a hybrid position based out of our Lehi office, with the expectation of being in office at least three weekdays per week. The actual pay rate offered within the range will depend on factors including geographic location, qualifications, experience, and internal equity. In addition to the salary, you will be eligible for 35,000 stock options and benefits like health insurance, 401k, and paid time off. Lehi, UT Pay Range $76,800 - $96,000 USDWhy Join Us?Mission-driven culture that values innovation, collaboration, and a commitment to excellence in healthcareImpactful projects that shape the future of our organizationOpportunities for professional development through internal mobility opportunities, mentorship programs, and courses tailored to your interestsFlexible work arrangements and a supportive work-life balance