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. There are three key components to the program: 1. A standardized planning tool IBM Cognos TM1 2. A global data warehouse based on Azure Cloud know 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 Role Background: 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 build 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. Key Accountabilities: 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: o Ensure SPOT solution design & data model is up to date with latest business requirements o 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: o 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. We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) . To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ . Skills and Requirements - 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: o Interface data design documents defining what data is sent from source system to Azure o 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 dont 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 environment - Familiar with Data Factory - Financial background - Spanish speaking null We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.