• Design, implement, and maintain enterprise data warehouse solutions following Data Vault 2.0 methodology • Develop and optimise Hubs, Links, Satellites, PIT, and Bridge tables • Lead conceptual, logical, and physical data modelling activities across multiple initiatives • Define and promote data architecture standards, modelling guidelines, naming conventions, and documentation practices • Ensure scalability, performance, reliability, and maintainability of data warehouse architectures • Provide technical leadership and architectural guidance to Data Engineers and development teams • Drive the standardisation and automation of ELT processes, metadata management, and deployment practices • Collaborate closely with Business Analysts, Product Owners, Data Governance teams, and other stakeholders to translate business requirements into robust data solutions • Support reporting and analytics teams by delivering optimised and business-ready data structures

• Designing and maintaining scalable database architectures for analytical workloads, ensuring optimal performance through indexing, partitioning, caching, and query tuning. • Developing, automating, and maintaining data ingestion, transformation, validation, and loading pipelines to support high-quality data flows. • Building reusable data connection modules and backend infrastructure components to streamline data operations and support future scalability. • Supporting data preprocessing, normalization, and rigorous data quality validation processes. • Contributing to cloud migration planning, governance, and evaluation of cloud solutions for security, compliance, interoperability, and performance. • Producing comprehensive data models, architecture diagrams, flowcharts, and technical documentation for internal and external stakeholders. • Utilizing PowerShell scripting and automation to enhance data engineering workflows and system integration. • Collaborating with technical, security, and stakeholder teams throughout the project lifecycle to deliver high-impact data solutions.

• Design the vision and blueprint of the organization's data framework to support public health informatics objectives. • Design and manage data systems, establishing policies for how data is stored, accessed, and governed. • Coordinate various data sources within the organization to ensure consistency and integrity across the data environment. • Integrate new data technologies into existing IT infrastructures. • Perform data modeling and design activities to support reporting, analytics, and operational needs. • Develop and maintain ETL pipelines to support data movement and transformation. • Write and optimize SQL queries in support of data operations and system requirements. • Administer database environments in coordination with application and infrastructure teams. • Submit weekly status reports detailing completed and ongoing project activities, including risks as applicable. • Maintain accurate records of work performed and hours expended in accordance with OTS Task Order requirements.

Title: Senior Data Engineer Location: - Wyoming, Michigan - Atlanta, Georgia time type Full time Job Description: Welcome to Gordon Food Service! We are excited that you are thinking about opportunities with us, and we have an amazing story to share. See below for a quick glance of who we are and the impact you could have on the food service industry. There's a seat at our table for you... Position Summary: The Senior Data Engineer guides the development of GFS' Data Platform consisting of the data lake, analytics, enterprise data sandboxes, and certified internal data products. Identifies and translates Big Data challenges into technical approaches yielding actionable recommendations across multiple, diverse domains. Helps define the team's technical design principles and has the tenacity to implement them. Guides the Data Engineering team in their collaboration with teams across IT as well as the organization. Contributes to the design and architecture of Data Engineering technical solutions in an agile and incremental manner. Empathizes with the challenges the business faces and helps develop a technical solution to address them. Is a leader in refining and following team processes to increase efficiency and capacity. Has extremely strong personal skills to develop relationships with and become a mentor to more junior developers. What you will do: - Provide expertise and guidance in defining the technical strategy and direction for the Data Platform environment at GFS, including tools, techniques, and processes. - Provide guidance to the scrum master and product owner to determine priority and effort for features. - Mentor to other team members in the appropriate use and application of new and existing tools and processes. - Design and build technology solutions across multiple initiatives at the same time. - Automate repetitive data engineering tasks and build proactive monitoring and alerting systems. - Collaborate with others inside and outside of IT to rapidly architect, design, prototype, and implement technical architectures to deliver insightful solutions. - Translate business analytics problems into technical solutions that yield actionable recommendations across multiple, diverse domains. - Document technical designs and systems thoroughly to ensure long-term sustainability and ease of knowledge transfer within the team - Help build a high-performing team focused on results and relationships within and outside of the team. - Perform other duties as assigned. When you will work: - Monday to Friday, 8am to 5pm - Hybrid schedule, 4 days in office in Wyoming MI or Atlanta GA, with 1 day remote What you will bring to the table: - Bachelor's degree in Computer Science, Information Technology, Advanced Analytics, Statistics, or related field required. - At least 8 years of experience in technical design, development, and delivery of data engineering technical solutions. - Highly experienced with cloud computing platforms, preferably Google Cloud Platform (GCP). - Deep experience with Change Data Capture (CDC) processes (Qlik Replicate preferred) and relational database management/optimization (specifically PostgreSQL and SQL Server). - Highly experienced in modern data movement technologies (e.g. serverless, real-time, as needed computing, low latency data movement, high volume data management, etc...). - Proven track record as a self-starter and quick learner with strong documentation skills, capable of taking ownership of existing systems. - Expert in modern devops practices to deliver code quickly with a high degree of confidence and quality - Business Influence - Ability to present and explain technical and complicated information in an easy to understand format, both verbally and in writing. - Highly experienced in understanding and developing complex data models - Knowledge of data governance, expectations and leading practices - Business Judgement: High degree of ingenuity, creativity, and innovation to solve unique and complex business challenges; evaluate alternative solutions, considering costs and benefits. - Preferred languages include but are not limited to Python, Terraform, SQL and Java. - Preferred tool experience include but not limited to Apache Airflow, Kafka, Qlik Replicate, PostgreSQL, SQL Server, Solarwinds DPA. - Experience working with the SAP data model. - Experience working with artificial intelligence / machine learning platforms and practices. BE PART OF AN AMAZING CULTURE WHERE WHAT MATTERS TO YOU, MATTERS TO US! Gordon Food Service values our customers and understands that their success is largely dependent upon their workforce. To demonstrate our commitment to our partnership, we will require any candidate who works for a Gordon Food Service customer to provide a letter of support from their management if they are selected for the interview process. Equal Employment Opportunity is a matter of policy at Gordon Food Service, Inc. and we are committed to a work environment in which all individuals are treated with respect and dignity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, status as a protected veteran, or status as a qualified individual with disability. If you require reasonable accommodation for any part of the application or hiring process due to a disability, please submit your request and use the words "Accommodation Request" in your subject line. All Gordon Food Service locations are tobacco-free. Gordon Food Service is a drug-free workplace and conducts pre-employment drug tests.