Top Benefits
About the role
Senior Cloud Warehouse Designer
Are you passionate about data warehouse design and development?
This role encompasses both hands-on data modeling and the architectural guidance necessary to develop robust data warehouse solutions. You will be instrumental in designing data structures that support efficient data storage, retrieval, and analysis for business intelligence, ultimately empowering data-driven decisions across the organization. A key responsibility will be the efficient design and development of our cloud data warehouse.
We practice a remote first working model, leveraging in person interactions at our head office, in beautiful Vancouver, BC, for strategic, collaborative and social purposes.
Join our team as the senior cloud warehouse designer.
What you’ll do:
- Design and develop scalable and flexible conceptual, logical, and physical data models optimized for data warehousing on cloud platforms.
- Lead technical discussions on data modeling and data warehouse architecture, contributing to key architectural decisions.
- Design and implement end-to-end data warehouse architectures that align with business objectives and data requirements.
- Optimize data models and database designs for performance, ensuring efficient data processing and querying within the data warehousing environment.
- Collaborate closely with cross-functional teams, including business analysts, data architects, and data engineers, to understand and translate business needs into effective data warehousing solutions.
- Take ownership of the design and development of our cloud data warehouse, ensuring its efficiency and scalability.
- Develop and maintain essential documentation, including playbooks, business rules, data dictionaries, and data lineage models.
What we need:
- 5+ years of experience as a data warehouse designer utilizing platforms such as Snowflake or Azure Synapse.
- Demonstrated expert knowledge in data mapping, data transformation processes, and SQL, with a proven ability to implement physical and relational data models for data warehouse solutions.
- Proficiency in industry-standard data modeling tools and techniques (e.g. SAP power designer, ER/studio, erwin, UML, dimensional modeling, etc.).
- Practical experience with metadata management concepts and related tools.
- Expert-level understanding and experience with a modern data technology stack, such as microsoft azure (azure data lake storage, azure data factory, azure streams, databricks).
Why you’ll love it here:
- Remote-first work environment.
- Employee discounts on awesome tech from day one.
- Flexible health benefits and wellness program.
- TFSA and RRSP programs.
- 100% matched company pension plan.
- Training programs to build new and transferable skills.
About Best Buy
As Canada's destination for the coolest tech, Best Buy offers one of the best work environments in the country! Our culture is one of inclusivity and belonging and provides employees an environment where they can bring their whole selves to work.
We believe in a fair and inclusive hiring process. We encourage you to apply if you may not meet all the requirements.
Join our amazing team!
We are looking for people just like you.
Annualized base pay range
$105,000.00 - $115,000.00There is a bonus component attached to this role in addition to the base salary
Starting pay offered will consider skills and experience. Your pay can grow as you build your career with us.
Suite 102 - 425 West 6th Avenue, Vancouver, BC V5Y 1L3
About Best Buy
At Best Buy, our purpose is to enrich lives through technology. We do that by leveraging our unique combination of tech expertise and human touch to meet our customers’ everyday needs, whether they come to us online, visit our stores or invite us into their homes. With over 1,000 stores and more than 90,000 employees in the United States and Canada, we solve key human needs in the areas of productivity, security, health, entertainment, connectivity, and more.
We’re a community of courageous change-makers, ambitious collaborators, and inspiring friends. Whether it’s working as a Geek Squad Agent, an in-store advisor, or in our corporate office, we offer each other support and prepare for what might come next.
We wake up every morning so we can do our part in shaping the future of a changing world. Together, we raise the bar for what’s possible and dream up new solutions to problems we’ve never encountered. We master innovative skills that we didn’t know were within grasp and turn everyday interactions into human connections built to last.
If change motivates you, if technology inspires you — we’re here for you. Tomorrow works here™.
Top Benefits
About the role
Senior Cloud Warehouse Designer
Are you passionate about data warehouse design and development?
This role encompasses both hands-on data modeling and the architectural guidance necessary to develop robust data warehouse solutions. You will be instrumental in designing data structures that support efficient data storage, retrieval, and analysis for business intelligence, ultimately empowering data-driven decisions across the organization. A key responsibility will be the efficient design and development of our cloud data warehouse.
We practice a remote first working model, leveraging in person interactions at our head office, in beautiful Vancouver, BC, for strategic, collaborative and social purposes.
Join our team as the senior cloud warehouse designer.
What you’ll do:
- Design and develop scalable and flexible conceptual, logical, and physical data models optimized for data warehousing on cloud platforms.
- Lead technical discussions on data modeling and data warehouse architecture, contributing to key architectural decisions.
- Design and implement end-to-end data warehouse architectures that align with business objectives and data requirements.
- Optimize data models and database designs for performance, ensuring efficient data processing and querying within the data warehousing environment.
- Collaborate closely with cross-functional teams, including business analysts, data architects, and data engineers, to understand and translate business needs into effective data warehousing solutions.
- Take ownership of the design and development of our cloud data warehouse, ensuring its efficiency and scalability.
- Develop and maintain essential documentation, including playbooks, business rules, data dictionaries, and data lineage models.
What we need:
- 5+ years of experience as a data warehouse designer utilizing platforms such as Snowflake or Azure Synapse.
- Demonstrated expert knowledge in data mapping, data transformation processes, and SQL, with a proven ability to implement physical and relational data models for data warehouse solutions.
- Proficiency in industry-standard data modeling tools and techniques (e.g. SAP power designer, ER/studio, erwin, UML, dimensional modeling, etc.).
- Practical experience with metadata management concepts and related tools.
- Expert-level understanding and experience with a modern data technology stack, such as microsoft azure (azure data lake storage, azure data factory, azure streams, databricks).
Why you’ll love it here:
- Remote-first work environment.
- Employee discounts on awesome tech from day one.
- Flexible health benefits and wellness program.
- TFSA and RRSP programs.
- 100% matched company pension plan.
- Training programs to build new and transferable skills.
About Best Buy
As Canada's destination for the coolest tech, Best Buy offers one of the best work environments in the country! Our culture is one of inclusivity and belonging and provides employees an environment where they can bring their whole selves to work.
We believe in a fair and inclusive hiring process. We encourage you to apply if you may not meet all the requirements.
Join our amazing team!
We are looking for people just like you.
Annualized base pay range
$105,000.00 - $115,000.00There is a bonus component attached to this role in addition to the base salary
Starting pay offered will consider skills and experience. Your pay can grow as you build your career with us.
Suite 102 - 425 West 6th Avenue, Vancouver, BC V5Y 1L3
About Best Buy
At Best Buy, our purpose is to enrich lives through technology. We do that by leveraging our unique combination of tech expertise and human touch to meet our customers’ everyday needs, whether they come to us online, visit our stores or invite us into their homes. With over 1,000 stores and more than 90,000 employees in the United States and Canada, we solve key human needs in the areas of productivity, security, health, entertainment, connectivity, and more.
We’re a community of courageous change-makers, ambitious collaborators, and inspiring friends. Whether it’s working as a Geek Squad Agent, an in-store advisor, or in our corporate office, we offer each other support and prepare for what might come next.
We wake up every morning so we can do our part in shaping the future of a changing world. Together, we raise the bar for what’s possible and dream up new solutions to problems we’ve never encountered. We master innovative skills that we didn’t know were within grasp and turn everyday interactions into human connections built to last.
If change motivates you, if technology inspires you — we’re here for you. Tomorrow works here™.