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 & QualificationsThe 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.
AttributesCollaborative, 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.
Options Apply for this job onlineApplyRefer a FriendRefer a Friend Sorry the Share function is not working properly at this moment. Please refresh the page and try again later. Benefits & Rewards Want 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. Application FAQs
Software Powered by iCIMS
www.icims.com