Senior Database Developer — Modernize Critical Data Systems

RSM US LLP; Chicago (IL); On-site; USD 131,809,000 - 194,848,000; Full time

Job summary

RSM US LLP is seeking an experienced Senior Database Developer for a temporary engagement to lead a critical modernization project for a financial services client. You will analyze existing database architecture, translate complex business logic into scalable solutions, and build auditable data models.

The ideal candidate has 8–10 years of SQL Server development/DBA experience, strong data migration, ETL, and governance skills, and can mentor teammates in an Agile environment using Jira and

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 8-10 years of experience in SQL Server development/DBA, data modeling, and large-scale database environments (financial services preferred).
• Strong expertise in data migration, ETL processes, and integration tools (e.g., SSIS).
• Experience with data analysis, data quality, and data modeling.
• Proven experience developing high-performance, auditable database solutions.
• Experience implementing data controls, security, and regulatory compliance standards.

Responsibilities

• Analyze existing database architecture, decipher complex logic, and assess current data models.
• Partner with stakeholders to gather requirements and translate them into scalable database solutions.
• Design and develop new data models, schemas, and database objects aligned with business needs and performance standards.
• Build and optimize tables, stored procedures (SPROCs), and controls to ensure data integrity and auditability.
• Implement data governance controls and ensure compliance with regulatory and internal security requirements.
• Support iterative development in an Agile environment using Jira and Confluence.
• Provide guidance and mentorship to team members on data modeling best practices.

Skills

SQL Server

Data modeling

Data migration

ETL

SSIS

Data analysis

Data quality

Security controls

Auditable data

Regulatory compliance

Stored procedures

SPROCs

SQL testing

Tableau

SSRS

Snowflake

Databricks

Jira

Confluence

.NET

C#

ASP.NET

Web API

Education

Bachelor's degree in Computer Science/Information Technology or related field

Tools

SSIS

SSRS

Tableau

Snowflake

Databricks

Jira

Confluence

Microsoft .NET

C#

ASP.NET

Web API

Job description

RSM US LLP is seeking an experienced Senior Database Developer for a temporary engagement to lead a critical modernization project for a financial services client. You will analyze existing database architecture, translate complex business logic into scalable solutions, and build auditable data models.

The ideal candidate has 8–10 years of SQL Server development/DBA experience, strong data migration, ETL, and governance skills, and can mentor teammates in an Agile environment using Jira and