Data Warehouse Consultant

If you have a passion for data warehousing and a desire to continuously improve and innovate, we would love to hear from you

Position: Data Warehouse Consultant

Location: San Francisco, California, United States

Employment Type: Full-time

Salary: $171000 - $208000

Experience: 2-5 years

Industry: Information Technology & Services

Job Function: Information Technology

About the Role: We are seeking a highly skilled and experienced Data Warehouse Consultant to join our dynamic team. As a Data Warehouse Consultant, you will be responsible for designing, developing, and maintaining our data warehouse infrastructure. You will work closely with our clients to understand their data requirements and provide them with efficient and effective solutions to store, manage, and analyze their data.

Key Responsibilities:

• Design and develop data warehouse solutions that meet business requirements and ensure data integrity and accuracy.
• Collaborate with clients to gather and analyze their data needs and provide them with appropriate data warehouse solutions.
• Build and maintain data warehouse processes, including data extraction, transformation, and loading (ETL) processes.
• Create and maintain technical documentation for data warehouse processes, data models, and data dictionaries.
• Monitor and troubleshoot data warehouse performance and resolve any issues or errors that arise.
• Develop and implement data quality checks to ensure data accuracy and consistency.
• Stay up-to-date with industry trends and advancements in data warehousing technologies and make recommendations for improvement.
• Train and mentor junior team members on data warehousing concepts and best practices.
• Collaborate with cross-functional teams to integrate data warehouse solutions with other business systems and applications.
• Participate in data warehouse testing and provide support during user acceptance testing (UAT).
• Ensure compliance with data security and privacy policies and regulations.

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Minimum of 5 years of experience in data warehousing, specifically in design, development, and maintenance.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling.
• Proficient in SQL and experience with data warehousing tools such as Microsoft SQL Server, Oracle, or Teradata.
• Experience with data visualization tools such as Tableau or Power BI.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills to effectively collaborate with clients and cross-functional teams.
• Proven ability to work in a fast-paced environment and manage multiple projects simultaneously.
• Knowledge of data security and privacy regulations.
• Certification in data warehousing or related field is a plus.

Joining our team as a Data Warehouse Consultant will provide you with an opportunity to work on diverse projects with a team of talented professionals. We offer a competitive salary and benefits package, along with opportunities for career growth and advancement.

Apply now and be a part of our growing team!