Job Title

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 solutionsDesign and document OLTP database solutionsIdentify areas for improvement in current systemsDevelop systems to ensure data securityAnalyze, publish and present system informationCoordinate and communicate with other teams to reach project milestones and deadlinesRequirements:BS / MS in Computer Science or related fieldMinimum 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 environmentAbility to function well in a fast-paced, dynamic environment with competing prioritiesStrong 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 termsExcellent attention to detailExperience with database management softwareKnowledge of SQL Server, Snowflake and DB2 is a plus!Benefits Include:Extended Healthcare coverage including Vision & DentalEmployer GRSP contributions and matchingLife and Disability InsuranceHealth Care Spending and Taxable Spending AccountsCombined Time Off and Floating HolidaysFlex and Hybrid SchedulesAll full time job offers are contingent upon passing a pre-employment drug screening (US) and background check (US & CAN).Apply for this job*indicates a required fieldFirst Name *Last Name *Email *Phone *Resume/CV *Enter manuallyAccepted file types: pdf, doc, docx, txt, rtfEnter manuallyAccepted file types: pdf, doc, docx, txt, rtfAre you authorized to work in Canada? * Select...Are you located in Ottawa and able to commute to our Ottawa office? * Select...How many years of information technology work experience do you have? *Were you referred by a VIP employee? If so, please list their name. #J-18808-Ljbffr