Data Engineer - Billings

Make Choteau Home; Billings (MT); On-site; USD 90,000 - 130,000; Full time

Job summary

Make Choteau Home is seeking a Data Engineer to support the bank's enterprise data environment by building and maintaining data pipelines, preparing data for reporting, and improving data quality. The role collaborates with Technology, Operations, and business teams to ensure secure, reliable data flows for analytics.

The position emphasizes hands-on development, data governance enablement, and supporting AI initiatives through data readiness and platform improvements.

Qualifications

• 2–4 years of experience in data engineering, BI, or data warehousing.
• Strong SQL skills.
• Experience with ETL/ELT processes.
• Experience with Power BI or similar.
• Familiarity with relational databases and data modeling.
• Experience with Microsoft Fabric or Azure Data Factory preferred.
• Ability to troubleshoot data issues and document findings.

Responsibilities

• Build and maintain data pipelines for reporting and analytics.
• Support data ingestion from core banking and related systems.
• Write, test, and maintain SQL queries, stored procedures, and scripts.
• Document data flows, source data, and transformation logic.
• Prepare trusted datasets for Power BI dashboards, reports, and management reporting.

Skills

SQL

ETL/ELT

Data modeling

Power BI

Python scripting

Microsoft Fabric/Azure Data Factory

Troubleshooting data issues

Relational databases

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related technical discipline

Tools

Power BI

Microsoft Fabric

Azure Data Factory

Job description

Position Summary

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.

Data Engineer Responsibilities

Data Pipeline Development

• 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.

Data Platform Support

• 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.

Banking Systems Integration

• 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.

Data Governance Enablement

• 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.

Analytics Platform Support

• 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.

Team Collaboration

• 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.

Qualifications

Technical Qualifications

• 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.
• Python, PowerShell, or similar scripting experience preferred.
• Microsoft Fabric or Azure Data Factory experience preferred.
• Ability to troubleshoot data issues and document findings clearly.

Data and Banking Knowledge

• Understanding of data warehouse design and reporting structures.
• Familiarity with dimensional modeling, data quality, data lineage, and metadata concepts.
• Core banking systems experience preferred.
• Regulatory reporting experience preferred.
• Financial institution data environment experience preferred.
• Banking operations process knowledge preferred.

Success Measures

• Reliable data pipelines and scheduled data processing jobs.
• Improved data quality and reduced reporting exceptions.
• Clear documentation of data sources, transformations, and business logic.
• Reduced manual effort in recurring management reporting.
• Continued growth in banking data knowledge and platform capabilities.

For full description, which includes physical mental demands please see attachment.