Data Analyst - INTL - India

Job Description Project Background

Mosaic is our financial planning and reporting transformation program, bringing an aligned business process and toolset to all key business units enabling us to get consistent and standardized financial metrics across geographies. Started in 2019 the program is already rolled out to Europe and most of North America and continues across the world.

• 1. A standardized planning tool – IBM Cognos TM1
• 2. A global data warehouse based on Azure Cloud known as ‘SPOT’ (single point of truth). The SPOT team is made up of functional data analysts & data engineers
• 3. An extensive suite of dashboards known as ‘Cockpit’ using Tableau. The Cockpit team are generally finance analysts with Tableau skills

We are looking for an additional functional/data analyst to join the existing team of functional/data analysts working on the SPOT data warehouse.

The role of the functional/data analyst is to be the bridge between the Cockpit team, Data Engineering team, and Cognos TM1 team. The analyst understands the business data requirements and translates these into data definition and data transformation documents that are then built by the data engineers. The analyst can also be involved in testing, data validation and any sustain activity related to the flow and accuracy of the data in SPOT & Cockpit.

Typically, the functional data analyst receives requirements for new and/or amended data pipelines from the Cockpit team or works with the Cognos TM1 team on new data sets that need to flow to SPOT & Cockpit.

The current functional data analysts come from a range of backgrounds from data engineers to business analysts. What unites the team is a passion for data, attention to detail, ability to navigate and understand complex data flows, and a customer‑centric mindset. This is a high profile and at times high pressure transformation program and everyone on the team must be responsive to our stakeholders needs.

This role will primarily work with the North America Cockpit team primarily based in Mexico City, but as part of the team they will be expected to build a good knowledge of all data pipelines and work on any area as needed. The key elements of the role are:

• Develop and maintain SPOT solution design & data architecture:
  • Ensure SPOT solution design & data model is up to date with latest business requirements
  • Contribute to the delivery of current technical roadmap that can support the predicted growth in data volumes
• Translate and communicate business requirements across all IT delivery teams and/or partners:
  • Collaborate closely with SPOT Cockpit teams to ensure business requirements received from Global & Regional Planning teams are well‑understood and translated into the SPOT solution design (functional & data model)
• Act as an owner in the diagnosis and resolution of any data issues raised with the team, partnering with other teams as needed.

• Confident using SQL to explore, investigate & understand data in a structured database. Current technologies are:
  Databricks, Synapse, DBSQL
• Capable of reading and understanding SQL data transformation scripts
• Experience translating business requirements into technical requirements for the data engineering team, including the creation of:
  • Interface data design documents – defining what data is sent from source system to Azure
  • Source to target mapping documents – that define the movement, enrichment and transformation of data from source ingestion to aggregated reporting layer
• Familiarity with financial data would be beneficial to understand the finance terminology – but you don’t need to be an accountant!
• Love for data and problem solving – demanding sharp analytical skills to handle/evaluate large amount of data (strong attention to details) – experience/appetitive in the leverage/exploitation/development of systems
• Good communicator and a good people person given the need to collaborate effectively across teams and people of diverse backgrounds
• Ability to operate autonomously and proactively, managing multiple deliverables at a single time in a fast‑paced, results‑oriented…