Senior Data Warehouse Architect

Join our dynamic and innovative team and make a significant impact on our data infrastructure

Position: Senior Data Warehouse Architect

Location: San Francisco, California, United States

Type: Contract

Salary: $123 Per hour

Are you a seasoned Data Warehouse Architect with a strong background in designing and managing complex data warehouses? Do you have a passion for creating innovative solutions and driving data-driven decisions? If so, we have an exciting opportunity for you!

As a Senior Data Warehouse Architect, you will play a crucial role in our data infrastructure by designing and maintaining our data warehouse environment. You will work closely with cross-functional teams to identify business requirements, design scalable data models, and implement efficient data integration processes. You will also be responsible for ensuring the security, availability, and performance of our data warehouse.

Key Responsibilities:

• Design and implement data warehouse solutions that meet business needs and align with industry best practices
• Collaborate with business stakeholders to identify data requirements and translate them into technical specifications
• Develop and maintain data models, data dictionaries, and data flow diagrams
• Design and implement data integration processes using ETL tools and techniques
• Ensure data quality and integrity through data cleansing and validation processes
• Monitor and optimize data warehouse performance, including query optimization and data partitioning
• Implement data security measures to protect sensitive data
• Evaluate and recommend new technologies and tools to enhance the data warehouse environment
• Mentor and train junior team members on data warehousing concepts and best practices

Requirements:

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field
• Minimum of 8 years of experience in data warehousing and business intelligence
• Strong proficiency in SQL and experience with relational databases (e.g. SQL Server, Oracle)
• Hands-on experience with ETL tools such as Informatica, DataStage, or SSIS
• Extensive knowledge of data warehouse design principles, data modeling, and data integration techniques
• Experience with cloud-based data warehousing platforms (e.g. AWS Redshift, Google BigQuery) is a plus
• Excellent analytical and problem-solving skills with the ability to think critically and creatively
• Strong communication and interpersonal skills with the ability to work effectively in a team environment
• Proven track record of delivering complex data warehouse projects on time and within budget

Apply now and take your career to the next level!