Data Engineer II

Job Description

The Data Engineer II will independently support Northwest Bank cloud data operations, functions, pipelines and architectures. The incumbent will be responsible for adding new data sources to the existing Data Lake, incorporating data from the Date Lake into Azure Synapse, migrating existing on-premises SQL Server EDW and CECL to Azure Synapse, and activating the Azure Analytics engine to help analysts and data scientists gain deeper insights into customer and bank data.  

After gaining an understanding of critical business objectives, the incumbent will determine the optimal design of Synapse, work with business partners on the initial use cases to implement, and work with business partners to drive the outcome.  

In addition, the incumbent will deliver self-service access and use of the Data Lake to business partners, and ensure the business partners become independent in their use of Data by leveraging Power BI. During this journey, the Data Engineer will work with business partners on their use cases, engage with Data Analysts to develop new requirements, and constantly promote and support increased use of Data at Northwest.  

Additional responsibilities may include designing and implementing changes to existing data pipelines, designing ETL processes, implementing advanced use cases, using machine learning to support growing digital channels, and monitor/tune the data environment for optimal performance. The incumbent will also participate in demonstrating value of our data assets and/or demonstrating/POC new ideas to move forward with our business partners.

 
Essential Functions
•    Engage with business partners to define Azure Synapse use cases to be supported in migration to Azure Synapse
•    Deploy Data Lake to business units and provide direct support for their use cases
•    Manage and monitor business user Data Lake use cases for successful outcomes; assist business users in leveraging and capitalizing on these outcomes
•    Migrate existing Data Lake data to Azure Synapse (will work with an offshore team)
•    Migrate existing on-premises SQL Server EDW to Azure Synapse
•    Design, build and optimize data pipelines from operational data stores to points of consumption (e.g. business stakeholders are constantly requesting new data ingestion, and need to deliver the data in a way to be consumed rapidly by business users)
•    Assist business and technology stakeholders in the use of tools and data to drive higher automation rates, and thereby greater efficiency in Bank operations - automate most common, repeatable tasks to assist business partners in delivering value to customers; automate common IT functions using data to simplify IT operations; automate collections conversion by use of data to drive behavioral score carding
•    Assist Data Governance team in delivering on Data Quality initiatives; and improve data capture at source points
•    Collaborate with stakeholders to ensure that data requirements are appropriately documented, refined and satisfied by the team (Must be able to use JIRA and Confluence)
•    Tune and manage Azure data environment
•    Follow data and analytics security requirements and solutions, and work with management to manage risks and ensure confidentiality, integrity and availability of enterprise data and analytics assets
•    Assist in defining modeling standards, guidelines, best practices and approved modeling techniques
•    Train business users to access Data Lake and create visuals through Power BI
 
Additional Essential Functions
•    Ensure compliance with Northwest’s policies and procedures, and Federal/State regulations
•    Navigate Microsoft Office Software, computer applications, and software specific to the department in order to maximize technology tools and gain efficiency
•    Work as part of a team
•    Work with on-site equipment
 
Additional Responsibilities
•    Handle other projects on request
•    Focus on value creation using the organization's data assets, as well as the external data ecosystem to maximize value derived from data and analytics
 
Safety and Health for those without supervisory duties 
•    Abide by the rules of the safety and loss prevention program
•    Perform work tasks in a safe manner
•    Report any and all injuries to supervisor
•    Know what to do in case of an emergency
 
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
 
Education
Bachelor's Degree    Computer Science, Statistics, App