jobapplier

Data Analyst II

Astreya

Skills

Required

  • GCP
  • Azure
  • AWS.Programming
  • Querying
  • SQL
  • Python.Visualization
  • dashboarding
  • experience.Apps Script
  • Google Apps
  • Script.3
  • SQL coding
  • formulas

Preferred

  • Google
  • PLX Dashboards
  • Physical Demand
  • statistical modeling
  • data-related

We are looking for a Data Analyst II to join our growing team of analytics experts.

Responsibilities

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

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.

Requirements

  • This list is not meant to be a comprehensive inventory of all responsibilities assigned to this position Job Role: Data Analyst (5+ Years Experience)1.
  • Minimum 5 years of experience in data analysis.Education:Must-Have: MBA degree.Nice-to-Have: Additional certifications or technical degrees.2.
  • Experience required across GCP, Azure, and AWS.Programming & Querying: Strong proficiency in SQL and Python.Visualization: Hands-on dashboarding experience.Apps Script: Understanding of Google Apps Script.3.
  • 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

  • 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

Hiring ProcessAssessment

Mandatory technical assessment required before scheduling the interview.