Data Engineer

Empeople-Credit-Union; Moline (IL); On-site; USD 89,000 - 133,000; Full time

Benefits offered by this job

Health, Dental & Vision Benefits

Bonus opportunity

401(k) with match and profit sharing

Flexible Time Off

Job summary

Empeople Credit Union is seeking a skilled Data Engineer to design, build and automate data pipelines that feed analysts with strategic insights. You will create and maintain ETL processes, transform data into the warehouse, and ensure reliable validation and alerting across the workflow.

You will leverage Snowflake tools (Snowpipe, SnowSQL) and Azure Data Factory, using Python and SQL to connect APIs, files and sources, document configurations, and partner with business teams in an Agile

Qualifications

• 2+ years writing SQL with ETL transformation tools and Python.
• Experience importing data from APIs, files and other sources, transformation and pipelining.
• Experience in financial institutions preferred.
• Snowflake and Azure Data Factory experience preferred.

Responsibilities

• Partner with business users and technology teams to define requirements and build solutions in an Agile framework.
• Create and maintain an automated ETL framework within Snowflake and other tools.
• Use version control to manage data automation revisions.
• Maintain Data Warehouse configuration documentation and automation reports.
• Develop data automations using Azure Data Factory, Snowflake, and Python.
• Validate and cleanse data with QA checks to ensure clean data availability.
• Improve on-time delivery of data for analysts and 3rd party extractions.
• Troubleshoot data-related issues and support all CU areas.
• Identify new process improvement opportunities.

Skills

SQL

Python

ETL

Data transformation

Pipelining

Data quality assurance

Education

Bachelor's degree in Computer Science, Mathematics, Business

Tools

Snowflake

Snowpipe

SnowSQL

Azure Data Factory

Job description

OVERVIEW

We are seeking a highly skilled and motivated Data Engineer responsible for supporting the Credit Union and Data & Analytics with efficient data solutions that are dynamic and automated. This role will take part in designing, creating and maintaining a framework for importing and transforming data into tables to be used by our analysts for strategic insights. This role will be creating and scheduling and triggering data pipelines, ETL processes and automated validation/alerting of these processes. AI LLM models are encouraged to be utilized for researching, creating and maintaining ETL data routines when possible. This role will be building, maintaining, and documenting the framework for how data solutions such as API connections, database tables & csv extracts flow into the data warehosue for Data Integration projects.

This role will be using Snowflake tools such as Snowpipe, SnowSQL. Openflow, Native SDK for Connectors, & CLI. Currently using Microsoft’s Azure Data Factory for connecting to network sources as well as reviewing other tools. Languages utilized include Python, some Java and heavy SQL for querying and transforming data as well.

QUALIFICATIONS

• 2 to 4 years writing SQL, utilizing ETL transformation tools & Python for transforming data.
• Experience with Data Importing from APIs, files and other data sources, Transformation, Pipelining, Data Extraction and some Data Mining
• Experience in financial institutions preferred
• Experience with Snowflake and Azure Data Factory preferred.

ESSENTIAL FUNCTIONS

• Partneringwith business users, programming, technology teams, data analysts, and project management teams to define requirements and develop and implement solutions within a mature agile framework.
• Creating and maintaining an automated ETL framework within Snowflake and other ETL tools based on business transformation rules.
• Utilizing the version control function within the ETL tools manage and track data automation revisions.
• Working with business partners to maintain Data Warehouse configuration documentation.
• Utilizing Azure Data Factory, Snowflake & Python tools to create data automations and reports.
• Utilizing Python programs to perform custom transformations with data.
• Validating and cleansing data and other alert automations with predefined quality assurance checks to ensure clean and consistent data availabil
• Optimizing on-time delivery of data for analyst team and custom extracts to 3rd party systems.
• Diagnosing and troubleshooting data-related issues
• Perform other duties as assigned and support all areas of the credit union.
• Locate and define new process improvement opportunities.

REQUIRED EDUCATION AND EXPERIENCE

Bachelor’s degree in Computer Science, Mathematics, Business, or equivalent experience and a minimum of two years of related experience in a financial institution.

• License or Certification:
• Bondable
• Acceptable Credit History

COMPETENCIES:

• Core CU systems, databased protocol, and programming capability
• Must be able to work on multiple projects, strong problem-solving ability.
• Communication Skills
• Mathematical Skills
• Reasoning & Troubleshooting Ability

Pay Range

USD $88,740.00 - USD $133,110.00 /Yr.

Compensation & Benefits

• Health, Dental & Vision Benefits
• Bonus opportunity
• 401(k) with match and profit sharing
• Flexible Time Off

Empeople Credit Union is an EEO/Affirmative Action Employer

EMPLOYMENT AT WILL

Empeople Credit Union employment is at will. Employees may resign from Empeople Credit Union as they choose. Similarly, Empeople Credit Union may terminate an employee at any time, with or without notice or cause. Nothing in this Handbook or any other manual or policy adopted by Empeople Credit Union in any way alters the at-will nature of employment at Empeople Credit Union. False statements or material omissions in the Application for Employment will be grounds for immediate termination.