Sr. Data Architect

Allied OneSource; 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

Build the data foundation that drives smarter business decisions! We're looking for a Senior Data Architect to lead enterprise data architecture, design scalable data warehouse solutions, and turn complex data into valuable business insights. This role is ideal for an experienced data professional who understands data warehousing, can implement star schemas, and knows how to design, optimize, and secure data environments across the enterprise.

Duties

• 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.

Requirements

• 8+ years of data architecture experience and 8+ years of hands-on SQL experience.
• Strong understanding of data warehousing, dimensional modeling, and the ability to design and implement star schemas.
• Experience designing OLTP and OLAP data structures, optimizing complex queries, and improving database performance.
• Experience with multiple database technologies, including SQL Server, MySQL, PostgreSQL, and AWS data services such as Redshift and Elasticsearch.
• Strong analytical, problem-solving, communication, and business partnership skills; a bachelor's degree in a related field or equivalent experience is required.

Salary

$120,000 - $150,000