Senior Data Architect - Enterprise Data Warehouse Leader

Allied OneSource, LLC.; Kansas City (MO); On-site; USD 120,000 - 150,000; Full time

Job summary

Allied OneSource, LLC. in Kansas City, MO, is seeking a Senior Data Architect to lead enterprise data architecture, design scalable data warehouse solutions, and turn complex data into valuable business insights.

You will implement star schemas, optimize SQL queries, and establish governance and security controls across the data estate, partnering with IT and business stakeholders to improve data integration and reporting.

Qualifications

• 8+ years of data architecture experience.
• Strong knowledge of data warehousing and star schemas.
• Experience with OLTP/OLAP data structures.
• Experience with multiple DB technologies incl SQL Server, MySQL, PostgreSQL, AWS Redshift, Elasticsearch.
• Bachelor's degree or equivalent required.

Responsibilities

• Design and maintain conceptual, logical, and physical data models, including star schemas for data warehousing and reporting.
• Lead database architecture, data warehouse design, and end-to-end data lifecycle management.
• Optimize SQL queries, database performance, scalability, and data accessibility across complex environments.
• Establish data architecture standards, governance practices, and security and compliance controls.
• Partner with IT teams and business stakeholders to improve data integration, quality, storage, and reporting capabilities.

Skills

Data warehousing

Star schema design

SQL optimization

Data modeling

Stakeholder collaboration

Education

Bachelor's degree in related field or equivalent

Tools

SQL Server

MySQL

PostgreSQL

AWS Redshift

Elasticsearch

Job description

Allied OneSource, LLC. in Kansas City, MO, is seeking a Senior Data Architect to lead enterprise data architecture, design scalable data warehouse solutions, and turn complex data into valuable business insights.

You will implement star schemas, optimize SQL queries, and establish governance and security controls across the data estate, partnering with IT and business stakeholders to improve data integration and reporting.