80/20 Data Analyst

TL;DR

80/20 Data Analyst (Power BI/SQL): Support MCS Business Operations in executing analytics for 80/20 transformation, growth initiatives, and operational productivity with an accent on data collection, SQL querying, Power BI dashboards, and KPI monitoring. Focus on variance analysis, trend identification, executive reporting, and scenario modeling to drive business decisions.

Location: Hybrid in Chihuahua or Aguascalientes, Mexico

Company

Fortune 500 global water technology company with 23,000 employees in over 150 countries, addressing critical water challenges through innovative solutions.

What you will do

• Collect, organize, validate, and analyze data from multiple sources for leadership decision-making and cross-functional reviews.
• Build, maintain, and enhance Power BI dashboards and recurring reports for key business performance indicators.
• Write and optimize SQL queries to extract and prepare data for reporting and analysis.
• Conduct 80/20 segmentation analysis across products, customers, and markets to identify opportunities.
• Perform KPI monitoring, variance analysis, trend analysis, and scenario modeling for business prioritization.
• Develop executive-level reporting materials, translate data into insights, and partner with stakeholders.

Requirements

• Bachelor’s degree in Business, Finance, Economics, Data Analytics, Information Systems, Statistics, Engineering, or related field.
• 3-7 years of experience in analytics, reporting, business intelligence, finance, or operations.
• Proficiency in SQL for querying, extracting, and manipulating data.
• Proficiency in Power BI for dashboard development, visualization, and reporting.
• Strong analytical, problem-solving, communication, and organizational skills; proficiency in Excel and PowerPoint.
• Ability to work collaboratively in cross-functional environment.

Nice to have

• Experience with business performance reporting, KPI dashboards, or operational analytics in corporate/manufacturing.
• Knowledge of 80/20 analysis, segmentation, profitability, variance analysis, or forecasting.
• Experience with large datasets, data governance, enterprise systems, or supporting leaders with insights.

Culture & Benefits

• Focus on data-to-decisions mindset, learning agility, stakeholder engagement, clear communication, and action orientation.
• Emphasis on collaboration, operational rigor, continuous improvement, and professionalism.
• Global team environment with commitment to inclusion, innovation, and sustainable impact in water solutions.