Collective Health

Data & Reporting Analyst

Collective Health$76K — $96K *
Lehi, UT 84043In-Person
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3-5 years of experience as a Data Analyst or Reporting Analyst
  • Advanced proficiency in data visualization tools, particularly Google Looker
  • Strong analytical skills with a talent for actionable insight generation
  • Experience with data integration and modeling from various sources
  • Excellent SQL skills for efficient data manipulation
  • Strong attention to detail and commitment to data accuracy
  • Exceptional communication skills for conveying technical information effectively

Responsibilities

  • Perform in-depth data analysis to uncover trends and insights for decision-making
  • Design and develop reports and dashboards, primarily using Looker
  • Write efficient SQL queries to access and analyze data from multiple sources
  • Implement Looker LookML models for integrated data analysis and reporting
  • Conduct thorough data validation and ensure reliability of insights
  • Enhance report performance and optimize data models for quicker processing
  • Collaborate with stakeholders to translate business requirements into data solutions

Benefits

  • Health insurance
  • 401(k) plan
  • Paid time off
  • 35,000 stock options
  • Hybrid work model, with a minimum of three days in the office per week
Full Job Description
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 Statement

This is a hybrid position based out of our Lehi office, with the expectation of being in office at least three weekdays per week. #LI-hybrid

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. Learn more about our benefits at https://jobs.collectivehealth.com/benefits/.

Lehi, UT Pay Range

$76,800-$96,000 USD

About Collective Health

Collective Health is a technology company that provides a cloud-based platform for self-insured employers to manage their employee health benefits. The platform includes tools for plan design, enrollment, claims processing, and member engagement. Collective Health was founded in 2013 and is headquartered in San Francisco, California. The company has raised over $400 million in funding and has partnerships with several major insurance carriers, including Aetna, Cigna, and Anthem.
Learn more about Collective Health
Size
500 employees
Industry
Founded
2013

Similar Jobs

More Jobs at Collective Health

More Information Technology Jobs

Find similar Data & Reporting Analyst jobs: