Data Warehouse Lead (CF1101)

Location: Calabasas, CA
Date Posted: 08-16-2018


Job Title: Data Warehouse Lead (CF1101)
Los Angeles, Ca.
Employment Type: FTE or Contract to Hire
Industry: Food & Hospitality

3Key Consulting Inc. is looking for a Data Warehouse Lead for a global Restaurants company.
Position Overview:
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.
  • 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.
  • 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.
Must have Skill Sets and Experience:
  • 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.
Interview Process:  Phone interview followed by on-site interview
We invite qualified candidates to send your resume to If you decide that you’re not interested in pursuing this position, please feel free to look at the other positions on our website You are welcome to also share this posting with anyone you think might be interested in applying for this role.
3KC Talent Acquisition Team
this job portal is powered by CATS