Senior Data Engineer: AI-Driven Reporting & Automation

Bank N.A.; Chicago (IL); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Bank N.A. is seeking a Senior Data Engineer - Reporting Automation & AI to design, build, and operate automated reporting solutions that enhance risk reporting.

You will develop AI-enabled workflows, Python and Shell apps, and modernize legacy processes for scalable, reliable outputs. The role focuses on migrating SAS-based processes to Python/Anaconda, creating optimized data marts for Power BI, and partnering with reporting teams to deliver accurate, timely insights.

Qualifications

• 5+ years in reporting automation or data development.
• 3+ years Python and Shell scripting.
• 3+ years integrating AI via APIs.
• 2+ years Power BI and Power Query.
• 4+ years dimensional modeling and data-warehouse concepts.
• SAS-to-Python migration experience is preferred.

Responsibilities

• Design, develop, and maintain automated reporting solutions for risk data.
• Build AI-enabled workflows to streamline data prep, validation, and reporting.
• Develop Python and Shell applications to support automation and monitoring.
• Modernize legacy reporting into scalable pipelines; migrate SAS to Python.
• Design data marts and star schemas for Power BI consumption.
• Tune SQL queries for accurate, high-performing outputs.
• Collaborate with data-reporting teams and communicate tradeoffs clearly.

Skills

Advanced SQL

Python

Shell scripting

Power BI

Power Query

Git

Dimensional modeling

SAS migration

Data automation

Stakeholder comms

Education

Bachelor's degree

MS in Data Science

Tools

Anaconda

SQL Server

Airflow

API integration

Job description

Bank N.A. is seeking a Senior Data Engineer - Reporting Automation & AI to design, build, and operate automated reporting solutions that enhance risk reporting.

You will develop AI-enabled workflows, Python and Shell apps, and modernize legacy processes for scalable, reliable outputs. The role focuses on migrating SAS-based processes to Python/Anaconda, creating optimized data marts for Power BI, and partnering with reporting teams to deliver accurate, timely insights.