Data Analyst II

Astreya

Data Analyst II creating data visualizations and working on complex data analysis for Astreya. Collaborating with development teams to resolve database issues and ensuring data integrity.

Posted 6/9/2026full-timeRemote • 🇺🇸 United StatesJuniorMid-Level💰 $66,120 - $104,400 per yearWebsite

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Create data visualizations
Troubleshoot and test database technical issues with development team
Create monthly Excel and Google Sheets files from database
Independently analyze data sets to identify opportunities for increased accuracy and efficiency
Perform quality assurance on data to determine potential data gaps
Handle data-related technical issues and support data infrastructure needs
Assemble large, complex data sets that meet functional / non-functional business
Work with data and analytics experts to strive for greater functionality in our data systems.

Requirements

What you’ll need

Bachelor’s degree (B.S/B.A) from four-college or university and 2 to 5 years’ related experience and/or training; or equivalent combination of education and experience
Builds productive internal and external working relationships
Exercises judgment within defined procedures and practices to determine appropriate action
SQL skills; including creating and modifying macros, as well as creating dashboards using SQL coding
Excellent written communication skills
High level of attention to detail
Advanced Excel skills to include; formulas, functions, pivot tables, lookup and reference formulas (i.e. vlookups), statistical formulas (countifs, sumifs), macros (ability to create new and edit existing), conditional formatting, importing data, creating graphs/charts, etc.
Ability to independently analyze large amounts of data; including the ability to identify, analyze, and interpret trends, gaps, patterns in complex data sets
Preferred Qualifications: Experience using Google PLX Dashboards

Benefits

Comp & perks

Medical provided through UHC (PPO, HSA, Surest options)
Medical provided through Kaiser (HMO option only) for California employees only
Dental provided through UHC Nationwide
Vision provided by UHC
Flexible Spending Account for Health & Dependent Care
Pre-Tax Account for Commuter Benefit/Parking & Transit (location-specific)
Continuing Education and Professional Development via various integrated platforms, e.g. Udemy and Coursera
Corporate Wellness Program provided by Goomi Group
Employee Assistance Program
Wellness Days
401k Plan
Basic and Supplemental Life Insurance
Short Term & Long Term Disability
Critical Illness, Critical Hospital, and Voluntary Accident Insurance
Tuition Reimbursement (available 6 months after start date, capped)
Paid Time Off (accrued and prorated, maximum of 120 hours annually)
Paid Holidays
Any other statutory leaves, paid time, or other ancillary benefits required under state and federal law

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata visualizationExcelGoogle Sheetsdata analysisquality assurancemacrospivot tablesstatistical formulasconditional formatting

Soft Skills

communicationattention to detailjudgmentrelationship buildingindependent analysis