Data Integrations Lead

URM Stores Inc.; Washington; On-site; USD 115,000 - 120,000; Full time

Benefits offered by this job

Health Insurance

401k match up to 9%

Life Insurance

Short-Term Disability

Paid vacation

Paid holidays

Volunteer day

Employee discount program

Job summary

URM Stores, Inc. seeks a Data Integrations Lead to be the senior hands-on technical leader for URM’s enterprise integrations.

You will design, build, review, and support complex integrations across applications, data platforms, trading partners, messaging platforms, and cloud services. This role provides technical direction for Boomi, EDI, Pub/Sub models, Azure Integration Services, Logic Apps, message bus patterns, DB2, Snowflake, dbt, Python, and Prefect while mentoring integration developers

Qualifications

• Five or more years in enterprise integration or data engineering.
• Advanced hands-on experience with Boomi or equivalent platforms.
• Strong experience with Azure Integration Services and API-based integration.
• EDI experience including transaction processing and partner onboarding.
• Knowledge of Publish/Subscribe models and event-driven architectures.
• SQL/database integration with DB2, Snowflake or similar.
• Python for automation and data pipelines; ability to document clearly.

Responsibilities

• Lead design, build, testing, deployment, and support of complex integrations.
• Define reusable patterns for Boomi, Logic Apps, APIs, EDI, and data flows.
• Review designs for security, performance, and observability.
• Mentor integration developers and act as escalation point for incidents.
• Create runbooks, data mappings, and documentation.
• Collaborate with analysts, data teams, vendors, and architecture.

Skills

Data integration

Team leadership

API development

SQL / DB2

Python

DevOps mindset

Tools

Boomi

Azure Integration Services

Azure Logic Apps

EDI tools

Prefect

dbt

Snowflake

Job description

URM Stores, Inc

is looking for a Data Integrations Lead, to be the senior hands‑on technical leader for URM’s enterprise integrations. This role designs, builds, reviews, and supports complex integrations across applications, data platforms, trading partners, messaging platforms, and cloud services. The role provides technical direction for Boomi, EDI, Pub/Sub models, Azure Integration Services, Logic Apps, message bus patterns, DB2, Snowflake, dbt, Python, and Prefect while mentoring integration developers and improving operational reliability.

Technical Leadership

• Lead design, build, testing, deployment, and support of complex integrations across enterprise systems and platforms.
• Define reusable technical patterns for Boomi, Logic Apps, APIs, EDI, files, databases, Pub/Sub events, message bus processing, error handling, logging, monitoring, and retries.
• Review integration design and code for security, performance, maintainability, observability, and alignment with architecture standards.
• Serve as escalation point for complex integration defects, production incidents, performance issues, and root‑cause analysis.

Platform Engineering

• Build and support integrations using Boomi, Azure Integration Services, Azure Logic Apps, message bus services, APIs, SQL, EDI tools, Python, Prefect, and event‑driven services.
• Create reusable templates, deployment patterns, runbooks, test plans, data mappings, and documentation for integration delivery.
• Improve monitoring and alerting to detect failures, data quality issues, latency, retries, and downstream impact.
• Support integration patterns that feed Snowflake, DB2, enterprise applications, vendor systems, and business processes.

Collaboration and Mentorship

• Partner with analysts, application owners, data teams, vendors, and architecture resources to clarify requirements and technical constraints.
• Translate business integration needs into technical specifications, data mappings, interface contracts, and support procedures.
• Mentor integration developers through design reviews, peer reviews, troubleshooting, documentation, and knowledge transfer.
• Identify opportunities to simplify, standardize, automate, or modernize existing integrations.

Required Qualifications

• Five or more years of hands‑on experience in enterprise integration, data integration, EDI, API development, data engineering, or related technical roles.
• Advanced hands‑on experience with Boomi or comparable integration platforms.
• Strong experience with Azure Integration Services, Azure Logic Apps, message bus approaches, and API‑based integration.
• Strong EDI experience includes transaction processing, mappings, partner onboarding, and troubleshooting.
• Strong understanding of Publish/Subscribe models, event‑driven systems, queues, message bus architecture, retries, and asynchronous processing.
• Strong SQL and database integration experience with DB2, Snowflake, or comparable platforms.
• Strong Python skills and experience with automation, orchestration, Prefect, dbt concepts, or data pipeline workflows.
• Ability to create clear technical documentation, runbooks, data mappings, and support procedures.

Preferred Qualifications

• Experience with Azure Service Bus, Event Grid, Functions, API Management, Storage, Key Vault, or related Azure services.
• Experience with IBM i/AS400, DB2 for i, Snowflake, ERP, WMS, POS, vendor, or retail distribution integrations.
• Experience with integration testing, DevOps practices, source control, CI/CD, and automated deployment patterns.
• Experience mentoring developers or acting as a technical lead.
• Experience applying AI‑assisted development to improve integration design, code generation, testing, and documentation.

A Legacy of Local Impact Since 1921

For over a century, URM Stores, Inc. has been the powerhouse behind independent grocers throughout the Inland Northwest. Our mission is simple: help local grocers thrive by handling everything from purchasing and warehousing to the timely delivery of top-quality merchandise.

What makes us unique? Our co‑operative model means our Member‑Owners aren’t just customers, they’re shareholders. We reinvest in their success by returning earnings to our Co‑Op members as patronage dividends.

Today, URM employs more than 3,000 dedicated team members, including those at our subsidiaries Rosauers Supermarkets and Peirone Produce.

We work in a supportive team environment and in addition to our amazing culture, our employees enjoy many perks, and below are a few of the highlights of our complete compensation package:

• An employee’s pay position within the salary range will be based on several factors including, the prevailing minimum wage for the location, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, and business or organizational needs. Salary range $115,000 - $120,000 annually DOE, plus so much more!
• Insurance Benefits – So that our non-union employees have more to take home from their paycheck, URM pays 100% of the Medical/Dental/Vision/RX Insurance premiums for the employee and over 93% for the employee’s dependents!
• 401k Retirement Plan with an amazing Company match up to 9% of your annual salary!
• Subsidized Life Insurance for employees and great rates for the employee’s family.
• Company paid Long‑Term Disability insurance.
• Short‑Term Disability and Cancer Insurance available.
• Life Flight Insurance at Special Rate.
• Great vacation plan!
• Six Paid Holidays and four Paid Personal Holidays.
• Paid Sick Days.
• Paid Volunteer Service Day! Get paid to volunteer at your favorite non‑profit!
• Experience enjoyable Company sponsored activities through events like URM March Madness Brackets, Family Hockey Night with the Chiefs, Holiday Mingle & Jingle with great raffle giveaways, Summer Evening Wine & Music Event, and Winter Break Movie Night, which are just a glimpse of the fun we have to offer for employees and their families!
• Plus, enjoy a variety of corporate discounts, from gym memberships, cell phone plans, to computer discounts!
• We also offer an Amazing Employee Discount Program at our Company‑owned Grocery Stores!!!!

Equal Opportunity Employer

URM Stores, Inc. is proud to be an equal opportunity employer, fostering an inclusive workplace where all employees can thrive. We prohibit discrimination of any kind and are committed to a work environment built on respect, inclusion, and opportunity for all.

We are dedicated to maintaining a work environment free from discrimination in all aspects of employment, including recruitment, hiring, training, promotions, compensation, and workplace practices.

Please note: All selected candidates must successfully pass a pre‑employment drug screening, as URM maintains a drug‑free workplace.