Data Analyst II: Metrics, Modeling & Dashboards

Astreya; México; On-site; MXN 350,000 - 550,000; Full time

Job summary

Astreya is seeking a Data Analyst in Mexico to model and analyze 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. Responsibilities include troubleshooting database issues, creating monthly Excel and Google Sheets files, and independently analyzing data to improve accuracy and efficiency.

Qualifications

• Bachelor’s degree and 2–5 years’ related experience or equivalent education.
• Experience with SQL and data visualization is preferred.
• Strong Excel skills including pivots, lookups and macros.

Responsibilities

• Troubleshoot and test database issues with development team.
• Create monthly Excel and Google Sheets files from database.
• Independently analyze data to identify opportunities for accuracy and efficiency.
• Perform quality assurance on data to identify gaps.
• Support data infrastructure needs and data-related issues.
• Assemble large, complex data sets meeting business requirements.
• Collaborate with data/analytics experts to improve data systems.
• Other duties as required.

Skills

Data analysis

SQL skills

Attention to detail

Stakeholder relations

Dashboard creation

Education

Bachelor’s degree in related field

Tools

SQL

Excel

Macros (Excel)

Job description

Astreya is seeking a Data Analyst in Mexico to model and analyze 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. Responsibilities include troubleshooting database issues, creating monthly Excel and Google Sheets files, and independently analyzing data to improve accuracy and efficiency.