Data Engineer
Designs, builds, and operates First Dakota National Bank's enterprise data platform, maintaining scalable ETL/ELT pipelines and curated data products with Microsoft Fabric, Python, SQL, Spark, dbt, and Power BI to support analytics, regulatory reporting, and data governance. Onsite, Monday-Friday 8-5, open to any First Dakota location.
- Compensation
- Not disclosed
- Location
- Sioux Falls (Downtown), SD
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 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
- Expert proficiency in ETL/ELT processes
- Expert proficiency in 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
- Professional experience in Spark or distributed data processing platforms
- Professional experience with Git and source control concepts
- Professional experience with CI/CD and DevOps practices
- Experience with one or more of: dbt, Azure Data Factory, Kafka or streaming technologies, 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
- Ability to maintain strict confidentiality and comply with Bank policies; attention to detail, strong organizational and communication skills, punctuality
Nice to have
- Experience with financial institutions, banking systems, or Jack Henry platforms
Full description
Data Engineer - Any First Dakota Location
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.