Data Engineer

First Dakota National Bank is hiring a Data Engineer (any First Dakota location) to develop, operate, and continuously improve the Bank’s enterprise data platform. The role focuses on designing and maintaining scalable ETL/ELT pipelines and data products that support analytics, reporting, and data governance.

Key Responsibilities

• Design, develop, test, and maintain data pipelines that 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 processing solutions using SQL, Python, Spark, and related technologies.
• Create and maintain reusable frameworks for ingestion, transformation, orchestration, and monitoring.
• Transform and enrich data using business rules, auditing, validation, and data quality controls.
• Build 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 using 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 for performance, reliability, and maintainability.
• Perform other duties as assigned.

Required Qualifications

• Bachelor’s degree in computer science, Information Systems, Data Engineering, or a 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.
• Expert proficiency in ETL/ELT processes.
• Expert proficiency in data integration.
• Expert proficiency in dimensional modeling (Kimball / star schema).
• Deep experience with Microsoft Fabric.
• Deep experience with one or more of: Databricks, Snowflake, Azure Data Services.
• Professional experience in Python.
• Professional experience in Spark or distributed data processing platforms.
• Professional experience in Git and source control concepts.
• Professional experience in CI/CD and DevOps practices.
• Experience with one or more of dbt.
• Experience with one or more of Azure Data Factory.
• Experience with one or more of Kafka or streaming technologies.
• Experience with one or more of REST APIs and application integrations.
• Strong understanding of data quality and testing practices.
• Strong understanding of enterprise data governance.
• Strong understanding of security and access controls.
• Strong understanding of data lineage and documentation.
• Experience with financial institutions, banking systems, or Jack Henry platforms preferred.
• Positive attitude and good work ethic.
• Ability to process a variety of tasks accurately and efficiently.
• Capability to maintain strict confidentiality.
• Attention to detail and ability to comply with all Bank policies and procedures.
• Effective communication with clientele, co-workers, and departments to resolve a range of needs.
• Strong organizational skills and ability to work well in a team environment.
• Punctuality is a must.

Technologies

• Microsoft Fabric
• Python
• SQL
• Spark
• Power BI
• dbt
• Azure services
• SharePoint
• Power Apps
• Power Automate
• Databricks
• Snowflake
• Azure Data Services
• Git
• CI/CD
• DevOps
• Azure Data Factory
• Kafka
• REST APIs
• Jack Henry

Work Location and Environment

Sioux Falls, SD (onsite). The work environment includes interacting with others in an office setting, with usually moderate noise levels.

Physical Demands

Light. Job tasks may involve bending, sitting, and occasionally lifting up to 10 pounds with or without reasonable accommodation.

All Employee Requirements

• Adaptability
• Attendance and punctuality
• Career apparel and professional appearance
• Customer service
• Dependability
• Design
• Initiative
• Innovation
• Interpersonal behavior and confidentiality
• Judgment
• Motivation
• Communication
• Organizational support
• Planning and organizing
• Problem solving
• Professionalism
• Quality
• Safety and security
• Team work
• Technical skills