Sr. Data Architect
Allied OneSource ·www.alliedonesource.com
Apply directBuild 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
Frequently asked questions
Who is hiring for the Sr. Data Architect role?
Allied OneSource is hiring for the Sr. Data Architect position, a Shazamme client. Apply directly on the employer's career site.
Where is the Sr. Data Architect job located?
The Sr. Data Architect role with Allied OneSource is based in Kansas City, MO, US.
Is the Sr. Data Architect role full-time or contract?
This is a full time position at Allied OneSource.
What experience level is the Sr. Data Architect role?
The Sr. Data Architect position is aimed at senior-level candidates.
How do I apply for the Sr. Data Architect role at Allied OneSource?
Apply directly on Allied OneSource's career page via the Apply button on this listing. ZammeJobs links straight through to the employer's ATS — no third-party form, no resume database.