SQL Data Analyst

We are looking for a Data Analyst IV 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 advanced data visualizations
• Troubleshoot and test database technical issues with development team
• Create monthly Excel and Google Sheets files from database
• 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.
• Design and generate consensus and statistical demand forecast reports and continuously improve forecasting techniques, method, and approach
  
• Design and generate automation scripts and models to improve efficiencies
• Evolve and maintain documentation and standard operating procedures for demand planning processes and systems
• Perform Exploratory Data Analysis (EDA) to identify improvements/automation opportunities
• Troubleshoot and test database for technical issues with development team
• Independently analyze data sets to identify opportunities for increased accuracy and efficiency
• 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.
• Provide reports to senior management for Monthly briefingsSupport in very large scale projects covering all geographic regions
• 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 8+ years’ related experience and/or training; or equivalent combination of education and experience
• Demonstrates good judgment in selecting methods and techniques for obtaining solutions
• Networks with key contacts outside own area of expertise

• Looking to get Placed? Try our Placement Guarantee Plan

  Get Hired
  Excellent analytical skills, tenacious problem solver with strong verbal communication skills
• Experience working with Big Data to provide EDA to senior team leads
• Ability to determine methods and procedures on new assignments and coordinate activities of other personnel
• Experience managing large data sets and creating visual 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
• Ability to successfully work across multiple levels of an organization with experience leading cross-functional process improvements

Preferred Qualifications:

• SQL skills; including creating and modifying macros, as well as creating dashboards using SQL coding
• Experience using Google PLX Dashboards
• Coding languages
• Proven track record of achieving objectives on schedule and within budget