[Remote] Lead Data Engineer (multiple positions available)

Note: The job is a remote job and is open to candidates in USA. Provident Bank is seeking a Lead Data Engineer to design, develop, test, and implement advanced data movement solutions for their data warehouse. The role involves optimizing data processes, providing technical guidance, and ensuring the reliability of data for the firm's business intelligence needs.ResponsibilitiesResponsible for the 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 warehouseDesign, 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 applicationsProvide technical guidance on data movement related issues and ensure optimal design for all aspects of the data warehousePerform data analysis and sourcing to target mappings and verify accuracy of data within the Bank’s data warehouseIdentify, 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 teamImplement, maintain, and extend best practices and assets in line with the market standards and guidelines to best ensure reliability of the Bank’s dataSkillsMaster'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 occupationAlternatively, 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 occupation5 years of experience in the banking or financial technology services industry, working on data warehousing, data transformation, and data integration development5 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 designs5 years of experience with Customer 360 data warehousing model5 years of experience with SQL Server and Oracle5 years of experience in Data Warehousing, including deploying Slowly Changing Dimensions Type 1 and 25 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 Powershell5 years of experience building internal and external customer relationships with internal IT teams and external vendors5 years of experience working with a Data Architecture team implementing enterprise Data Modeling designs into a Data Warehouse and target file repositories5 years of experience developing effective standard operating procedures using both industry and team developed best practices5 years of experience supporting production data pipeline processes and determining root cause of failures5 years of experience collaborating with cross-functional teams and explaining complex data warehousing and related concepts to non-technical stakeholdersBenefitsIncentive eligible based upon company, business, and/or individual goal achievement and performanceTeam members accrue paid time-off (PTO)Receive Holiday (PTO)Eligible to participate in the bank’s Health and Wellness benefits including Medical, Dental and Vision PlansFlexible and Health Savings Accounts401(k) Retirement PlanDisability InsuranceEmployee Assistance ProgramBasic Life InsuranceCompany sponsored Tuition Disbursement and Loan Repayment programsVoluntary benefits include Supplemental Life Insurance, Accident, Critical Illness, Hospital Indemnity and Legal plansCompany OverviewProvident Bank is the wholly owned subsidiary of Provident Financial Services, Inc. It was founded in 1839, and is headquartered in Jersey City, New Jersey, USA, with a workforce of 1001-5000 employees. Its website is https://www.provident.bank.