Design and optimize enterprise data warehouse and analytics solutions, focusing on dimensional modeling and database management while collaborating with teams.
VIP is seeking a Data Architect with expertise in dimensional modeling to design, implement, and optimize our enterprise data warehouse and analytics solutions. This role is instrumental in helping beverage distributors, suppliers, and retailers make data-driven decisions through scalable and high-performance data architectures. We are looking for a motivated self-starter who enjoys collaboration and innovation.
Position Type: Full Time, Hybrid - will be required to report to our office in Ottawa, ON Canada, or Colchester, VT, USA.
Primary Responsibilities:
- Design and document Kimball-style data warehouse solutions
- Design and document OLTP database solutions
- Identify areas for improvement in current systems
- Develop systems to ensure data security
- Analyze, publish and present system information
- Coordinate and communicate with other teams to reach project milestones and deadlines
Requirements:
- BS / MS in Computer Science or related field
- Minimum of 2 years experience in information technology with increasing responsibility in understanding and designing complex and enhancing existing relational database systems.
- Proven track record of successfully managing all stages of large-scale database projects.
- Strong understanding of Kimball-style dimensional modeling, including fact and dimension table design, slowly changing dimensions (SCDs), star and snowflake schemas, and best practices for optimizing ETL processes in a data warehouse environment
- Ability to function well in a fast-paced, dynamic environment with competing priorities
- Strong ability to translate complex business needs into scalable data models.
- Excellent verbal and written communication skills to collaborate with technical and non-technical stakeholders.
- Ability to explain complicated concepts in simple terms
- Excellent attention to detail
- Experience with database management software
- Knowledge of SQL Server, Snowflake and DB2 is a plus!
Benefits Include:
- Extended Healthcare coverage including Vision & Dental
- Employer GRSP contributions and matching
- Life and Disability Insurance
- Health Care Spending and Taxable Spending Accounts
- Paid Parental Leave
- Combined Time Off and Floating Holidays
- Flex and Hybrid Schedules
All full time job offers are contingent upon passing a pre-employment drug screening (US) and background check (US & CAN).
Top Skills
Db2
Dimensional Modeling
Kimball-Style Data Warehouse
Oltp
Snowflake
SQL Server
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead the architectural design and execution of data lake and warehouse solutions; oversee migration to Unity Catalog and ensure data governance best practices.
Top Skills:
AbacAWSAzureDatabricksDelta LakeGCPRbacUnity Catalog
Fintech • Payments • Financial Services
Lead the implementation of GenAI solutions within enterprise data architecture, collaborating with teams to develop strategies, patterns, and best practices for data management and analytics.
Top Skills:
AWSData Lake TechnologiesEmrGenaiGlueKafkaLambdaLlmsPythonRedshiftSpark
Software
Lead the design and implementation of complex data solutions, oversee data lifecycle management, and develop machine learning models to support data analysis.
Top Skills:
Amazon Web ServicesBigQueryCloud Data WarehousingGenerative AiGoogle Cloud PlatformMachine LearningNoSQLRedshiftSnowflake
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
