Lead Data Engineer (multiple positions available)

Provident Bank•Iselin, NJ

6h•Remote

About The Position

We are seeking a Lead Data Engineer to design, develop, test, and implement the next generation of data movement solutions for the Bank. This role will utilize state-of-the-art technologies to optimize the effectiveness of Provident Bank’s data warehouse. You will be responsible for designing, developing, testing, and implementing ETL/ELT data movement jobs based on business requirements to feed data into Provident’s data warehouse and various downstream bank applications. This position offers technical guidance on data movement related issues and ensures optimal design for all aspects of the data warehouse. You will perform data analysis and sourcing to target mappings, verifying the accuracy of data within the Bank’s data warehouse. Additionally, you will identify, design, and implement process improvements, such as automating manual processes and optimizing data delivery, to enhance the quality of data for the firm’s business intelligence team. You will also implement, maintain, and extend best practices and assets in line with market standards and guidelines to ensure the reliability of the Bank’s data. This position allows for telecommuting/remote work from any location within the US, with up to 5% domestic travel required for meetings at company headquarters in Iselin, NJ.

Requirements

Master’s degree in Applied Computer Science, Engineering/Industrial Management, Finance or related field of study plus five (5) years of experience in the job offered or five (5) years of experience as a Lead Data Engineer, Technical Engineer III, Principal Software Engineer, Programmer Analyst, or related occupation.
Alternatively, a Bachelor’s degree in Applied Computer Science, Engineering/Industrial Management, Finance or related field of study plus seven (7) years of experience in the job offered or seven (7) years of experience as a Lead Data Engineer, Technical Engineer III, Principal Software Engineer, Programmer Analyst, or related occupation.
5 years of experience in the banking or financial technology services industry, working on data warehousing, data transformation, and data integration development.
5 years of experience in Enterprise Data Transformation and Automation Development platforms including at least one of the following: SAP Data Services, Informatica (Power Center or IDMC or BDM), or SSIS (SQL Server Integration services).
5 years of experience with Metadata repository working with and deploying data model designs.
5 years of experience with Customer 360 data warehousing model.
5 years of experience with SQL Server and Oracle.
5 years of experience with Data Warehousing, including deploying Slowly Changing Dimensions Type 1 and 2.
5 years of experience building fully automated ETL Pipelines with reconciliation, auditing, notification, scheduling, and recovery(rerun).
5 years of experience with Scripting languages that interact with SQL Server, and Windows Server file systems for building backup routines, file archives, or other operational automations such as Powershell.
5 years of experience building internal and external customer relationships with internal IT teams and external vendors.
5 years of experience working with a Data Architecture team implementing enterprise Data Modeling designs into a Data Warehouse and target file repositories.
5 years of experience Developing effective standard operating procedures using both industry and team developed best practices.
5 years of experience supporting production data pipeline processes and determining root cause of failures.
5 years of experience collaborating with cross-functional teams and explaining complex data warehousing and related concepts to non-technical stakeholders.

Responsibilities

Design, development, testing, and implementation of the new generation of data movement solutions for the Bank using state of the art technologies to optimize effectiveness of Provident Bank’s data warehouse.
Design, develop, test, and implement ETL/ELT data movement jobs based on business requirements to feed data into Provident’ s data warehouse and the various downstream bank applications.
Provide technical guidance on data movement related issues and ensure optimal design for all aspects of the data warehouse.
Perform data analysis and sourcing to target mappings and verify accuracy of data within the Bank’s data warehouse.
Identify, design and implement process improvements (i.e. automate manual processes and optimize data delivery) to optimize the quality of data for the firm’s business intelligence team.
Implement, maintain, and extend best practices and assets in line with the market standards and guidelines to best ensure reliability of the Bank’s data.