Data & Systems Analyst

The Opportunity

ESW has embarked on our biggest technical program of our history and are looking for someone to be at the core of the major transformation moving from monolith platforms to a modern, event-driven, micro-service architecture on the Microsoft Azure cloud (leveraging CosmosDB and JSON designed Events).

Data is at the center of our thinking and with this role comes a huge opportunity for someone that is looking to advance their data career. Someone that has experience understanding large, complex data platforms/models and is used to having to identify the right stakeholders to get an understanding of what feeds that data, what consumes it and is comfortable with a toolbox of how best to then document the data lineage, to support the future state of our architecture.

Working in our GCP focused data, but closely with Architecture, you will be able to write and understand complex T-SQL Statements (our monolith is a SQL Server platform). You will understand key concepts like: Data Modelling, Data Lineage and System Integrations (and impact of data). Ideally you will understand APIs (and be able to test them via Postman) to support understanding integrations in and out of our data platforms.

Critical to this role is the ability to show great consultative skills, dealing with senior and technical stakeholders whilst being used to working for large periods of time in analysis and design. The right candidate is dynamic, wants to progress their career (lots of opportunities to move to BI, Engineering or Architecture) and happy to roll their sleeves up to deliver the most important initiative ESW has ever embarked upon!

While frequent travel is not expected, there will be required visits to our sites in the US, Europe and Worldwide; mainly focused in Madrid, Dublin and New York.

Responsibilities

Data Lineage Analysis and Documentation

• Analyse and document the data lineage of monolith platform databases.
• Become the domain expert on how data is used, its origins, and its business linkage to key tables/fields.

Program Management Support

• Ensure program deliverables and deadlines are met.
• Identify and call out blockers, issues, and risks to the program team and line management.

Stakeholder Management

• Handle relationships with senior product, business, and technical collaborators.

Enterprise Data Expertise

• Develop a deep understanding of ESW enterprise data.
• Provide insights into the broader implications of data usage and migration.

Documentation and Reporting

• Produce high-quality documentation, such as data lineage reports, data models, and technical reports.
• Tailor deliverables to meet the expectations of specific stakeholders and program requirements.

Data Education and Advocacy

• Promote the importance of data quality, governance, and ownership, acting as a data advocate across the business.

Data Dependency Mapping

• Identify and map critical data dependencies across services, applications, and downstream systems.
• Ensure a smooth migration process with minimal disruption.

Data Quality Assurance

• Collaborate with QA teams to define benchmarks for data quality.
• Conduct validation checks to ensure data integrity before and after migration.

Cross-Functional Collaboration

• Bridge gaps between development, architecture, and business teams.

Change Impact Analysis

• Evaluate and document potential impacts of data migration on existing processes, tools, and reporting systems.
• Develop strategies to mitigate risks associated with these changes.

Event-Driven Data Design Support

• Partner with developers and architects to define event schemas.
• Ensure backward compatibility between legacy and modern systems.

Continuous Improvement

• Identify and recommend tools, techniques, and methodologies to enhance data analysis, modelling, and documentation processes.

Requirements

• Proficiency with SQL Server Profiler or equivalent and advanced T-SQL skills to query and interrogate complex databases effectively.
• Knowledge of ETL pipelines to understand current data flows.
• Familiarity with the basic concepts of event sourcing and stream processing.
• Basic skills with Postman for debugging, testing, and mocking API integrations
• Familiarity with tools like Power BI, Looker, or Azure Data Studio for creating accessible data models and lineage reports.
• Ability to generate visuals tailored to business stakeholders.
• Expertise in reading, understanding, and building JSON and AVRO data models.
• Basic knowledge of cloud data services, with an emphasis on Azure CosmosDB or similar services.
• Retail Industry Experience is a plus.
• Legacy System Migration Expertise is a plus.
• Communication Skills: Exceptional ability to translate technical insights into business-friendly language.
• Conflict Resolution: Skilled at navigating competing stakeholder priorities and driving consensus.
• Problem-Solving: Proactive approach to identifying and addressing blockers.

About ESW

Our purpose is simple: to create moments that matter between people and the brands they cherish. We enable brands to expand their global reach, facilitating simple and seamless ecommerce experiences for consumers worldwide. Through our integration solutions, we deliver a complete international checkout experience, including local duties, taxes, fulfilment, delivery management, and global returns and payment processing capabilities.

Guided by our values—Own It, Champion Simplicity, Win as One, and Debate then Commit—we strive to foster innovation, accountability, and teamwork, creating solutions that inspire trust and drive impactful results.

Why join us?

• Competitive salary and benefits: Your financial well being is important to us. Join ESW and experience the satisfaction of being rewarded for your hard work, dedication and commitment.
• Professional and personal development: Find your spark and leave your mark. We will ensure your talent is nurtured and cultivated for growth and success throughout your career with ESW.
• Hybrid Working: Our Hybrid Working Model empowers you to embrace the flexibility of hybrid working and enjoy the best of office and remote work.
• Diversity, Belonging & Inclusion: When we win, we win together. You'll be part of a culture that values every individual for who they are, fostering an environment where uniqueness is encouraged.

ESW is an equal opportunity employer, and we’re proud of our ongoing efforts to foster diversity, equity, & inclusion in the workplace. Individuals seeking employment and employees at ESW are considered without regard to race, color, religion, national origin, age, sex, gender, gender identity, gender expression, sexual orientation, marital status, medical condition, ancestry, disability, military or veteran status, or any other characteristic protected by applicable law.

If you require any reasonable accommodations or adjustments throughout the hiring process, please let us know. We are dedicated to ensuring equal access and opportunity for all candidates.

#LI-hybrid #LI-AL1