Data Analyst II

Astreya

3d

About The Position

What this Job Entails: We are looking for a Data Analyst II to join our growing team of analytics experts. The hire will be responsible for statistical modeling, and analysis of structured and unstructured datasets to develop metrics, reports, and visualizations of trends and patterns, and maintain client data systems. The Data Analyst identifies and captures data from internal and external sources. The Data Analyst will ensure consistency throughout ongoing projects. Scope: Uses professional concepts and company objectives to resolve complex issues in creative and effective ways Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors Your Roles and Responsibilities: 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. Other duties as required. This list is not meant to be a comprehensive inventory of all responsibilities assigned to this position

Requirements

• 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

Nice To Haves

• Experience using Google PLX Dashboards

Responsibilities

• 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
• Other duties as required.

Benefits

• Astreya offers comprehensive benefits to all Regular, Full-Time Employees, including:
• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level