DATA ENGINEER

Stockman Bank of Montana•Billings, MT

About The Position

The Data Engineer supports the Bank's enterprise data environment by building and maintaining data pipelines, preparing data for reporting and analytics, and improving data quality and reliability. This role works closely with Technology, Operations, and business teams to move data from banking systems into secure, reliable, and usable reporting structures. The position is hands-on and execution-focused, supporting data warehousing, reporting, analytics, governance, and emerging artificial intelligence initiatives. The Data Engineer is expected to possess strong analytical and problem-solving skills, attention to detail, and the ability to manage multiple priorities while delivering accurate and dependable data solutions.

Requirements

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related technical discipline, or an equivalent combination of education and work experience.
Two to four years of experience in data engineering, business intelligence, database development, reporting, or data warehouse support.
Strong SQL skills.
Experience building or supporting ETL/ELT processes.
Working knowledge of relational databases and data modeling concepts.
Experience with Power BI or similar reporting platforms.
Ability to troubleshoot data issues and document findings clearly.
Understanding of data warehouse design and reporting structures.
Familiarity with dimensional modeling, data quality, data lineage, and metadata concepts.

Nice To Haves

Python, PowerShell, or similar scripting experience preferred.
Microsoft Fabric or Azure Data Factory experience preferred.
Core banking systems experience preferred.
Regulatory reporting experience preferred.
Financial institution data environment experience preferred.
Banking operations process knowledge preferred.

Responsibilities

Build and maintain data pipelines for reporting and analytics.
Support data ingestion from core banking and related business systems.
Write, test, and maintain SQL queries, stored procedures, and scripts.
Document data flows, source data, and transformation logic.
Support the Bank's data warehouse, lakehouse, and reporting data structures.
Assist with Microsoft Fabric, Power BI, and related data platform initiatives.
Monitor scheduled jobs and resolve data processing issues.
Improve performance, reliability, and repeatability of production data processes.
Work with data from core banking, digital banking, credit card, mortgage, financial, and third-party systems.
Help define secure and maintainable data feeds.
Coordinate with system owners, vendors, and technology teams to investigate and resolve data issues.
Apply data quality controls and resolve data exceptions.
Maintain metadata, data definitions, and source documentation.
Support data governance efforts and regulatory requirements.
Ensure adherence to security, privacy, and data management standards.
Prepare trusted datasets for Power BI dashboards, reports, and management reporting.
Partner with business teams to understand reporting requirements and data needs.
Automate recurring reporting processes and reduce manual data preparation.
Support future analytics, machine learning, and AI initiatives through improved data readiness.
Work closely with Technology, Operations, and business teams.
Communicate technical issues in clear and practical business terms.
Follow established standards for change management, security, and documentation.
Continue developing expertise in data architecture, governance, and cloud-based data platforms.