Senior Data Warehouse Engineer

Overview

Posted Tuesday, February 3, 2026 at 6:00 AM

OMNIA Partners has become the largest and most experienced purchasing organization for public and private sector markets by delivering unparalleled scale and solutions. Through further organic growth and strategic acquisitions, OMNIA Partners will continue to drive economies of scale to execute more contracts, in more verticals, with transparent, value-driven pricing for our membership of companies. Our success and growth have been unparalleled in this space.

At the core of our success is a high energy, talented staff with diverse skills and a unified focus on delivering value and an emphasis on creativity, strategic thinking, and execution.

Job Title: Sr. Data Warehouse Engineer
Location: Franklin, TN (Fully Onsite)
Reports to: VP, Data & IT Applications
Experience Level: 10+ years total experience | 7+ in Data Warehousing and ELT/ETL

About OMNIA Partners:

OMNIA Partners is the nation s largest and most experienced Group Purchasing Organization (GPO), delivering procurement solutions and cost savings to thousands of organizations in the Public and Private sectors. Our technology teams build scalable, resilient platforms that power B2B and B2C commerce, drive operational efficiency, and create value for our members and partners. Join us in advancing data-driven innovation that supports our mission to provide a better way to buy.

This is a fully onsite role based in our Franklin, TN office, no remote or hybrid options available.

Candidates must be legally authorized to work in the U.S. without sponsorship, now and in the future.

Qualified candidates are encouraged to apply by submitting a resume highlighting experience with Azure and Snowflake data ecosystems, data modeling, ELT processes, and cross-functional collaboration.

Position Summary:

As a Senior Data Warehouse Engineer, you will play a pivotal role in designing, building, and maintaining our enterprise data warehouse to enable strategic insights and business growth. Working primarily with Snowflake, Azure, SQL Server, and Postgre

SQL, you will develop robust ELT pipelines, evolve data models, and ensure high-quality, scalable data solutions.

This collaborative role involves partnering with technical teams, business analysts, and stakeholders in an Agile environment. You will manage multiple priorities, support mission-critical systems, troubleshoot issues, and contribute to improving our overall data culture and architecture.

Key Responsibilities:

• Design, develop, and maintain enterprise data warehousing systems, data marts, and ELT/ETL pipelines
• Evolve data models and schemas to meet evolving business and engineering needs
• Collaborate with business analysts and subject matter experts to gather requirements and deliver data sources, reporting, and analytics solutions
• Ensure code integrity, data quality, and adherence to architecture, development, and deployment standards
• Lead data quality initiatives, including cleanup, documentation, and issue resolution
• Troubleshoot production issues, perform root cause analysis, and resolve within established SLAs
• Extract, transform, and load data from diverse sources into our platform
• Conduct technical analysis for partner integrations and drive automation (e.g., RPA, master data management)
• Break down complex requirements into actionable components and features
• Communicate technical concepts to non-technical stakeholders and vice versa
• Mentor and lead daily tasks for data development team members
• Contribute to large-scale projects and perform additional duties as needed

Required Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related technical field
• 7+ years of experience in data warehouse design, development, data structures, and ELT/ETL processes
• 5+ years managing large-scale ELT systems (design, implementation, strategy, and maintenance)
• 5+ years building clean, maintainable, and well-tested code
• 2+ years working with data visualization tools (e.g., Tableau, Sigma) and integrating with data engineering assets
• Proficiency in T-SQL; experience with Alteryx or similar ETL tools
• Strong communication skills for collaborating with stakeholders…