What this Job Entails:
We are looking for a Data Analyst III 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:
Resolves a wide range of issues in creative ways
Seasoned, experienced professional with a full understanding of their speciality
Works on problems of a diverse scope
Receives little instruction on day to day work, general instruction on new assignments
What you'll do
Create advanced data visualizations
Create complex reports using scripts and reporting tools
Design and generate consensus and statistical demand forecast reports and continuously improve forecasting techniques, method, and approach
Perform Exploratory Data Analysis (EDA) to identify improvements/automation opportunities
Independently analyze data sets to identify opportunities for increased accuracy and efficiency
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 5 to 8 years’ related experience and/or training; or equivalent combination of education and experience
Networks with senior internal and external personnel in own area of expertise
Demonstrates good judgment in selecting methods and techniques for obtaining solutions
5+ years of experience managing large data sets and creating visual data
Advanced SQL skills; including creating and modifying macros, writing complex joins, build datasets for reporting and analysis,as well as creating dashboards using SQL coding
Experience using Google PLX Dashboards and UI Insights
Excellent written communication skills
High level of attention to detail
Advanced Google Sheets 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
Some positions may require occasional repetitive motion or movements of the wrists, hands, and/or fingers
Nice to have
Experience using Google PLX Dashboards
Looker, and Tableau
Cloud Experience is a Plus
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