About the role

Aplyr's Quick Take

This role is for a Senior Data Architect focused on designing and optimizing data warehouse solutions, specifically using Kimball-style dimensional modeling. You'll be working on complex database systems and collaborating with various teams to ensure data-driven decision-making for clients in the beverage industry. It's an individual contributor role with a mix of technical design and project coordination.

Good fit

Ideal candidates have at least 5 years of experience in IT with a strong background in database design and management. You should be a self-starter who thrives in fast-paced environments and can communicate effectively with both technical and non-technical stakeholders.

Worth noting

The position is hybrid, requiring some in-office presence in Colchester, VT. The focus on beverage industry clients may appeal to those interested in niche markets, but the role's specifics on day-to-day tasks are somewhat vague.

VIP is seeking a Senior 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 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!

Compensation: $110,000-$120,000/year

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.

Benefits Include:

Health Insurance
Vision and Dental Expense Reimbursement
401k Match & Employer Contributions
Life and Disability Insurance
Health Savings and Flexible Spending Accounts
Paid Parental Leave
On-site Child Care Center (VT)
On-site Fitness Center (VT)
On-site Health Clinic (VT)
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.

Skills & Tags

ai data analytics design

Aplyr's read

Vermont Information Processing specializes in software solutions for the insurance sector, attracting professionals in tech, administration, and unique roles like educators.
Synthesized from recent postings & public sources

What's promising

•Strong focus on niche insurance technology solutions offers specialized career paths.
•Diverse roles indicate a dynamic work environment with varied opportunities.
•Recent hiring for technical and non-technical roles suggests company growth.

What to watch

•Limited public information about company culture and employee satisfaction.
•Niche industry focus may limit career mobility outside insurance technology.
•Potentially limited advancement opportunities in non-technical roles.

Why Vermont Information Processing

•Combines software development with insurance expertise, creating specialized solutions.
•Hiring educators suggests a commitment to employee development and training.
•Offers a rare mix of tech and non-tech roles in the same company.

Aplyr’s read is generated by AI from public sources. Was it useful?

About Vermont Information Processing

Vermont Information Processing

public.vtinfo.com

View company

Vermont Information Processing provides software solutions and services primarily for the insurance industry, focusing on policy administration, claims management, and billing.