The Cheesecake Factory Calabasas , CA 91302
You may know us as a company with great food. You may also know us from the 100 Best Companies to work for list. What you may not know is that we are a company driven by technology.
Reporting to the Senior Director of Business Intelligence and Integrations, the Data Warehouse Lead will be an integral member of our IT department at our Corporate Support Center in Calabasas, CA. They will partner with the Business Intelligence Team to understand functional and technical data warehouse requirements and deliver high quality, repeatable data driven solutions. They will primarily be responsible for design, data modeling and development of data warehouse processes, and day to day task management of a small team.
As a member of Business Intelligence and Integrations team, it is important that this person has the ability to collaborate effectively with business users, use project management skills while executing projects and leverage hands-on data warehouse experience to successfully manage data warehouse related activities.
Here's more of what you will get to do:
Responsible for the architecture and design of enterprise Data Warehouse processes while providing technical leadership for Data Warehouse implementation, with design and development standards.
Responsible for the prompt, courteous and efficient management of all support requests to the Data Warehouse team, including ad-hoc data analysis requests.
Designs and develops Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources.
Accountable for all aspects of the data warehouse processes including project management, data modeling, ETL, data validation and implementation.
Documents and maintains business definitions, data dictionary and data mapping.
Leads day to day tasks for a small data warehouse team.
Evaluates current data analysis strategies and works with team in developing recommendations and improvements.
Provides support to users in training and education on available data tools as required.
You'll thrive in this position if you are...
A people person: you enjoy working with others and you elevate the team through effective collaboration.
An expert in your field: you maintain a deep understanding and comprehensive knowledge base of Data Warehouse Design, Data Modeling, and Project Management.
A skilled communicator: you are readily able to pivot your communication efforts to the chosen channels, platforms and styles of everyone you encounter.
Bachelor's Degree or equivalent.
7+ years of experience in Information Technology with at least 5+ years in Data Warehouse applications.
5+ years of experience with the BI/DW lifecycle components including Source Data Analysis, ETL, ODS, Data Marts, Data Mining.
3+ years proven experience in managing and executing data warehouse initiatives along with providing project management/process support to IT teams.
3+ years of experience supervising staff.
Microsoft SQL Server Database, Integration Services, DBA Certification desired.
Expertise with ETL applications like SSIS, Informatica, Data Stage, etc.
Experience with Big Data technologies like HADOOP, HIVE, etc.
Experience in coding technologies like Python, Java, PHP, SQL.
Experience as a SQL Server DBA, as well as experience with Big Data technologies and Real-Time Integration methodologies is strongly preferred.
Significant experience with data modeling skills (conceptual, logical and physical model design, Operational Data Stores, Enterprise Data Warehouses and Data Marts).
Strong verbal and written communication skills, with an ability to express complex technical concepts into comprehensible business terminology.
Strong organizational and planning skills and process orientation.
Commitment to excellence in service, performance, and execution.
Ability to adapt quickly in a rapidly changing environment while effectively managing multiple projects and priorities simultaneously as well as produce high-quality end to end solutions for complex data problems.
This position offers industry-leading benefits including; medical, dental, vision, 401K with match, tuition reimbursement and a sabbatical after five years of employment for qualifying staff members.
Recognized as one of the FORTUNE "100 Best Companies to Work For", The Cheesecake Factory Incorporated operates more than 200 full-service, casual dining restaurants throughout the U.S. and Puerto Rico. Internationally, sixteen The Cheesecake Factory restaurants operate under licensing agreements. Continuing on our path to becoming a Global Iconic Brand, we employ more than 35,000 staff members, 320 of whom work at the corporate support center in Calabasas Hills, CA. #SoCheesecake #LifeAtCheesecake
The Cheesecake Factory Incorporated is an Equal Opportunity and E-Verify Employer and provides reasonable accommodations consistent with its legal obligations; we do not provide work visa sponsorship.