- Own the daily, weekly and monthly reporting cycle across brands, channels and territories, delivering on time with reconciliations and explained movements.
- Help load data into the data warehouse by onboarding sources and connectors, checking feeds, and building transformation logic and reporting models.
- Validate data across commerce, ERP and analytics platforms; trace variances to root cause and resolve them with source-owning teams.
- Support system migrations by mapping data, testing transfers, reconciling parallel systems and maintaining reporting stability.
- Maintain accurate and consistent measurement and attribution logic from tracking and tagging through cost and revenue assignment.
- Maintain and extend self-serve reporting tools and provide first-line support for reporting issues.
- Document definitions, build automated validation checks and use AI tooling to automate reporting and reconciliation work.
- Participate in the recruitment process, including an in-person office interview and short task.
Requirements
- Experience in a reporting, data quality, BI or analytics role, ideally in beauty, retail, ecommerce or DTC.
- Strong Excel or Google Sheets skills, including pivot tables and complex formulas.
- Working SQL — comfortable querying a data warehouse to trace a number back to source, joining across tables to find where it broke, and writing the transformation logic on top.
- Some exposure to how data moves from a source system into a warehouse, including connectors, scheduled loads and layered models.
- Comfortable using AI day to day and keen to get better at it.
- Rigorous, with an instinct for when a figure looks off and the patience to trace why.
- Clear communication skills, including explaining data issues and commercial impact and following up with responsible stakeholders.
- Self-starter able to maintain a BAU reporting calendar while handling ad hoc investigations.
- Willingness to learn modern data warehouse and BI tooling; prior exposure is nice to have, not required.
Core Competencies
Demonstrates expertise in data reporting, validation, and analytics, with strong skills in SQL and Excel for data manipulation and transformation. Capable of maintaining reporting stability and accuracy while effectively communicating data issues and insights to stakeholders.
Highest-signal resume keywords
- SQL Querying
- Excel or Google Sheets Proficiency
- Data Validation
- Reporting Automation
- Data Warehouse Experience
Hard Skills
- SQL
- Excel
- Google Sheets
- Data Validation
- Reporting Models
- Data Transformation Logic
- Data Quality
- BI Tools
- Automated Validation Checks
- Data Reconciliation
Soft Skills
- Clear Communication
- Self-starter
- Attention to Detail
- Problem-Solving
- Patience
Industry Keywords
- Ecommerce
- Retail
- DTC
- Beauty
- Analytics
Tools & Technologies
- Data Warehouse
- AI Tooling
- Reporting Tools
- Commerce Platforms
- ERP Systems
#J-18808-Ljbffr
Data Analyst in Manchester employer: Jobtailor
As a Client Services Coordinator at our dynamic company, you will thrive in a supportive work culture that prioritises employee growth and development. We offer comprehensive training, opportunities for advancement, and a collaborative environment where your contributions are valued. Located in a vibrant area, our team enjoys a healthy work-life balance and the chance to engage with diverse clients, making every day rewarding and meaningful.
