Data and Reporting Analyst

ESA - Electronic Security Association

Data & Reporting Analyst driving commercial insights for ADI, a global security, AV, and smart-living technology distributor. Building dashboards, KPIs, campaign reporting, and analyses for North American commercial operations.

Posted 8/13/2026full-timeSan Luis Potosí • 🇲🇽 MexicoJuniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, business intelligence, and financial modeling to drive customer acquisition and retention strategies. Proficient in developing KPIs and executive dashboards while effectively communicating insights to senior leadership.

Highest-signal resume keywords

Advanced Microsoft Excel ProficiencySQL or Comparable Query LanguageBusiness Intelligence Tools (Power BI Preferred)Analytical Experience in Investment Banking or FP&AStrong Written and Verbal Communication Skills

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisFinancial ModelingKPI DesignDashboard DevelopmentData ManipulationRelational DatabasesSQLPower Query (M)DAXPython or R

Soft Skills

Attention to DetailIntellectual CuriosityResults-OrientedInfluencing SkillsAbility to Operate Autonomously

Tools & Technologies

Power BITableauLookerERP SystemsBusiness Intelligence Tools

Industry Keywords

Customer AcquisitionShare-of-Wallet ExpansionRetentionB2BCommercial/Sales-Driven Environments

Tech Stack

Tools & technologies

ERPPythonSQLTableau

About the role

Key responsibilities & impact

Partner with commercial leaders to produce recurring and ad-hoc analyses driving customer acquisition, share-of-wallet expansion, and retention.
Build and maintain business intelligence dashboards and reporting tools for real-time performance visibility across sales, marketing, and finance.
Design KPIs, financial analyses, and executive-ready dashboards to measure commercial organization performance.
Develop targeted customer lists and campaign reporting to enable and measure sales and marketing campaign ROI.
Generate analytical insights supporting and growing strategic vendor relationships.
Collect, organize, model, and operationalize data across multiple ERP and BI systems.
Support strategic planning, budgeting, and forecasting for the commercial business unit.
Synthesize findings into clear presentations and recommendations for senior leadership.

Requirements

What you’ll need

1–3+ years of analytical experience; investment banking, management consulting, equity research, FP&A, or corporate strategy backgrounds strongly preferred.
Advanced Microsoft Excel proficiency, including INDEX/MATCH, XLOOKUP, SUMIFS, nested logic, pivot tables, dynamic arrays, and large-dataset manipulation.
Working knowledge of relational databases and SQL or a comparable query language, including joining tables, writing aggregations, and reasoning about data models.
Comfortable operating with autonomy, ambiguity, minimal oversight, fast-paced conditions, and shifting priorities.
Ability to influence cross-functionally without direct authority.
Strong written, verbal, and presentation skills.
High attention to detail, intellectual curiosity, and results-oriented bias toward action.
Hands-on experience with business intelligence tools; Power BI preferred, with Tableau, Looker, or similar acceptable.
Exposure to Power Query (M), DAX, Python, or R.
Experience in distribution, B2B, or commercial/sales-driven environments.

Benefits

Comp & perks

Benefits that go beyond Mexican labor law, ensuring your well-being and peace of mind.
A collaborative and inclusive work environment where your contributions are valued.
Opportunities for continuous professional growth and skill development through training, mentoring, and challenging projects.
Access to cutting-edge tools, resources, and a supportive team to help you excel.
The chance to work with a global, innovative company shaping the future in its industry.