Data Analyst II

Company 

Astreya is the leading IT solutions provider to deliver technology-enabled services and fuel digital transformation to some of the most exciting companies on the planet. We are at the cusp of a new way of working with our delivery model that helps our clients be positively productive by matching exceptional people to on-site teams delivering world-class IT service. With engineers in over 30 countries and 70 cities around the world, we are a global company working with the world's most recognizable and innovative organizations.

Job Description

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. 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

Required Qualifications/Skills:

• 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

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

What can Astreya offer you?

• Employment in the fast-growing IT space providing you with a variety of career options

• Opportunity to work with some of the biggest firms in the world as part of the Astreya delivery network

• Introduction to new ways of working and awesome technologies

• Career paths to help you establish where you want to go

• Focus on internal promotion and internal mobility - we love to build teams from within

• Free 24/7 accessible Professional Development through LinkedIn Learning and other online courses to give you opportunities to upskill at your own pace

• Education Assistance

• Dedicated management to provide you with on point leadership and care

• Numerous on the job perks

• Market competitive compensation and insurance, health and wellness benefits