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, Applied Mathematics, Data Management, or Information Science or related quantitative subject
Master's Degree Computer Science, Statistics, Applied Mathematics, Data Management, or Information Science or related quantitative subject

Work Experience
2 - 3 years Data Engineer I experience
2 - 3 years Power BI Development
2 - 3 years Azure Synapse Experience
3 - 5 years Business, information, or technology experience using Data

General Employee Knowledge, Skills, and Abilities
* Ability to establish effective working relationships among team members and participate in solving problems and making decisions
* Ability to present and express ideas and information clearly and concisely in a manner appropriate to the audience, whether oral or written
* Ability to actively listen to what others are saying to achieve understanding, sharing information with others and facilitating the open exchange of ideas and information
* Ability to establish courses of action for self to accomplish specific goals, develop and use tracking systems for monitoring own work progress, and effectively use resources such as time and information
* Ability to make right decisions based on perceptive and analytical processes, practicing good judgment in gray areas

Additional Knowledge, Skills and Abilities
MS Azure Synapse knowledge and skills required
Ability to with business and technology stakeholders to define and implement data use cases which deliver on customer-based outcomes
Ability to design, manage, and implement simple data flows and information architectures for financial institutions
Knowledge of analytics scripting tools
Ability to design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata and workload management. The ability to work with both IT and business in integrating analytics and data science output into business processes and workflows
Ability to work with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using traditional data integration technologies using APIs, Azure data Factory, etc
Ability to work with and optimize existing ETL processes and data integration and data preparation flows and helping to move them into production
Knowledge of popular data discovery, analytics and BI software tools like Microsoft PowerBI
Basic understanding of Artificial Intelligence and Machine Learning
Knowledge of agile methodologies
Written and verbal communication and presentations skills
Knowledge of data discovery, analytics and BI software tools like Microsoft PowerBI.
Ability to continuously learn in the information management, architecture, technology, and business fields

Licenses and Certifications
Azure Certification Within 1 year

Northwest is an equal opportunity employer. We are committed to creating an inclusive environment for all employees.