A Fortune 50 client is looking for a Data Analyst to come join their team as this client has a large project within their Corporate Sustainability Reporting Devices (CSRD) where their sustainability information is presented in different formats. This client is looking for a Data Analyst to work with their technical team members (Data Engineers, Data Stewards, and Data Governance teams) to help define the data flow from SAP/Oracle from source into gold layer within the Azure data environment.
You will be responsible for the artifacts and data flow diagram and laying out the flow from end to end in addition to supporting the testing of the data (i.e. creating test scripts, test cases, and bug fixes). This is NOT a data insights role - this position and project is focused on doing the pre-work for the Data Engineering team, identifying the bugs, and working closely with technical team members.
Majority of this data is finance, supply chain, and procurement related data so anyone who has experience in the CPG (Consumer Packaged Goods), F&B (Food & Beverage), or pharmaceuticals industry dealing with these data domains is highly preferred. This role can be remote; however, we are looking for someone in the Dallas/Fort Worth area who would be willing to go onsite to the client site in Plano 1-3 days a week.
Required Skills & Experience
6+ years of experience with data analysis, data profiling, or data modeling in project, business requirements definition with industry knowledge in either CPG, FMCG, F&B, Healthcare, or Manufacturing Any domain knowledge in Supply Chain, Finance, Commercial, or Metadata
6+ years of experience with SQL development, querying, performing complex joins, optimization, etc.
Strong Access and/or Excel skills
Data profiling experience - ability to identify trends, ad hoc analysis, and define data transformation and logic
Strong background in data testing - test scripts, test cases, identifying bugs, and fix bugs in datasets
Experience working with structured/unstructured datasets, ability to clearly document and communicate requirement to technical team members
Experience working with Data Steward and Data Governance team members
Strong ability to execute results while working in collaboration with global team members Bachelor's Degree
Nice to Have Skills & Experience
Any experience with Business Intelligence
Any experience in CPG background, broader F&B industry, or pharmaceuticals
Knowledge in financial, supply chain, or procurement data