We’ve remained true to Les Schwab's vision of World Class
Customer Service and unsurpassed benefits and opportunity to our
employees. Today, we have over 470 locations including Retail Tire
Stores, Distribution Centers, Production Operations, Transport,
Equipment Manufacturing, and Headquarters.
Amazing opportunity with one of the Nations’ Largest Tire
Retailers! We started in 1952 when Les Schwab bought one tire store
in Central Oregon. Since then, we have remained true to Les
Schwab's vision of World-class Customer Service and unsurpassed
benefits and opportunity to our employees. Today, we have over 400
locations including Retail Tire Stores, Distribution Center,
Production, Transport, Equipment, and Headquarters.
Reporting to the Business Intelligence Portfolio Manager, the
Lead Enterprise Data Architect sets the standards and architects
the data structures, processes and procedures for staging accurate,
timely, high quality data critical to the reporting, analytics and
data science functions, and for publishing data to downstream
systems and applications. This individual will be an expert
developer of efficient, secure, cloud-based data architecture and
possess expertise in crafting robust, practical data solutions
within a DEVOPS framework.
About the opportunity The incumbent leads a team of offshore and
onshore data engineers and administrators who build and operate Les
Schwab’s Enterprise Data Warehouse and Master Data Management
systems that serve the BI Portfolio and other downstream systems
Using an agile DEVOPS methodology, The incumbent will coordinate
with Business Intelligence solution developers, analysts and data
scientists and other external teams dependent on Enterprise Data to
set priorities for upcoming sprints and balance maintenance and new
In the longer horizon, the incumbent will set the strategy for
Enterprise Data Architecture and Data Management and will work with
Enterprise Architecture to develop complementary long term plans
This role is within the Information and Digital Services
organization at Les Schwab headquarters in Bend, OR.
Primary responsibilities/functions you are responsible for: 10%
of your time will be spent performing the following-
Responsible for the vision and best practice operations of
enterprise data warehouses and their integrative architectures to
support a variety of business solutions and use cases.
Select and implement appropriate technologies and methods to
automate data preparation and data movement with Les Schwab
standard data structures, tools, and platforms.
Implement and maintain business rules for mastered data in
enterprise data stores and develop future-proof mechanisms to
expose data to downstream users and applications.
60% of your time will be spent performing the following-
Platform Maintenance & Support
Collaborate with data analysts, business stakeholders, and
analytics practitioners to understand their requirements for staged
Collaborate with project teams and other enterprise architects
to understand requirements for staged and published enterprise
Set standards for integrating and maintaining the content and
quality of internal and external data sources.
Develop support methodologies for the delivery of ad hoc data
sets to business analysts, data analysts, data scientists, teams
developing proofs-of-concept, and other use cases.
Advise data engineers and lead the design of data models for
unstructured, relational and dimensional database schemas for a
range of use cases from targeted reporting solutions to support of
Manage the development and maintenance of physical database
tables, views, and flat files for analytics research projects,
reporting, and analytics applications.
Architect data transformation, preparation, and data movement
processes for a variety of scenarios from simple file-based
export/import to enterprise-grade ETL workflows connecting multiple
structured and unstructured endpoints.
Manage the development and quality assurance of complex SQL
scripts and queries in support of reporting and analytics
Work in an agile team environment to manage dependencies between
solution developers and the data warehouse platforms.
Develop processes to monitor and troubleshoot manual and
automated data preparation and data movement processes.
Collaborate with Information and Digital Services colleagues to
develop and socialize standards and best practices to promote a
culture of data management excellence.
Manage and catalog enterprise data and enterprise data
30% of your time will be spent performing the following-
Lead a team of direct and matrixed employee/contractor resources
including data engineers, quality engineers, solution
administrators and application specialists.
Provide mentoring and expert advice to empower Digital Services
colleagues to understand and utilize analytics data products,
services and resources.
Provide mentoring and expert advice for the development of
complex and high-performance SQL.
Manage and continuously improve data work flows and query
Create and maintain data dictionaries, data model diagrams, data
mapping documents, operational procedures and related documentation
to support efficient communications and reuse.
Own the design and implementation of security roles and
permissions that control access to Les Schwab’s Enterprise
Monitor, measure, and report the status of team members’
Operate the Data Warehouse Platform team as a dynamic learning
organization supportive of other teams.
Bachelor’s degree (BS or BA) in STEM related discipline or
10 or more years relevant professional experience, preferably
showing a progression from data engineering to data architecture,
team leadership, and responsibility for data warehouse
Experience working in a collaborative team environment to
deliver data services or application solutions; agile team
experience a plus
Required Technical Skills/Knowledge: A minimum 6 years
experience delivering data engineering, data modeling and data
A minimum 3 years experience performing advanced data
engineering and setting standards for quality and best practices in
data solution design
A minimum 2 years experience as the lead architect responsible
for data warehouse solutions and the end-to-end delivery process
from requirements development to business validation
Demonstrated professional experience leading teams of data
engineers, setting standards, policies, methodologies and quality
Advanced proficiency in and passion for SQL; multiple vendors a
plus; experience with Snowflake a plus
Advanced proficiency developing data movement, integration,
and/or ETL solutions with enterprise-grade platforms such as Boomi,
Birst, SSIS, Dataiku, Alteryx, or similar
Experience supporting, operating, and troubleshooting production
data movement, integration, and/or ETL processes
Strong understanding of logical and physical data modeling
theory and practice; ability to describe the characteristics and
applicable use cases for normalized vs dimensional designs
Demonstrated experience developing and implementing analytic
data models: reporting databases, data warehouses, data marts,
and/or data cubes; able to create and execute DDL scripts
Understanding and command of various data structure concepts
including traditional RDB, NoSQL, and unstructured data; experience
with geographic data (points, polygons, raster) a plus
Familiarity with reporting, business intelligence, and analytics
solution architectures; command of concepts and terminology; able
to relate data engineering deliverables to these use cases
Familiarity with data security and privacy issues and
accommodation of these issues in data warehouse design
Demonstrated professional experience writing and maintaining
data management documentation such as data dictionaries, data
models, and integration data maps; experience using tools such as
Proficiency and demonstrated professional experience working
with flat file data formats including delimited files, XML, and
Practical experience using solution delivery collaboration
software such as Service Now, Jira, TFS, or similar
General Knowledge and Abilities: Strong written, verbal, and
communication skills; able to relate complex technical concepts to
a business or semi-technical audience
Ability to communicate technical and non-technical information
clearly and professionally (both verbally and in writing) while
ensuring that the quality and content of the message are relevant
to the circumstances
Analytical and decision making skills with proven ability to
identify root causes and manage complex tasks
Ability to create and promote a culture in which service
excellence is expected for all levels of staff
Ability to establish, maintain, and encourage cooperative
working relationships by understanding and relating to other
Not ready to apply?
Join our Talent Network