Senior Data Architect

<p>VIP is seeking a <strong>Senior</strong> <strong>Data Architect</strong> 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.</p> <p><strong>Position Type:&nbsp;</strong>Full Time,&nbsp;Hybrid - will be required to report to our office in Colchester, VT.</p> <p><strong>Primary Responsibilities:</strong></p> <ul> <li>Design and document Kimball-style data warehouse solutions</li> <li>Design and document OLTP database solutions</li> <li>Identify areas for improvement in current systems</li> <li>Develop systems to ensure data security</li> <li>Analyze, publish and present system information</li> <li>Coordinate and communicate with other teams to reach project milestones and deadlines</li> </ul> <p><strong>Requirements:</strong></p> <ul> <li>BS / MS in Computer Science or related field</li> <li>Minimum of 5 years experience in information technology with increasing responsibility in understanding and designing complex and enhancing existing relational database systems.</li> <li>Proven track record of successfully managing all stages of large-scale database projects.</li> <li>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</li> <li>Ability to function well in a fast-paced, dynamic environment with competing priorities</li> <li>Strong ability to translate complex business needs into scalable data models.</li> <li>Excellent verbal and written communication skills to collaborate with technical and non-technical stakeholders.</li> <li>Ability to explain complicated concepts in simple terms</li> <li>Excellent attention to detail</li> <li>Experience with database management software</li> <li>Knowledge of SQL Server, Snowflake and DB2 is a plus!</li> </ul> <p></p> <p><strong>Compensation:&nbsp;</strong>$110,000-$120,000/year</p> <p>Compensation is based on a variety of factors including skills, experience and industry background. The range listed here represents our best faith estimate for the role.&nbsp;</p> <p><strong>Benefits Include:</strong></p> <ul> <li>Health Insurance</li> <li>Vision and Dental Expense Reimbursement</li> <li>401k Match &amp; Employer Contributions</li> <li>Life and Disability Insurance</li> <li>Health Savings and Flexible Spending Accounts</li> <li>Paid Parental Leave</li> <li>On-site Child Care Center (VT)</li> <li>On-site Fitness Center (VT)</li> <li>On-site Health Clinic (VT)</li> <li>Discounted Gym Memberships</li> <li>Combined Time Off and Floating Holidays</li> <li>Flex and Hybrid Schedules&nbsp;</li> </ul> <p>&nbsp;</p> <p><em>All full time job offers are contingent upon passing a pre-employment drug screening and background check.</em></p>