Data Analyst II

Astreya Partners Mexico SRLCV; San Jose (CA); Híbrido; MXN 420.000 - 540.000; Jornada completa

Descripción de la vacante

Astreya is seeking a Data Analyst II to join its analytics team. You will model and analyze structured and unstructured data to develop metrics, reports, and visualizations, ensuring consistency across projects.

You will work closely with development to troubleshoot data issues, create periodic data files, and independently analyze datasets to find efficiency gains. This role requires 5+ years in data analysis and an MBA, with knowledge of SQL, Python, and Google Apps Script.

Formación

• Minimum 5 years of experience in data analysis.
• MBA degree required; additional certifications or technical degrees are a plus.
• Bachelor’s degree (B.S/B.A) from four-year college or university and 2–5 years’ related experience or training.
• Strong SQL and Python skills, and hands-on dashboarding experience.
• Experience with Google Apps Script.

Responsabilidades

• Create data visualizations.
• Troubleshoot and test database 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.
• Assemble large, complex data sets meeting business needs.
• Collaborate with data and analytics experts to improve data systems.
• Other duties as required.

Conocimientos

SQL

Python

Dashboarding

Excel

Apps Script

Educación

MBA degree

Bachelor's degree (B.S./B.A.)

Certifications or technical degrees

Herramientas

Google Apps Script

Descripción del empleo

What this Job Entails:

We are looking for a Data Analyst II 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 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. 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. Core Qualifications

Experience: Minimum 5 years of experience in data analysis. Education: Must-Have: MBA degree. Nice-to-Have: Additional certifications or technical degrees.

2. Technical Must-Haves

Cloud Platforms: 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. Hiring Process

Assessment: Mandatory technical assessment required before scheduling the interview. Required Qualifications/Skills: 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 Qualifications: 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 effective Some positions may require occasional repetitive motion or movements of the wrists, hands, and/or fingers

Astreya is a global IT managed services provider dedicated to creating technology solutions that are reliable and human-centered.

We partner with the world’s most innovative organizations to optimize modern IT environments across the digital workplace, cloud, data, AI, and enterprise platforms.

Our people are our strength. Across regions and roles, Astreyans bring deep expertise, curiosity, and a commitment to excellence.

We believe great technology starts with great humans, which is why we invest in learning, collaboration, and career growth.

At Astreya, transparency, accountability, and trust guide how we work with each other and our customers.

We foster an inclusive culture where diverse perspectives are valued and everyone has the opportunity to make an impact.

Join us to build solutions that matter and shape the future of IT together.

Onwards and upwards!