Junior Data Analyst

Marketing Castro is an independent agency with 550 employees in offices across Mexico. Creative, strategy, media and analytics staff work together in dedicated account groups.

The position:

Our team is growing and we are hiring a Junior Data Analyst. We want an analyst who is comfortable pushing back when the numbers don't support the conclusion. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. Remote, open to candidates across Mexico. Most of our work is async, and meetings are kept short.

Duties:

• Present results to managers and answer follow-up questions
• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Investigate data quality issues and work with data engineering to fix them at the source
• Track sales, inventory or service levels against targets and flag misses early
• Field ad hoc requests through a ticket queue and prioritise them with your manager
• Prepare weekly and monthly KPI reports for department leads
• Build and maintain dashboards in Tableau, Power BI or Looker

What you need:

• 1+ years of experience in a data or reporting analyst role
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Clear written and verbal communication with non-technical stakeholders
• Bachelor's degree in statistics, economics, business, math or a related field
• Experience with at least one BI tool such as Tableau, Power BI or Looker
• Able to juggle several requests and say when a deadline isn't realistic
• Strong SQL (joins, CTEs, aggregations, window functions)

Pay and benefits:

• Private health insurance
• Annual bonus
• Life insurance
• Savings fund
• Meal vouchers

Only shortlisted candidates will be contacted.

We are reviewing applications as they arrive, so apply early.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Marketing Castro.