Senior Data Engineer - Reporting Automation & AI

Description

This is a net-new hybrid role in Downtown Chicago, reporting to the risk-reporting function at the company.

You will build automated reporting solutions that make risk reporting more efficient, accurate and scalable.

You will be the technical link between raw risk data and the timely, accurate reports that stakeholders depend on.

Early on, you will learn the existing code, risk data and reporting processes, then help move work off SAS and onto Anaconda and Python while making reporting workflows more reliable and automated.

The team is responsible for risk systems that support data integrity, user access and process controls.

Responsibilities

• Design, build and maintain automated reporting solutions that make risk-reporting processes more efficient, accurate and scalable.
• Build and connect AI-enabled workflows that prepare and validate data and generate reports.
• Write and maintain Python and Shell applications and scripts that automate reporting, monitor system health and improve operational reliability.
• Turn manual and legacy reporting into scalable automated pipelines, including migrating SAS processes to Anaconda and Python.
• Design optimized data marts and star schemas for Power BI.
• Write and tune SQL queries that produce accurate, high-performing risk outputs.
• Work with data-reporting teams so data structures and outputs support clear reporting and visualization.
• Explain technical options, tradeoffs and solutions clearly to technical stakeholders.
• Provide production and end-user support and governance for the risk technical platform and its controls.
• Plan, maintain and manage change for risk system strategies, process changes, system parameter changes, production schedules and operational tasks, including overseeing parameter changes.
• Work with stakeholders to resolve issues and deliver solutions that keep services running and effective.
• Advise the assigned business group as a trusted advisor, and influence and negotiate to meet business goals.
• Research requirements and best practices, and recommend enhancements.
• Support planning and delivery of strategic initiatives across intake, design, development, testing, sign-off, production and post-implementation.
• Support the reconciliation and provisioning of data between core risk systems.
• Monitor the risk system infrastructure, applications and transactions, and work with technology providers to investigate issues, find root causes and plan fixes.
• Verify and monitor production changes against guidelines and policies.
• Track metrics and milestones, escalate issues when needed, and keep stakeholders aligned.
• Represent the risk systems management function in internal and external regulatory audits or examinations.
• Coordinate database management and ensure data integration follows data governance standards.
• Build change management plans and lead or take part in readiness, execution and sustainment work.
• Maintain system and process documentation, controls and knowledge assets.
• Apply the company's Risk Management Framework in your work, in line with its risk culture and approved risk appetite, and follow applicable policies, laws and regulations.

Requirements

• 5+ years of hands-on professional experience in reporting automation or data development, including advanced SQL with complex views, stored procedures and performance tuning.
• 3+ years of experience using Python and Shell scripting to automate reporting workflows and build supporting applications.
• 3+ years of experience integrating AI functionality into existing processes through APIs or comparable AI-enabled workflow tools.
• 2 years of experience with Power BI and Power Query.
• 2 years of experience using Git for version control.
• 4+ years of experience with dimensional modeling and modern data-warehouse concepts.
• Experience modernizing legacy reporting or data processes. SAS-to-Python migration experience is strongly preferred.
• You can work independently, take initiative and manage technical work with limited day-to-day direction.
• You communicate well and work effectively with data-reporting teams, explaining technical ideas concisely.
• Typically 5-7 years of relevant experience and a post-secondary degree in a related field, or an equivalent mix of education and experience.
• In-depth knowledge of risk system management concepts and applications.
• In-depth knowledge of and experience with risk policy frameworks and quality control or testing frameworks.
• Deep technical proficiency built through extensive education and business experience.
• In-depth skills in verbal and written communication, collaboration, analytical problem solving, influence and data-driven decision making.

Conditions

Hybrid role based in Downtown Chicago at 320 S Canal Street, working from the Chicago office 3 days per week, with Tuesday as a required in-office day.

Salaried position with a pay range of $75,000.00 - $160,000.00.

The range is the company's pay range and pay type for this role.

Actual pay depends on factors such as location, skills, experience, education and qualifications, and may include a commission structure. For commission roles, the listed salary is the company's expected first-year target. Part-time pay is pro-rated by hours regularly worked.

Application deadline: 11/12/2026.

Benefits

• Total compensation may include performance-based incentives, discretionary bonuses and other perks and rewards.
• Health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans.
• Training, coaching, manager support and networking opportunities to build your experience and skills.