Data Analyst I

What this Job Entails:

We are looking for an entry level Data Analyst to join our growing team of analytics experts. The hire will be responsible for supporting our data analysts with statistical modeling and analysis of structured and unstructured datasets to develop metrics, reports, and visualizations of trends and patterns. The Data Analyst will support our data analyst team to identify and capture data from internal and external sources. The Data Analyst will assist in ensuring consistency throughout ongoing projects. 

Scope: 

• Applies company policies and procedures to resolve routine issues

• Works on problems of limited scope

• Receives detailed instructions

Your Roles and Responsibilities:

• Create basic data visualizations 

• 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

• Analyze data to determine potential data gaps

• Work with Senior Data Analysts to assist with data-related technical issues and support their 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

Required Qualifications/Skills:

• Bachelor’s degree (B.S/B.A) from four-college or university and 0 to 2 years’ related experience and/or training; or equivalent combination of education and experience 
• Builds stable working relationships internally
• Follows standard practice and procedures when analyzing situations or data
• 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: 

• SQL skills; including creating and modifying macros, as well as creating dashboards using SQL coding

• Experience using Google PLX Dashboards

Physical Demand & Work Environment:

• Must have the ability to perform office-related tasks which may include prolonged sitting or standing

• Must have the ability to move from place to place within an office environment

• Must be able to use a computer

• Must have the ability to communicate effectively 

• Some positions may require occasional repetitive motion or movements of the wrists, hands, and/or fingers

Salary Range

• Please note that the salary information provided herein is base pay only (gross); it does not include other forms of compensation which may or may not apply to this specific position, namely, performance-based bonuses, benefits-related payments, or other general incentives - none of which are guaranteed, may be subject to specific eligibility requirements, and are wholly within the discretion of Astreya to remit.
• Further, the salary information noted above is a range that consists of a minimum and maximum rate of pay for this specific position. Where an applicant or employee is placed on this range will depend and be contingent on objective, documented work-related considerations like education, experience, certifications, licenses, preferred qualifications, among other factors.

Astreya offers comprehensive benefits to all Regular, Full-Time Employees, including:

• Medical provided through Cigna (PPO, HSA, EPO options) / Medical provided through Kaiser (HMO option only) for California employees only

• Dental provided through Cigna (DPPO & DHMO options)

• Nationwide Vision provided through VSP

• 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

• Employee Assistance Program

• Wellness Days

• 401k Plan

• Basic Life, Accidental Life, 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 fringe benefits required under state and federal law

Salary : $24 - $38