About the role

  • Data Engineer supporting business intelligence, analytics, and data automation at Associated Wholesale Grocers. Involves building data ecosystem for new company-wide environment.

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.
  • Learning and Continuous Improvement (10-20%)
  • 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 (5%)
  • 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.

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: Bachelor’s 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.

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

Job title

Solution Engineer I

Job type

Experience level

Junior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job