Data Analyst II
- Mexico City, Mexico +1
- Remote
- Mid Level
- 5+ years
- Bachelor's degree
- Posted
Skills
Required
- GCP
- Azure
- AWS.Programming
- Querying
- SQL
- Python.Visualization
- dashboarding
- experience.Apps Script
- Google Apps
- Script.3
- SQL coding
- formulas
Preferred
- 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.
