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


