Data Analyst

Stefanini Group; Mexico; On-site; PHP 3,762,000 - 5,643,000; Full time

Job summary

Stefanini Group is seeking a Data/BI Analyst to design, develop, and maintain dashboards in Tableau and Power BI, delivering actionable insights from manufacturing, operational, and financial data. You will own end-to-end reporting from requirements to production-grade visuals.

The role requires 2+ years in a data/BI analytics capacity, strong SQL for Snowflake, and foundational dbt knowledge; familiarity with SAP data and KPI development is a plus. A portfolio of dashboards is expected.

Qualifications

• Experience: 2+ years in a data analyst, BI analyst, or reporting analyst role with a portfolio of dashboards and reports delivered to business stakeholders.
• Technical Prowess: Strong proficiency in Tableau and/or Power BI: calculated fields, LOD expressions (Tableau), DAX measures (Power BI), parameters, dynamic filters, row-level security, and performance optimization.
• Working knowledge of SQL for querying Snowflake: JOINs, CTEs, window functions, aggregations, and basic data transformation.
• Foundational understanding of dbt: ability to read and modify existing models, understand the staging/mart layer structure, and run dbt commands for testing and documentation.
• Familiarity with data modeling concepts: star schemas, fact/dimension tables, and how they translate into efficient dashboard data sources.
• Basic Python skills for data wrangling, automation, or extending analytics workflows (pandas, notebooks).
• Domain Knowledge (Nice to have): Understanding of SAP data across various domains. Experience developing KPIs such as production metrics, cost tracking, supply chain KPIs, or ERP/MES data.

Responsibilities

• Build Dashboards & Reports: Design, develop, and maintain interactive dashboards and reports in Tableau and/or Power BI that deliver actionable insights to business stakeholders.
• Data Analysis & Storytelling: Analyze manufacturing, operational, and financial data to identify trends, anomalies, and opportunities; translate findings into clear visual narratives.
• SQL & Data Exploration: Write SQL queries in Snowflake to extract, transform, and validate data for reporting; perform ad-hoc analyses.
• Support Data Modeling: Collaborate with data engineers to define reporting requirements and contribute to dbt model development.
• Analytical Mindset: Maintain high attention to detail, detect data inconsistencies, and deliver accurate, trustworthy reporting.
• Documentation & Training: Document data definitions, metric calculations, and dashboard usage guides; provide training to promote self-service analytics.

Skills

Dashboards

Data storytelling

Analytical mindset

Python basics

Data quality

Tools

Tableau

Power BI

Snowflake

dbt

SQL

Python

Job description

• Build Dashboards & Reports: Design, develop, and maintain interactive dashboards and reports in Tableau and/or Power BI that deliver actionable insights to business stakeholders. Own the full lifecycle from requirements gathering to published, production-grade visualizations.
• Data Analysis & Storytelling: Analyze manufacturing, operational, and financial data to identify trends, anomalies, and opportunities. Translate findings into clear, compelling visual narratives that drive decision-making across teams.
• SQL & Data Exploration: Write SQL queries in Snowflake to extract, transform, and validate data for reporting. Perform ad-hoc analyses to answer business questions and support strategic initiatives.
• Support Data Modeling: Collaborate with data engineers to define reporting requirements and contribute to dbt model development - building or modifying staging and mart models that feed dashboards and reports.
• Analytical Mindset: Strong attention to detail with the ability to spot data inconsistencies, ask the right questions, and deliver accurate, trustworthy reporting.
• Documentation & Training: Document data definitions, metric calculations, and dashboard usage guides. Provide training and support to business users to promote self‑service analytics adoption.

Expectation from the Candidate

• Experience: 2+ years of experience in a data analyst, BI analyst, or reporting analyst role with a portfolio of dashboards and reports delivered to business stakeholders.
• Technical Prowess:
• Strong proficiency in Tableau and/or Power BI: calculated fields, LOD expressions (Tableau), DAX measures (Power BI), parameters, dynamic filters, row‑level security, and performance optimization.
• Working knowledge of SQL for querying Snowflake: JOINs, CTEs, window functions, aggregations, and basic data transformation.
• Foundational understanding of dbt: ability to read and modify existing models, understand the staging/mart layer structure, and run dbt commands for testing and documentation.
• Familiarity with data modeling concepts: star schemas, fact/dimension tables, and how they translate into efficient dashboard data sources.
• Basic Python skills for data wrangling, automation, or extending analytics workflows (pandas, notebooks).
• Domain Knowledge (Nice to have): Understanding of SAP data across various domains such Finance, Operations, Quality etc. Experience developing KPIs such as production metrics, cost tracking, supply chain KPIs, or ERP/MES data. Familiarity with financial reporting or cost-per‑unit analysis is a strong plus.

Nice to have

• Experience publishing and managing content on Tableau Server/Cloud or Power BI Service, including scheduling refreshes and managing access.
• Exposure to Snowflake features beyond basic SQL: roles, warehouses, data sharing, or Snowsight dashboards.
• Knowledge of data visualization best practices and accessibility standards.
• Experience maintaining assets & access controls on Tableau/ Power BI environments
• Experience with Microsoft Fabric & publishing data assets via Fabric