Data Warehouse Programming Specialist jobs in Essex, VT

Position Summary

As a Data Warehouse Engineer in our Data Warehouse Team, you will play a crucial role in shaping the backbone of our data-driven decision-making process. Your focus will be on developing, maintaining, and optimizing our data warehouse solutions, ensuring they are scalable, efficient, and aligned with our business needs.

Your primary responsibility will be constructing and maintaining robust data warehouse architectures that can handle large-scale data in an efficient manner. This includes the development of ETL processes and data pipelines in Synapse, ensuring high data quality and process efficiency. You will also be responsible for implementing and managing data storage solutions in Snowflake, focusing on optimization and cost-effectiveness to support our dynamic data needs.

Key Responsibilities

• Designs the architecture of enterprise data warehouse following the dimensional data modeling methodology.
• Develops the architecture to perform data management activities that Extract, Transform, and Load (ETL) data into data warehouse to meet stakeholder specifications.
• Works with product stakeholders to implement, maintain, and enhance data models and solutions used to define and measure quality of data domains.
• Develops data models to meet business requirements and ensure data acquisition, access analysis, archive, recovery, load design and implementation.
• Employs best practices for development new releases and coordinate the new releases to ensure consistency with existing warehouse structure.
• Collaborates with IT peers and internal customers to identify data project requirements and ensure the successful design, documentation, and fulfillment of data requests for new and on-going reports, dashboards, and scorecards.
• Provides direction and guidance in the development, implementation, and maintenance of front-end presentation (dashboards), automated report solutions and other BI solutions to support tactical and strategic reporting needs of the organization.
• Understands business requirements and priorities to shape the scope and specifications of the data warehouse solution, including the identification and resolution of data integrity problems.
• Provides guidance in the architecture, design and evolution of enterprise warehouse and information delivery solutions, including tool selection, migration strategies, and risk mitigation.
• Participates in training and other learning opportunities to expand knowledge of the company, products, sales, and services and performs any other duties needed to help drive our vision, fulfill our mission, and/or abide by our core values.

Education, Experience & Qualifications

The successful candidate will have a bachelor’s degree in computer science, business or management information systems, electronic engineering, or other engineering discipline (8 years of additional revlevant experience may be subsitituted for degree) with a Master’s degree in Database Management or Data Science is preferred.

A strong knowledge of data analysis, data modeling, and statistical techniques. Proficiency in programming languages such as Python, R, SQL, Spark SQL or similar. The ability to design and build data pipelines and workflows. Experience with data visualization tools such as Tableau, Power BI, or similar. Familiarity with AI and machine learning concepts and frameworks. Excellent problem-solving and critical-thinking skills. Strong communication and presentation skills. Ability to work collaboratively in a team environment. Experience with cloud platforms such as Azure, AWS Understanding of SQL and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB) and data warehousing solutions (Synapse, Amazon Redshift, Snowflake). Working knowledge Version Control and Collaboration Tools such as DevOps using Git Strong analytical abilities and problem-solving skills. Effective communication skills and a continuous learning mindset for adapting to new technologies.

Attributes

Collaborative, curious, and results-driven individual who is self-motivated with the ability to define problems, design solutions and implement the best solutions while managing multiple projects and priorities and building multi-disciplinary groups and all organizational levels to fulfill enterprise data requirements.

Benefits

Medical, Dental, Vision, Life & Disability Insurance, Maternity & Parental Leave, Flexible Spending Accounts, Discounted Stock Program, 401K, Employee Awards, Employee Assistance Plan, Wellness Incentive, Tuition Assistance, Career Pathways, and More.