Data Warehouse Engineer

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 aMaster’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, AWSUnderstanding 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 GitStrong 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 todefine 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. ## Need help finding the right job? We can recommend jobs specifically for you Benefits & RewardsWant easy-to-use, rewarding benefits? Well, we’ve got those Our employee rewards program is designed to help you in your career, and in your life outside of Casella. From competitive wages to comprehensive medical plans to employee stock purchase and retirement savings options, learn about all the ways we reward you. EEO Casella Waste Systems, Inc. is an equal opportunity employer. We are committed to creating an environment of inclusion and mutual respect where opportunities are available to all applicants and team members without regard to race, religion, color, national origin, gender, gender identity or expression, sexual orientation, genetic information, military and veteran status, status as individual with a disability, or any other characteristic protected by federal or state laws. We believe that diversity and inclusion among our team members is critical to our success as a company and we seek to recruit, develop, and retain the most talented people. Job Locations US-VT-Rutland Job ID 2024-4785 Category Information Technology Type Regular Full-Time