Data Architect
Vipvermontinformationprocessing
Apply to this jobVermont Information Processing is the country's leading provider of software solutions for the beverage industry. We craft the technology that assists in every part of a beverage's journey from its creator to your glass! For over 50 years VIP's success has been driven by the relationships we've built with our beverage customers and partners. We work to solve their mission-critical problems, provide innovative solutions for their businesses and never stop reimagining ways that we can help them succeed.
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 Colchester, VT.
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:
- Health Insurance
- Vision and Dental Expense Reimbursement
- 401k and Profit Sharing
- Life and Disability Insurance
- Health Savings and Flexible Spending Accounts
- Paid Parental Leave
- On-site Child Care Center
- On-site Fitness Center
- On-site Health Clinic
- Discounted Gym Memberships
- Combined Time Off and Floating Holidays
- Flex and Hybrid Schedules
All full time job offers are contingent upon passing a pre-employment drug screening and background check.
VIP offers the unique opportunity to become a valued member of an industry-leading organization. We provide a great work environment and benefits that support a healthy work/life balance, as well as growth opportunities and a generous retirement plan that support a stable future. Consistently named one of the Best Places to Work in Vermont, our goal is to offer an atmosphere that you can look forward to being a part of every day.
Summary
Design and optimize data warehouse and analytics solutions for beverage industry.
Job title
Data Architect
Experience level
2+ years
Industry
software
Location requirements
Colchester, VT with hybrid remote work allowed
Salary
Not specified
Visa sponsorship
H-1B sponsor history
Management role
No
Required skills
Preferred skills
Specializations
Structured locations inferred from the posting.
Colchester, VT, USA