Data Architect

Vermont Information Processing; Ottawa; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading company in data solutions is seeking a Data Architect to enhance their analytics capabilities. This role focuses on designing effective data models and ensuring data security to help clients make informed decisions. The ideal candidate will possess a strong understanding of dimensional modeling along with effective communication skills, facilitating collaboration across teams.

Benefits

Extended Healthcare coverage including Vision & Dental

Employer GRSP contributions and matching

Life and Disability Insurance

Health Care Spending and Taxable Spending Accounts

Combined Time Off and Floating Holidays

Flex and Hybrid Schedules

Qualifications

• Minimum 2 years experience in IT with a focus on database systems.
• Strong understanding of Kimball-style dimensional modeling.
• Excellent verbal and written communication skills.

Responsibilities

• Design and document Kimball-style data warehouse solutions.
• Identify areas for improvement in current systems.
• Analyze, publish and present system information.

Skills

Dimensional Modeling

Data Security

SQL

Communication

Attention to Detail

Education

BS / MS in Computer Science or related field

Tools

SQL Server

Snowflake

DB2

Job description

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
• 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).

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Are 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.