Data Analyst Job at BLEHEALTH, Pomona, CA

QlRPVFlRZlJIY2lQWkYwUVpOR095ZlN0NlE9PQ==
  • BLEHEALTH
  • Pomona, CA

Job Description

Professional Summary:

The Data Analyst will be responsible for consolidating, validating, and transforming data to support operational reporting and business decision‑making. This role requires strong analytical skills, advanced Excel proficiency, and the ability to work with large datasets from multiple sources. The ideal candidate is detail‑oriented, technically adept, and comfortable producing accurate reports in a fast‑paced environment.

Key Responsibilities

  • Consolidate data from multiple sources using functions such as VLOOKUP, INDEX‑MATCH, and XLOOKUP.
  • Perform data cleaning, validation, and error identification to ensure accuracy and consistency.
  • Build and maintain weekly and monthly reports, including KPI tracking dashboards and PivotTables.
  • Transform raw data into structured, actionable formats for internal stakeholders.
  • Support ad‑hoc analysis and troubleshoot discrepancies across datasets.

Required Skills & Tools

  • Advanced Excel skills: VLOOKUP, HLOOKUP, INDEX‑MATCH, XLOOKUP, PivotTables, SUMIF/COUNTIF, and data formatting.
  • Strong competency in data manipulation, including working with large multi‑tab or multi‑workbook datasets.
  • Technical aptitude with relational databases, SQL queries (e.g., joins), and basic familiarity with Python, Power Query, Tableau, and Jira.

Job Requirements

Demonstrated experience using VLOOKUPs, PivotTables, SUMIF/COUNTIF, and other advanced Excel functions.

Ability to perform data mining, data cleansing, and validation using Excel‑based lookup tools.

Must‑have skills: Advanced Excel, specifically VLOOKUP and PivotTables.

Job Tags

Similar Jobs

WEB PEPPERS

Senior Android Engineer Job at WEB PEPPERS

 ...Apps Platform works as a platform team for all other mobile engineers at Reddit to build on top of. Our customers are primarily other engineers. Its our job to help improve developer efficiency by providing libraries/APIs/frameworks, monitoring performance, building... 

Stellar Professionals

PMP Certified Project manager Job at Stellar Professionals

 ...We are seeking a senior-level PMP Certified Project manager to lead complex IT initiatives through the full project lifecycle. This role acts as a hands-on technical liaison between development staff and business groups to ensure the delivery of high-priority technology... 

Two Circles

Marketing Lead Job at Two Circles

 ...We are Two Circles. We are a Sports & Entertainment Marketing business. We grow audiences and revenues. We do that by knowing fans best. We work with clients to help them understand & influence what their fans are doing the way fans spend their money, the events that... 

Ponca City Development Authority

Delivery Driver Job at Ponca City Development Authority

 ...TPI Staffing Service is looking for a Delivery Driver. Please apply at or stop by the office at 215 N 3rd St to complete the application...  ...posted by Ponca City Development Authority and is being hired by a local employer. NOW HIRING: DELIVERY DRIVER Were looking for... 

Another Source

Director of Federal Government Relations UC Riverside Job at Another Source

 ...public policy and building strategic relationships in Washington D.C. Reporting to the Assistant Vice Chancellor for Government & Community Relations this leader will help elevate UCRs national voice and advance priorities across research healthcare economic development...