Senior Data Warehouse Engineer

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 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 provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Created: 2026-03-04