Data & Reporting Analyst
Share
Job Location:
Monthly Salary:
Posted on:
13 hours ago
Vacancies:
1 Vacancy
Job Summary
At Collective Health were 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 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 youll 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 Googles 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 youll need:
- Proven experience (2-4 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 Statement
This is a hybrid position based out of our Lehi office with the expectation of being in office at least two weekdays per week.#LI-hybrid
The actual pay rate offered within the range will depend on factors including geographic location qualifications experience and internal addition to the salary you will be eligible for 35000 stock options and benefits like health insurance 401k and paid time off. Learn more about our benefits at UT Pay Range
Key Skills
- Cognos
- Microsoft Access
- SQL
- Crystal Reports
- Financial Report Writing
- Power BI
- Pivot tables
- ssrs
- Tableau
- Regulatory Reporting
- SAS
- Data Analysis Skills
About Company
Collective Health offers the first integrated solution that empowers employers to administer plans, manage costs, and take care of their people—all in one place.
