ECommerce Data Engineer

The eCommerce Data Engineer will build, maintain and improve the critical data flows from internal and external sources supporting AD’s eContent Service. The eCommerce Data Engineer provides technical expertise and leadership on design, and integration of multiple datasets into and out of AD eCommerce’s evolving and large-scale data environment. Emphasis of this position will be in developing and deploying efficient, scalable processes in a service-oriented ecosystem leveraging powerful code frameworks and repeatable patterns to solve real problems for the eCommerce team, members and suppliers.

This position will work closely with AD members, suppliers, service providers & the eCommerce team to deliver increased value by making data exchanges consistent, standard, and reliable, enabling members and suppliers to scale faster. This requires a combination of customer facing skills and the ability to communicate technical information in a clear and concise manner. This role will serve as a trusted advisor to participating members and suppliers, helping to foster commitment while managing resources in the process of ensuring complete and accurate product data is delivered on a timely basis.

Primary Responsibilities:

• Responsible for designing, solutioning, and maintaining product data integrations at scale
• Delivers project tasks within the allotted project plan (time and budget)
• Leads documentation and writing technical specifications as well as testing and training once deployed
• Manages data ingestion, batch processing, data extraction, transformation, and loading of data into a variety of cloud data platforms according to defined business rules and procedures
• Works as a technical expert with service providers, and AD eCommerce team members to identify gaps and develop solution improvements yielding better eContent quality, robustness, maintainability, and speed
• Assists in the development of technology roadmaps
• Evaluates new and upcoming big data solutions and makes recommendations for adoption to extend our platform to meet advanced product use cases
• Daily monitoring of data load processes to identify holes in data, collaborate with other team members in various functions to design and implement improvement approaches
• Partner with others to ensure effectiveness of data collection processes

• Technical competency: High proficiency with web technologies: SQL, REST, JSON & XML. Fluency in common query languages, API development, data transformation, and integration of data streams. Willingness to read the documentation and test it until it works. Proficient with reading and interpreting technical information.
• Problem-Solving Mentality: Gets excited about digging into complexity, wants to ask questions and learn more, and isn’t put off by problems they’ve never been explicitly told how to solve. Enjoys trouble shooting, ability to break down a chain of steps to narrow and locate a problem.
• Collaboration: Works well in a team environment. Excellent written and oral communication skills. Explains benefits of a technical product / solution internally and/or externally in relation to the business needs. Ability to work interdependently and to manage multiple projects concurrently.
• Big-picture awareness: Understanding of the importance of context, and willingness to understand the business problem in addition to the technical one. Focus on people & impact.

Qualifications:

• Bachelor’s Degree in Computer science, system engineering, management information system with 2 to 5 years of experience OR 4+ years of experience in a related field in a Data Engineering role
• Experience working with Product Information Management (PIM), Multi-Domain Master Data Management (MDM) and/or Digital Asset Management (DAM).
• Experience building, maintaining, and improving Data Processing Pipeline / Data routing in large scale environments, particularly using SQL and database procedure language
• Have a demonstrated passion for data and working in data-driven organizations.
• Have exposure to one or more Business Intelligent (BI), data analytics, data preparation and/or data visualization tools
• Creativity to go beyond current tools to deliver the best solution to the problem
• Experience with data flow monitoring, batching, and streaming

Other:

Position is based in Wayne, PA

Up to 20% travel