Junior Data Engineer

TEKsystems; Kansas City (KS); Hybrid; USD 53,726,000 - 59,581,000; Full time

Benefits offered by this job

Medical, Dental, & Vision Insurance

401(k) with match

Tuition Reimbursement

Wellness Program

Paid Vacation, Holidays, Sick Time

Job summary

Associated Wholesale Grocers, Inc. (AWG) is seeking a Junior Data Engineer to join the Data Architecture, Engineering and Analytics team in Kansas City, KS.

This role supports migrating legacy data warehouse solutions to Databricks and Azure, building pipelines, and modernizing data platforms. The ideal candidate will have Databricks, Python, and Azure experience, strong communication, and a desire to grow in a high-performing data organization.

Qualifications

• 1–3 years of data engineering or related experience (Associate Analyst level).
• Basic understanding of data modelling, mapping and data quality/governance practices.
• SQL in SQL Server, Oracle, or DB2 environments.
• Cloud experience with AWS or Azure.
• Experience with columnar storage systems (Snowflake, Redshift, BigQuery).

Responsibilities

• Support Availability and Services (50-60%).
• Troubleshoot and develop solutions using AWG tools like Gemini, CoPilot, NotebookLM.
• Collaborate with developers and support engineers to resolve issues.
• Participate in on-call rotation for pipelines and legacy systems.
• Maintain documentation for legacy systems, jobs, pipelines, and modernization.
• Understand change control procedures (RFC, CAB, CI/CD).
• Build real-time and batch data integrations into the data lake/warehouse.
• Develop scalable ETL processes and provide technical design docs.
• Design dimensional models and cleanse/transform data.
• Scale and tune pipelines and SQL queries.
• Support unit, integration, and UAT testing.

Skills

Python

Azure

Databricks

Data engineering

Data architecture

Azure Data Lake

DB2 experience

Cloud migration

Data Governance

Business Analysis

Agile/Scrum

Reporting & Analytics

Education

Bachelor’s degree in CS/Engineering

Tools

SQL

Job description

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.

Data Engineer

Kansas City, KS, United States

Job Description

Data Engineer

Location: 5000 Kansas Avenue Kansas City, KS 66106

Department: IT

Make us your BEST Choice!

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.

Scope

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

Position Responsibilities

• 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.

Required Basic Skills

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.

Learning and Continuous Improvement

• 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.
• Participate in code reviews and receive feedback from the team.
• Propose process improvements for continuous department maturity.

Align Roadmap and Strategy

• Collaborate with business partners to understand their business problems or needs and desired outcomes.
• In collaboration with other members of the team and user community, configure cloud-based capabilities that enable the AWG community.
• Communicate priorities to the technology organization to drive effective business solutions.
• Maintain verbal and written issue identification and status updates to cross‑functional teams and leadership.

Position Requirements

• Experience: 1–3 years of data engineering or related experience (Associate Analyst level). Basic understanding of data modelling, mapping and data quality/governance practices.
• Education: Bachelors degree in software engineering, computer science, computer information systems, or related degree, or equivalent professional experience.
• SQL Skills: Must be able to read/write SQL in the following environments (SQL Server, Oracle, DB2).
• Cloud Experience: Experience working in cloud data environments (AWS, Azure). Experience working with AWS or Azure workflow orchestration tools.
• Data Systems: Experience working with one or more columnar storage systems (Snowflake, Redshift, BigQuery, etc.).
• Process: Must have completed at least one full cycle of building a data lake and/or a data warehouse.
• Analytical Skills: Knowledge and skills with Power BI will be important, not critical.
• Soft Skills: Strong business communications skills for requirements gathering and development. Ability to multi‑task and change priorities.

Nice To Have

• Worked with or built Data Lakes, Data Warehouse in a hybrid environment (cloud / on‑premises).
• Experience working with CRM systems like Salesforce.
• Experience with end‑to‑end supply chain or merchandising.
• Exposure to data streaming tools and technologies like Kafka, TensorFlow or similar.
• Basic knowledge and understanding of statistics and awareness of data science methodologies.

Associated Wholesale Grocers, Inc. (AWG) is the nations largest cooperative food wholesaler to independently owned supermarkets, serving 1,100 member companies and 3,500 locations throughout 33 states from 9 wholesale division support centers. Consolidated sales for AWG in 2024 were $12.1 billion. In addition to its cooperative wholesale operations, the company also operates subsidiary companies that provide certain real estate and supermarket development services, and pharmaceutical products. For more information, visit AWGinc.com.

Benefits

• Medical, Dental, & Vision Insurance
• Health Savings Account
• Dependent Care Flexible Spending Account
• Paid Vacation, Holiday, and Sick Time
• 401(k) with 4% match along with 3 other contributions
• Tuition Reimbursement
• Basic & Supplemental Life and AD&D
• Employee Assistance Program
• Short-Term and Long-Term Disability
• Wellness Program
• Yearly Holiday Bonus

Skills

• Python, Azure, databricks, data engineering, data architecture, azure data lake, data warehouse experience, DB2 experience, Cloud migration experience, Data Governance exposure, Business Analysis experience, Agile/Scrum collaboration, Reporting & Analytics exposure

Top Skills Details

• Python,Azure,databricks,data engineering,data architecture

Experience Level

• Entry LeveL

Job Type & Location

This is a Contract to Hire position based out of Kansas City, KS.

Pay And Benefits

The pay range for this position is $39.00 - $43.25/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre‑tax and Roth post‑tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long‑term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a hybrid position in Kansas City,KS.

Application Deadline

This position is anticipated to close on Oct 14, 2026.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records. Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.