Astreya

Data Analyst III

Astreya

full-time

Posted on:

Location Type: Remote

Location: Mexico

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

SQL

About the role

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

  • 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
  • 5+ years of experience managing large data sets and creating visual data
  • 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
Benefits
  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data visualizationreporting toolsstatistical demand forecastingExploratory Data Analysis (EDA)SQLExcelGoogle Sheetsdata quality assurancedata analysisdata automation
Soft Skills
written communicationattention to detailindependent analysis