Data Warehouse Specialist

We offer a competitive salary, comprehensive benefits package, and a dynamic work environment where you will have the opportunity to make a significant impact on our business

Job Title: Data Warehouse Specialist

Location: San Francisco, California, United States

Salary: $152000 - $192000

Overview: We are seeking a highly skilled and experienced Data Warehouse Specialist to join our dynamic team. As a Data Warehouse Specialist, you will be responsible for designing, developing, and maintaining our data warehouse infrastructure. You will work closely with cross-functional teams to ensure the accuracy, reliability, and availability of our data warehouse. The ideal candidate will have a strong background in data warehousing, data modeling, and ETL processes.

Key Responsibilities:

• Design and develop data warehouse infrastructure to support business intelligence and reporting needs.
• Collaborate with business stakeholders to gather requirements and translate them into technical specifications.
• Develop and maintain data models, ensuring data integrity and consistency.
• Design and implement ETL processes to extract, transform, and load data from various sources into the data warehouse.
• Monitor and optimize data warehouse performance.
• Troubleshoot data warehouse issues and provide timely resolutions.
• Work with cross-functional teams to ensure data accuracy and consistency across different systems.
• Develop and maintain data warehouse documentation, including data dictionaries, data flow diagrams, and process documentation.
• Stay up-to-date with the latest data warehousing technologies and trends, making recommendations for improvements and enhancements.
• Train and support end-users on data warehouse usage and capabilities.

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Minimum of 5 years of experience in data warehousing, data modeling, and ETL processes.
• Strong knowledge of SQL and data warehousing concepts.
• Experience with data warehouse design, data modeling, and dimensional modeling.
• Proficient in ETL tools such as Informatica, Talend, or DataStage.
• Experience with data visualization tools such as Tableau, Power BI, or QlikView.
• Familiarity with cloud-based data warehousing solutions such as AWS Redshift, Snowflake, or Google BigQuery.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Ability to work independently and in a team environment.
• Experience in Agile methodologies is a plus.

If you are a dedicated and passionate Data Warehouse Specialist looking for a new challenge, we would love to hear from you. Apply now and become a valuable member of our team!