Senior Data Architect - Dimensional Modeling & DW (Hybrid)

VIP (Vermont Information Processing); Colchester (VT); Hybrid; USD 110,000 - 120,000; Full time

Benefits offered by this job

Health Insurance

Vision and Dental Expense Reimb.

401k Match & Employer Contributions

Life and Disability Insurance

Health Savings and Flexible Spending

Paid Parental Leave

Discounted Gym Memberships

Combined Time Off and Floating Hybrids

On-site Child Care Center (VT)

On-site Fitness Center (VT)

On-site Health Clinic (VT)

Job summary

VIP (Vermont Information Processing) seeks a Senior Data Architect with Kimball-style dimensional modeling to design, implement, and optimize our enterprise data warehouse and analytics solutions, enabling beverage distributors, suppliers and retailers to make data-driven decisions.

You will collaborate across teams to design scalable data models, mentor others, and help drive high-performance ETL processes in a fast-paced environment.

Qualifications

• BS / MS in Computer Science or related field.
• 5+ 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!

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

Skills

Kimball-style data modeling

ETL design

SQL & relational databases

Data warehousing

Communication

Problem solving

Team collaboration

Education

BS or MS in Computer Science

Related field advanced degree

Tools

SQL Server

Snowflake

DB2

Job description

VIP (Vermont Information Processing) seeks a Senior Data Architect with Kimball-style dimensional modeling to design, implement, and optimize our enterprise data warehouse and analytics solutions, enabling beverage distributors, suppliers and retailers to make data-driven decisions.

You will collaborate across teams to design scalable data models, mentor others, and help drive high-performance ETL processes in a fast-paced environment.