Data Engineer

First Dakota; Sioux Falls (SD); On-site; USD 95,000 - 130,000; Full time

Job summary

First Dakota is actively searching for a Data Engineer to join our Sioux Falls team to design and maintain the bank’s enterprise data platform. You will develop scalable ETL/ELT pipelines using Microsoft Fabric, Python, SQL, Spark, Power BI, DBT, and Azure services, supporting analytics, regulatory reporting, and governance initiatives.

The role requires 3+ years in a data engineering/ETL capacity, familiarity with financial systems, and collaboration with analysts and technology teams to

Qualifications

• Bachelor’s degree in CS or related field.
• 3+ years of experience as a Data Engineer, ETL Developer, Data Warehouse Developer, or similar role.
• Experience with Microsoft Fabric, Databricks, or Snowflake.

Responsibilities

• Design, develop, test, and maintain data pipelines to extract, transform, and load data into Microsoft Fabric.
• Connect and integrate data from core banking systems, third-party apps, APIs, files, and cloud platforms.
• Develop batch and near real-time data processing solutions using SQL, Python, Spark, and related technologies.
• Build and maintain reusable ingestion, transformation, orchestration, and monitoring frameworks.
• Transform and enrich data through business rules, auditing, validation, and data quality controls.
• Create and maintain models to support Power BI and enterprise reporting.
• Implement monitoring, error handling, and documentation for data platform processes.
• Support workflow automation and orchestration initiatives using Fabric, SharePoint, Power Apps, Power Automate.
• Partner with data analysts, business stakeholders, and tech teams to deliver reliable data products.
• Participate in data governance, security, metadata management, and documentation.

Skills

SQL

ETL/ELT

Data Integration

Education

Bachelor’s degree in computer science, Information Systems, Data Engineering, or related field

Tools

Microsoft Fabric

Databricks

Snowflake

Python

Spark

Git

CI/CD

REST APIs

Job description

Working through the Covid pandemic and the unknowns was an extremely stressful time for all. Having said that, bank ownership and the entire executive management team made navigating the unknowns that much easier. They provided the tools necessary to take care of our customers during this time and it was amazing to see all employees come together as one to try and operate as normal as possible. The constant communication from management and their continued concern for employee health was amazing to see. Cory W. employed since 2014

I feel so proud to be a part of an institution that does so much good to preserve mainstays and help develop communities all over the SE SoDak region. From investing in the historic State Theater in downtown Sioux Falls, to building that beautiful soccer facility in Yankton, our partnerships are everywhere in the communities we serve. I feel that there is a true culture of compassion at First Dakota. Being voted Best Bank of South Dakota 2 years in a row speaks volumes too. And though I come from a family of diehard Rabbits fans (Go Big, Go Blue!), I’m excited to see our logo on the USD Coyote basketball court in Vermillion. (Go Yotes too!) Carly S. employed since 2023

I really enjoy the culture at First Dakota. It is a positive and supportive environment where employees are valued. There are always fun activities, thoughtful treats, and little surprises that remind us we are appreciated. It is great to be part of a workplace that cares about both the work we do and the people who do it. Catherine S. employed since 2021

My favorite memory is from when I first started, a co-worker and I decorated the office of someone who had been out of the office for a couple of days. We had it decked out, and boy, was he surprised when he got back! He laughed and we still talk about it! Also, when we have a CD special it is fun doing lots of CDs for customers like we did back when I first started. It is so nice to see lots of regular and new customers come in. Cheryl M. employed since 2011

My advice to a potential new hire is if you want to work for someone who values you as an individual, chose First Dakota. Charlie S. employed since 2023

Join Our Team

We understand that the heart of our community is the people we serve, and we’re looking for individuals who share our vision. Our customers’ financial choices are driven by their dreams for the future—help us turn those dreams into reality! If you are committed to serving others and doing so with excellence, we want you on our team. Explore our open positions today.

Location: Sioux Falls (Downtown), SD

First Dakota is hiring a Data Engineer to join our team! This person is responsible for developing, operating, and continuously improving the Bank’s enterprise data platform. This position designs and maintains scalable ETL/ELT pipelines, distributed data processing solutions, and curated data products utilizing Microsoft Fabric, Python, SQL, Spark, Power BI, DBT, Azure services, and related technologies. The role supports analytics, operational decision-making, regulatory reporting, and data governance initiatives across the Bank. Experience with Jack Henry and other banking software platforms is strongly desired. This position is open to any First Dakota location. Hours include Monday-Friday 8-5.

Duties

• Design, develop, test, and maintain data pipelines to extract, transform, and load data into Microsoft Fabric.
• Connect and integrate data from core banking systems, third-party applications, APIs, files, and cloud-based platforms.
• Develop batch and near real-time data processing solutions using SQL, Python, Spark, and related technologies.
• Build and maintain reusable ingestion, transformation, orchestration, and monitoring frameworks.
• Transform and enrich data through business rules, auditing, validation, and data quality controls.
• Create and maintain fact, dimension, and analytical models to support Power BI and enterprise reporting.
• Implement monitoring, alerting, error handling, and operational documentation for data platform processes.
• Support workflow automation and orchestration initiatives utilizing Fabric, SharePoint, Power Apps, Power Automate, and related technologies as appropriate.
• Partner with data analysts, business stakeholders, and technology teams to deliver reliable and scalable data products.
• Participate in data governance, security, metadata management, and documentation efforts.
• Troubleshoot production issues and optimize solutions for performance, reliability, and maintainability.
• Other duties as assigned.

Qualifications

Attributes include a positive attitude and good work ethic. The ability to process a variety of tasks accurately and efficiently, the capability to maintain strict confidentiality, attention to detail and comply with all Bank policies and procedures. Communicate effectively with various types of clientele, co-workers and departments to resolve an assortment of needs. Strong organizational skills and the ability to work well in a team environment. Punctuality is a must.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements are representative of the knowledge, skills, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education/Experience

Bachelor’s degree in computer science, Information Systems, Data Engineering, or related field, or equivalent work experience.

3+ years of experience as a Data Engineer, ETL Developer, Data Warehouse Developer, or similar role.

Expert proficiency in:

• SQL
• ETL/ELT Processes
• Data Integration

Deep experience with one or more of:

• Microsoft Fabric
• Databricks
• Snowflake

Professional experience in:

• Python
• Spark or distributed data processing platforms
• Git and source control concepts
• CI/CD and DevOps practices

Experience with one or more of:

• dbt
• Kafka or streaming technologies
• REST APIs and application integrations

Strong understanding of:

• Data quality and testing practices
• Security and access controls
• Data lineage and documentation

Experience with financial institutions, banking systems, or Jack Henry platforms preferred.

Office: The work environment of this job includes interacting with others in an office setting, and the noise level is usually moderate.

Physical Demands

Light: The physical demands of this job include bending, sitting, and occasionally lifting up to 10 pounds with or without reasonable accommodation.

Requirements of All Employees

To perform the job successfully, an individual should demonstrate the following:

Adaptability - Adapts to changes in the work environment

Attendance/Punctuality - Is consistently at work and on time; Arrives at meetings and appointments on time

Career Apparel - Adheres to the Career Apparel policy; Demonstrates professional appearance during Bank hours or at after-hours Bank functions

Customer Service - Responds promptly to customer needs including requests for service and assistance; Provide courteous, personal attention to promote ongoing relationship servicing with customers

Dependability - Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Completes tasks on time or notifies appropriate person with an alternate plan

Design - Demonstrates attention to detail

Initiative - Looks for and takes advantage of opportunities; Asks for and offers help when needed

Innovation - Shares suggestions for improving work

Interpersonal - Maintains confidentiality; Remains open to others' ideas and tries new things

Judgment - Exhibits sound and accurate judgment

Motivation - Measures self against standard of excellence

Communication - Listens and gets clarification; Responds well to questions; Participates in meetings; Writes clearly and informatively; Able to read and interpret written information

Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports and upholds organizational goals and values

Planning/Organizing - Uses time efficiently; Completes work in a timely manner

Problem Solving - Identifies and resolves problems in a timely manner

Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration; Accepts responsibility for own actions; Inspires the trust of others; Works with integrity and ethically

Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance; Monitors own work to ensure quality

Safety/Security - Observes safety and security procedures; Reports potentially unsafe conditions; Uses equipment and materials properly

Team Work - Gives and welcomes feedback; Contributes to building a positive team spirit

Technical Skills – Understands basic computer software programs; Strives to continuously build knowledge and skills; Shares expertise with others

Questions? Please contact our Human Resources Department.

We uphold our core values and mission for our employees, customers, and shareholders. We are an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, disability or protected veteran status. EEO is the law.

Please be aware email is not a secure method of communication. Do not use email to send us confidential or sensitive information. If you would like to send us a resume, please attach it within our application.