OMNIA Partners · 15 hours ago
Senior Data Warehouse Engineer
Franklin, TN, USA
Full-time
Onsite
Senior Level, Lead/Staff
10+ years expOMNIA 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. As a Senior Data Warehouse Engineer, you will design, build, and maintain the enterprise data warehouse to enable strategic insights and business growth, working primarily with Snowflake, Azure, SQL Server, and PostgreSQL.
CommercialConsultingFinancial ServicesManagement ConsultingProfessional Services
No H1B
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
Qualification
Required
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
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
Company
OMNIA Partners
OMNIA Partners provide categories Consultation agency, financial service, and commercial and industrial equipment.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
unknownKey Investors
CapitalG
2025-09-15Private Equity
2021-01-01Acquired
2020-01-01Private Equity
Leadership Team
Amy Smith
Vice President, Lead Agency Partnerships
Barb Sexton
Vice President, Partner Development - Corporate Services
Recent News
2025-11-19
Company data provided by crunchbase