We are hiring a Data Engineer Consultant to join one of our Fortune 500 leading CPG clients in support of a handful of projects and initiatives in the data modeling, architecture, and governance space. In this role, you will collaborate with Data Strategy & Governance teams across our client’s IT and Business teams to drive their vision of data-driven decision making. You will support centralized reporting and modeling efforts using SQL DBM and Excel in an Azure environment. You will participate in weekly TRD (Technical Requirements Document) reviews, collaborating closely with a lead architect and cross-functional teams. This role requires both technical and interpersonal skills, with a focus on initiative, adaptability, and the ability to work in agile environments.Minimum Qualifications:Strong knowledge and experience designing and architecting data engineering pipelines in a cloud environment, relational database management systems, data virtualization, data migration, data mining and data modeling solutions.Familiarity with star schema and snowflake schema and understanding when to use each.Basic understanding of data warehousing concepts such as fact tables vs. dimension tables.Strong communication and self-starter mindset; comfortable presenting and collaborating across teams.Familiarity with Azure DevOps, including use of boards and participation in daily scrums.Ability to write basic SQL for data profiling and test case development (not full-stack engineering).Self-motivated.Negotiation skills to align on the optimal architecture and design.Excellent written and verbal communication skills.Solid organizational skills including attention to detail and multitasking skills.Preferred Qualifications:Experience within Consumer-Packaged Goods industry.Knowledge of and experience with any ERP tools and systems e.g. SAP, APO, and reporting tools e.g. Azure, BW, etc.Primary Responsibilities:Define processes to effectively process, model and enable data assets consumption for analytics and reporting for users and applicationsCollaborate with Data Management Leads to ensure they follow data architecture and modeling standards,Perform data architecture and data modeling design reviews in partnership with IT to ensure the models are scalable and secure.Partner with Data Governance program and IT to ensure data assets are properly architected by design and in compliance with Data Governance and Stewardship requirements.Define and maintain strategic roadmap for data architecture technical capabilities, processes, and competencies for enabling Data Fabric scale.Create, publish, and maintain the master version of data models in system of record.Maintain a repository of all data architecture procedures and artifactsAuditing data assets regularly to maintain integrity of data models quality.Partner with IT to develop data architecture standards, and guidelines for processing and persisting data on prim and cloudApply sampling techniques to effectively determine and define data categorization and leverage automation to ensure data architecture attributes properly maintain in Data Catalog and Data Architecture systems of record.
#J-18808-Ljbffr