Data Engineer

First Dakota National Bank is seeking a Data Engineer (any First Dakota location) to help develop, run, and continuously improve the Bank’s enterprise data platform. In this onsite role, you will design and maintain scalable ETL/ELT pipelines and data products using Microsoft Fabric and related technologies to support analytics, reporting, and data governance.

What you’ll do

• 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.
• Build batch and near real-time processing solutions using SQL, Python, Spark, and related technologies.
• Create reusable frameworks for ingestion, transformation, orchestration, and monitoring.
• Transform and enrich data using business rules, auditing, validation, and data quality controls.
• Develop 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.
• Collaborate with data analysts, business stakeholders, and technology teams to deliver reliable, 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.

Requirements

• 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, ETL/ELT processes, and data integration.
• Expert proficiency in dimensional modeling (Kimball / Star Schema).
• Deep experience with one or more of: Microsoft Fabric, Databricks, Snowflake, Azure Data Services.
• Professional experience in Python and Spark or other distributed data processing platforms.
• Professional experience with Git and source control concepts, plus CI/CD and DevOps practices.
• Experience with one or more of: dbt, Azure Data Factory, Kafka or streaming technologies, and REST APIs and application integrations.
• Strong understanding of data quality and testing practices, enterprise data governance, security and access controls, and data lineage and documentation.
• Experience with financial institutions, banking systems, or Jack Henry platforms is preferred.
• Demonstrated positive attitude and good work ethic, with strong attention to detail and ability to maintain strict confidentiality.
• Ability to process tasks accurately and efficiently, comply with Bank policies and procedures, and communicate effectively with clientele, coworkers, and departments.
• Strong organizational skills and ability to work well in a team environment; punctuality is a must.

Location and work environment

• Location: Sioux Falls, SD (onsite)
• Office environment: moderate noise level and interaction with others in an office setting

Technologies you’ll work with

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

Physical demands

• Light physical demands, including bending and sitting; occasionally lifting up to 10 pounds with or without reasonable accommodation.

Requirements of all employees

• Adaptability
• Attendance and punctuality
• Career apparel compliance
• Customer service
• Dependability
• Design and attention to detail
• Initiative, innovation, and interpersonal respect
• Judgment, motivation, communication, and organization support
• Planning and problem solving
• Professionalism, quality, and safety/security procedures
• Team work
• Technical skills and ongoing knowledge building