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 PostgreSQL, 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 at all levels
• Team-oriented mindset with experience in Agile environments

Preferred Qualifications:

• Hands-on experience with Azure, Snowflake, and Salesforce
• Expertise in architecting, implementing, and supporting OLTP, OLAP, or data warehouse systems
• Knowledge of data quality principles, assurance practices, and their application in ELT architecture
• Background in data science, analytics, or data governance
• Familiarity with modern tools like Coalesce, dbt for transformations, Honeydew, Fivetran/Census, or other cloud automation tools

OMNIA Partners is an equal opportunity employer committed to fostering an inclusive and diverse workplace. We encourage applications from candidates of all backgrounds.