Data Engineer

Company: Northwest Bancorp, Inc.
Location: Warren
Posted on: June 6, 2021

Job Description:

Now is an exciting time to join Northwest - We are a growing, data driven organization with growth opportunities for you! Being part of Northwest is all about the people. We work as a team and support each other, fostering a collaborative environment across departments. We take pride in our work, offering the very best in customer service and in the communities we serve.

The Data Engineer will independently support our data operations functions, pipelines and architectures. Through their understanding our data content and information architecture, they will design new and make changes to existing data workflows. They will design ETL, machine learning and artificial intelligence algorithms, data flows and monitor/tune our data environment for optimal performance. They will also participate in demonstrating value in our data assets by collaborating with analysts, architects and other stakeholders to develop business cases, plans and cost estimates needed to demonstrate value of our initiatives.

Locations available:

Buffalo, NY

Cleveland, OH

Columbus, OH

Pittsburgh, PA

Warren, PA

Essential Functions

• Design, build and optimize managed data pipelines from operational data stores to points of consumption such as an enterprise data warehouse, data mart, or end user technologies
• Use innovative tools, techniques and architectures to automate most common, repeatable tasks to maximize data quality and productivity
• Collaborate across teams to work with stakeholders to ensure that data requirements are appropriately documented, refined and satisfied by the team
• Apply and use modern data preparation, integration and AI-enabled metadata management tools and techniques
• Track data consumption patterns to proactively identify new requirements or refinements, and report against preset baselines
• Use, understand and gain experience with artificial intelligence (AI), machine learning (ML) and predictive analytics to help drive customer experiences
• Perform optimization of data environments using techniques like intelligent sampling and caching
• Manage logical and physical data models in all their forms, including conceptual models, relational database designs, message models and others
• Implement data architectures that can identify, prioritize and execute the data and analytic initiatives focused on defined enterprise strategies and business outcomes
• 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
• Follow defining modeling standards, guidelines, best practices and approved modeling techniques
• Assess impact of schema changes across the managed databases to ensure data quality and that resources and aggregations remain accurate
• Participate with data and analytics leaders, and business and IT leadership in developing and following information governance processes and structures

Additional Essential Functions

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

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

Education Level

Education Details

Req

Pref

Bachelor's Degree

Computer Science, Statistics, Applied Mathematics, Data Management, or Information Science or related quantitative subject

X

Master's Degree

Computer Science, Statistics, Applied Mathematics, Data Management, or Information Science or related quantitative subject

X

Work Experience

Experience

Experience Details

Req

Pref

Less than 2 years

Data Engineer I experience

X

Or

3 - 5 years

Business, information, or technology experience

X

Role Type for KSAs

General Employee

General Employee Knowledge, Skills, and Abilities

Proficiency

• 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

KSAs

Proficiency

Ability to design, manage, and implement simple data flows and information architectures for financial institutions

Extensive

Knowledge of analytics scripting tools using languages such as R, Python/PySpark, Java, and C++.

Extensive

Skill with big data platforms like Hadoop and Azure Synapse.

Extensive

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

Extensive

Skill with popular database programming languages including T-SQL for relational databases and certifications on upcoming NoSQL/Hadoop oriented databases like MongoDB, Cassandra, others for nonrelational databases

Extensive

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, SQL Server SSIS, etc

Extensive

Ability to work with SQL on Hadoop tools and technologies including HIVE, Impala, Presto, Hortonworks Data Flow (HDF), Dremio, Informatica, Talend and others

Extensive

Ability to work with and optimizing existing ETL processes and data integration and data preparation flows and helping to move them in production

Extensive

Ability to work with both message queuing technologies such as Kafka, JMS, Azure Service Bus, and stream data integration technologies such as Apache Nifi, Apache Beam, Apache Kafka Streams, Amazon Kinesis and stream analytics technologies such as Apache Kafka KSQL, Spark Streaming, Samza and others

Extensive

Knowledge of popular data discovery, analytics and BI software tools like Microsoft PowerBI for semantic-layer-based data discovery

Working

Ability to working with data science teams in refining and optimizing data science and machine learning models and algorithms

Extensive

Knowledge of data science platforms such as Python, R

Working

Knowledge of agile methodologies, DevOps and DataOps principles

Extensive

Written and verbal communication and presentations skills

Extensive

Knowledge of data discovery, analytics and BI software tools like Microsoft PowerBI.

Extensive

Ability to continuously learn in the information management, architecture, technology, and business fields

Extensive

Keywords: Northwest Bancorp, Inc., Erie , Data Engineer, Other , Warren, Pennsylvania