Junior Data Engineer

Seeking a Junior Data Engineer to join the Data Architecture, Engineering and Analytics team. This role will support enterprise data engineering initiatives focused on migrating legacy data warehouse solutions into Databricks and Azure. The engineer will work with data architects and data engineers to build and maintain data pipelines, support data delivery projects, and contribute to the organization’s modernization efforts.

The ideal candidate will possess Databricks, Python, and Azure experience, strong communication and collaboration skills, and a desire to grow within a high-performing data organization. The individual will participate in multiple data engineering projects, support enterprise data-sharing initiatives, and assist with the transition from legacy DB2-based systems to a modern cloud data platform.

Kansas City, KS, United States

Data Engineer

Location:

5000 Kansas Avenue Kansas City, KS 66106

Department: IT

Associated Wholesale Grocers (AWG) is transforming our business intelligence, analytics, and data automation capabilities. The goal is to level up data warehousing and data management capabilities, including curated and cleansed data sets, certified data models and sources. We are adapting to cloud-based data automation for data cleansing, extraction, loading, transformations and visualizations. Another goal is to expand storage and compute capacity for ingestion of structured and unstructured data.

This role is a learning position that requires hands‑on review and supervision from leads, managers and occasionally Directors.

• Support Availability and Services (50‑60%)
• Troubleshoot and develop solutions to problems, including using AWG approved AI tools such as Gemini, CoPilot and NotebookLM.
• Collaborate with other developers and support engineers to resolve production, enhancement or development issues.
• Participate in an on‑call rotation for integration and transformation pipelines, legacy systems, and modern data platforms that may involve occasional off‑hours and weekend support.
• Take ownership of following on‑call procedures and instituting permanent fixes for repetitive problems.
• Maintain documentation for legacy systems, jobs, modern pipelines, and modernization implementation.
• Understand and implement change control procedures (including RFC, CAB, CI/CD).
• Deliver Solutions (25%)
• Build real‑time and batch data integrations from disparate source systems into the data lake/data warehouse/delta lake.
• Build and maintain scalable ETL processes using workflow automation tools.
• Provide documentation (including Technical Design Documents) for installations and deliverables.
• Design dimensional models and be able to cleanse and transform raw data into structured formats.
• Administer and maintain data pipelines used for loading data into the data warehouse or lakehouse.
• Scale and tune data pipelines, data sets, and SQL queries.
• Responsible for Unit testing, support of Integration testing, and User Acceptance Testing.

Develops timely and proper change documentation. Proactively communicates status to key stakeholders to diagnose and ensure delivery is on track. Takes ownership of assignments. Proactively drives results and seeks support when hitting barriers. Exhibits curiosity to understand how changes fit into the overall scope.

• Responsible for understanding and adoption of IT Architecture practice.
• Continuous learning of existing and future data technologies and tools.
• Apply standard methodologies to analyze, design, develop, test, and deploy data management solutions.
• Participate in agile story authoring, sizing, and demo sessions for developed features.
• Par…