Lead Data Engineer

Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which also includes five leading omnichannel grocery brands - Food Lion, Giant Food, The GIANT Company, Hannaford and Stop & Shop. Ahold Delhaize USA associates support the brands with a wide range of services, including Finance, Legal, Sustainability, Commercial, Digital and E-commerce, Technology and more.

Primary Purpose

The Lead Data Engineer will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. They will drive our data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They engage through the entire lifecycle of a project from data mapping, data pipelines, data modeling, and finally data consumption. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. They will proactively optimize or even assist with the design of our company's data architecture to support our next generation of products and data initiatives. They will work on various, ambiguous, and complex issues, where analysis of situations or data requires an in- depth evaluation of variable factors, thorough understanding of the business strategy, operations, markets and key stakeholders.

Our flexible / hybrid work schedule includes 3 in-person days at one of our core locations and 2 remote days. Our core office locations include Salisbury, NC , Chicago, IL, Quincy, MA, Carlisle, PA, Scarborough, ME, Hyattsville, MD and Mauldin, SC.

Applicants must be currently authorized to work in the United States on a full-time basis.

Duties and Responsibilities

• Solves complex application errors, designs, and resolves application problems, following up promptly with all appropriate customers and IT personnel.
• Validates QA test plans and supports QA team during test execution.
• Designs and develops data transformations and data pipelines.
• Ensures and signs off on change control and change management procedures are followed within the program / project as they relate to requirements.
• Designs and develops BI datasets for reports and dashboards to support decision-making within business and IT.
• Create requirement documents, create functional design documents, and review the functional design documents created by vendor partners as a part of software development life cycle.
• Documents all phases of work including gathering requirements, joining relationship diagrams, creating database diagrams, report layouts and other program technical specifications using current specified design standards for new or revised solutions.
• Relates information from various sources to draw logical conclusions.
• Conducts unit testing on ELT and report development.
• Conducts data lineage and impact analysis as a part of the change management process.
• Conducts data analysis (SQL, Excel, Data Discovery, etc.) on legacy systems and new data sources.
• Documents reporting requirements through engagement with business process SMEs.
• Creates and approves source to target data mappings for data pipelines and integration activities.
• Identifies and resolves the impact of proposed application development / enhancements projects.
• Performs data profiling and process analysis to understand key source systems and uses knowledge of application features and functions to assess scope and impact of business needs.
• Works with business users to design, develop, test, and implement business intelligence solutions in the Data & Analytics Platform.
• Assists in assessing alternative software solutions for workability and technical feasibility.
• Work closely with business teams in every stage from gathering requirements to closure of project.
• Work with the key stakeholders to create requirements for each business solution, ensure the requirements are developed in concert with and agreed upon by the business partner, and that the solution delivers the agreed upon business needs.
• Implement and maintain data governance policies and procedures to ensure data quality, security and compliance
• Initiates and leads workstreams for improving way of working in teams, eliminating technical debt and optimizing business processes
• Acts as a subject matter expert on technology solution
• Responsible for coaching / mentoring / leading junior engineers
• Consistently delivers very high-quality work in cross-functional environments - seen as an expert and technical leader among peers
• Has a balanced approach to team empowerment and leadership driving successful brainstorming sessions and solid technical conclusions to work approaches while modeling self-accountability, continuous development and team contributions
• Remain up to date on emerging technologies and best practices in data engineering. Recommend new approaches to improving data infrastructure

Qualifications

Preferred Qualifications

Salary Range : $142,000 - $220,440

LI-KK1 #LI-Hybrid

Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which also includes five leading omnichannel grocery brands - Food Lion, Giant Food, The GIANT Company, Hannaford and Stop & Shop. When considered together, the companies of Ahold Delhaize USA comprise the largest grocery retail group on the East Coast and the fourth largest grocery retail group in the nation, serving millions of omnichannel customers each week.

Salary : $142,000 - $220,440