Data Warehouse Lead Architect

If you have a passion for data and a proven track record of designing and implementing efficient and scalable data warehouse solutions, then we want to hear from you! Join our team as a Data Warehouse Lead Architect and make a significant impact on our organization's data-driven decision-making capabilities.

Position: Data Warehouse Lead Architect

Location: San Francisco, California, United States

Salary: $285000 - $352000

Overview: We are seeking a highly experienced and skilled Data Warehouse Lead Architect to join our dynamic team. As the Data Warehouse Lead Architect, you will play a crucial role in designing, developing, and maintaining our data warehouse systems. You will use your expertise to drive the data architecture, strategy, and governance for our organization. This is a leadership position, and you will be responsible for managing a team of data engineers and analysts, as well as collaborating with other cross-functional teams to ensure the success of our data warehouse initiatives.

Key Responsibilities:

• Collaborate with business stakeholders, data scientists, and other teams to understand their data and reporting needs, and translate them into technical requirements for the data warehouse
• Design and implement data warehouse solutions, including data models, ETL processes, and data cubes, that meet the business requirements and align with industry best practices
• Lead the development and maintenance of our data warehouse infrastructure, ensuring its scalability, reliability, and performance
• Define and enforce data warehouse standards, policies, and procedures to ensure data quality, consistency, and security
• Manage a team of data engineers and analysts, providing guidance, mentoring, and technical leadership to ensure the delivery of high-quality, timely, and cost-effective solutions
• Act as the subject matter expert on data warehouse technologies and trends, and provide recommendations for new tools and techniques to improve our data warehouse capabilities
• Collaborate with cross-functional teams to understand their data needs and facilitate the integration of data from different sources into the data warehouse
• Proactively monitor and troubleshoot data warehouse performance, identifying and resolving issues to ensure the availability and accuracy of data
• Develop and maintain documentation, including data dictionaries, ETL processes, and data lineage, to facilitate data governance and understanding of the data warehouse

Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field
• Minimum of 8 years of experience in data warehousing, data modeling, and ETL development, with at least 3 years in a leadership role
• Strong knowledge of data warehouse concepts, methodologies, and tools, such as Kimball, Inmon, Snowflake, and Informatica
• Experience with cloud-based data warehousing solutions, such as AWS Redshift or Google BigQuery
• Proficiency in SQL, and experience with data visualization tools, such as Tableau or Power BI
• Strong leadership and people management skills, with the ability to mentor and motivate team members to achieve their full potential
• Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams
• Proven track record of delivering successful data warehouse solutions on time and within budget
• Strong analytical, problem-solving, and critical thinking skills, with a keen attention to detail
• Knowledge of data governance principles and best practices
• Familiarity with agile methodologies and project management tools, such as JIRA or Trello, is a plus