Retail Data Engineer
TITLE: Retail Data Engineer
LOCATION: Atlanta, GA (hybrid, on-site 3 days/week)
Responsibilities:
- Works with business teams (e.g., Category Management, Marketing, Supply Chain) to define and refine data needs.
- Identifies gaps or ambiguities in retail scan data (e.g., barcode inconsistencies, vendor mappings).
- Translates complex retail requirements into technical specifications for data ingestion and transformation.
- Develops, schedules, and optimizes ETL/ELT processes to ingest large volumes of scan data (e.g., from POS, ERP, loyalty programs).
- Applies robust transformation logic to normalize data across vendors, stores, and systems.
- Works with both structured and semi-structured retail datasets (CSV, JSON, EDI, etc.).
- Implements data validation, reconciliation, and anomaly detection for incoming retail data feeds.
- Designs and maintains audit trails and data lineage for scan data.
- Investigates and resolves data discrepancies in collaboration with store systems, IT, and vendors.
- Conducts exploratory data analysis to uncover trends, seasonality, anomalies, and root causes.
- Supports retail performance reporting, promotional effectiveness, and vendor analytics.
- Provides clear documentation and logic traceability for analysts and business users.
- Collaborates with cross-functional teams such as merchandising, inventory, loyalty, and finance to support retail KPIs and data insights.
- Acts as a data subject matter expert for scan and transaction data.
- Provides guidance on best practices for data usage and transformation in retail contexts.
Requirements:
- Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or related field.
- 3–5 years of experience in data engineering, ideally in a retail environment.
- Experience working with scan-level data from large retail chains or CPG vendors.
- Familiarity with retail ERP systems (e.g., SAP, Oracle), merchandising tools, and vendor data feeds.
- Expert-level SQL and experience working with retail schema structures (e.g., SKUs, UPCs, store IDs).
- Proficient in data pipeline and orchestration tools such as dbt, Airflow, Fivetran, or Apache Spark.
- Experience with cloud-based data platforms (Snowflake, Google BigQuery, Azure Synapse, AWS Redshift).
- Familiarity with retail concepts such as POS systems, promotional pricing, markdowns, units vs. dollars sold, sell-through rates, and planogram compliance.
- Understanding of master data management (MDM) for products, stores, and vendors.
- Experience with data profiling and quality frameworks (e.g., Great Expectations, Soda, Monte Carlo).
The salary range for this position is $105,000 to $125,000/year (dependent on factors including but not limited to client requirements, experience, statutory considerations, and location). Benefits available to full-time employees: medical, dental, vision, disability, life insurance, 401k and commuter benefits.
Synergis is proud to be an Equal Opportunity Employer. We value diversity and do not discriminate on the basis of race, color, ethnicity, national origin, religion, age, gender, gender identity, political affiliation, sexual orientation, marital status, disability, military/veteran status, or any other status protected by applicable law.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with the requirements of applicable state and local laws, including but not limited to, the San Francisco Fair Chance Ordinance, the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act.
For immediate consideration, please forward your resume to dreeves@Synergishr.com.
If you require assistance or an accommodation in the application or employment process, please contact us at dreeves@Synergishr.com.
Synergis is a workforce solutions partner serving thousands of businesses and job seekers nationwide. Our digital world has accelerated the need for businesses to build IT ecosystems that enable growth and innovation along with enhancing the Total Experience (TX). Synergis partners with our clients at the intersection of talent and transformation to scale their balanced teams of tech, digital and creative professionals. Learn more about Synergis at www.synergishr.com.