Senior Database Architect: Scalable, Auditable Data Solutions

RSM US LLP; Kansas City (MO); On-site; USD 63,000 - 94,000; Full time

Job summary

RSM US LLP is seeking a Senior Database Developer for a temporary engagement to redesign and modernize a legacy financial services system. The role emphasizes scalable data models, auditable structures, and secure data governance within an Agile team.

You will analyze current architecture, translate complex logic into robust solutions, and mentor teammates while collaborating with product owners and stakeholders to deliver high-performance databases.

Qualifications

• 8-10 years of experience in SQL Server development/DBA and data modeling for large-scale environments.

Responsibilities

• Analyze existing database architecture and decipher complex logic to design scalable data models.
• Collaborate with stakeholders to translate requirements into robust database solutions.
• Design and develop new data models, schemas, and database objects.
• Build and optimize tables, stored procedures, and controls for data integrity and auditability.
• Implements data governance and ensures regulatory and internal security compliance.
• Support iterative development and adapt structures to evolving requirements.
• Mentor team members on data modeling best practices.
• Collaborate in an Agile environment using Jira and Confluence.

Skills

SQL Server development

Data modeling

ETL/SSIS

Data migration

SQL performance tuning

Regulatory compliance

Analytical thinking

Stakeholder communication

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

SSRS

Tableau

Snowflake

Databricks

.NET/C#

ASP.NET/Web API

Job description

RSM US LLP is seeking a Senior Database Developer for a temporary engagement to redesign and modernize a legacy financial services system. The role emphasizes scalable data models, auditable structures, and secure data governance within an Agile team.

You will analyze current architecture, translate complex logic into robust solutions, and mentor teammates while collaborating with product owners and stakeholders to deliver high-performance databases.