Data Engineer

Webster Bank; Wilmington (MA); Remote; USD 110,000 - 130,000; Full time

Job summary

Webster Bank is seeking a skilled Data Engineer to enhance their data ecosystem. This role focuses on managing data infrastructure and collaborating cross-functionally to support data-driven strategies, requiring strong expertise in ETL processes and advanced SQL. Join a team dedicated to leveraging data as a pivotal business strategy.

Qualifications

• 5+ years of experience as a Data Engineer or similar role.
• Proficiency in ETL processes and cloud-based tools.
• Expertise in advanced SQL and relational data modeling.

Responsibilities

• Design and develop robust ETL processes.
• Implement and maintain data warehousing techniques.
• Collaborate with cross-functional teams for data solutions.

Skills

ETL processes

Advanced SQL

Data modeling

Data warehousing

Problem-solving

Collaboration

Tools

Azure Data Factory

AWS Data Pipe

MS SQL Server

Job description

If you’re looking for a meaningful career, you’ll find it here at Webster. Founded in 1935, our focus has always been to put people first--doing whatever we can to help individuals, families, businesses and our colleagues achieve their financial goals. As a leading commercial bank, we remain passionate about serving our clients and supporting our communities. Integrity, Collaboration, Accountability, Agility, Respect, Excellence are Webster’s values, these set us apart as a bank and as an employer.

Come join our team where you can expand your career potential, benefit from our robust development opportunities, and enjoy meaningful work!

The Data Engineer is primarily responsible for managing and optimizing our growing data infrastructure. The Data Engineer collaborates with the analytics team and managers across the business to drive our data-driven business strategy, ensuring data availability, accuracy, and integrity. This role offers an opportunity to shape our data ecosystem and contribute to our company’s long-term success. Expertise in ETL processes, advanced SQL, and data modeling will be crucial in developing robust data pipelines and scalable solutions. Join us and unlock the full potential of our data assets in a company focused on data as a key business strategy.

PRIMARY RESPONSIBILITIES:

• Design and develop robust ETL processes using tools such as SSIS and Azure Data Factory to extract, transform, and load data from various sources into our data warehouse.
• Apply expertise in OLTP and OLAP relational data modeling to design and maintain data structures, ensuring scalability, performance, and adherence to best practices.
• Implement and maintain data warehousing techniques, including the creation of star and snowflake schema data models, to support efficient data storage, retrieval, and analytics.
• Utilize advanced SQL skills to optimize and automate data retrieval, manipulation, and aggregation for analysis and reporting purposes.
• Collaborate with cross-functional teams, including data scientists, analysts, and stakeholders, to understand data requirements and translate them into scalable and reusable data solutions.
• Continuously monitor and improve data quality, integrity, and consistency across various data sources and platforms.

REQUIRED SKILLS/QUALIFICATIONS:

• 5+ years of experience as a Data Engineer or similar role, with a strong understanding of data engineering concepts and best practices.
• Proficiency in ETL processes, utilizing cloud-based tools such as Azure Data Factory, AWS Data Pipe, etc.
• Proficiency in using Azure or AWS cloud based services like blob storage/S3, Azure SQL/RDS
• Familiarity with relevant cloud services like Azure Databricks, Azure Synapse, etc.
• Expertise in advanced SQL, with the ability to write efficient and optimized queries in both OLTP and OLAP datasets.
• In-depth knowledge of OLTP and OLAP relational data modeling techniques.
• Familiarity with data warehousing concepts, including star and snowflake schema data models.
• Strong experience with MS SQL Server or other RDBMS platforms.
• Excellent problem-solving and analytical skills, with a keen attention to detail.
• Effective communication and interpersonal skills, with the ability to collaborate and work well within a team.
• Knowledge in utilizing MS Dynamics 365 as a data source is highly desired

The estimated salary range for this position is $110,000USD to $130,000USD. Actual salary may vary up or down depending on job-related factors which may include knowledge, skills, experience, and location. In addition, this position is eligible for incentive compensation.

#LI-FO1

#LI-Remote

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.