Senior Database Architect — Secure, Scalable FinServ Data

RSM US LLP; Cleveland (OH); On-site; USD 63,000 - 94,000; Part time

Job summary

RSM US LLP is seeking an experienced Senior Database Developer for a temporary engagement to redesign and modernize a legacy system for a financial services client. The role focuses on analyzing existing architecture, translating business logic into scalable data models, and delivering auditable, secure data structures.

The ideal candidate has 8-10 years in SQL Server development/DBA, data modeling, and large-scale environments, with expertise in SSIS, data governance, and regulatory compliance.

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).
• Data migration, ETL processes, and integration tools (e.g., SSIS).
• Data analysis, data quality, and data modeling.
• Writing and optimizing complex stored procedures (SPROCs).
• SQL database testing and automation techniques.

Responsibilities

• Analyze existing database architecture, decipher complex logic, and assess current data models.
• Partner with stakeholders to translate requirements into scalable 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.
• Implement data governance controls and ensure regulatory compliance.

Skills

SQL Server

Data modeling

ETL/(SSIS)

Stored procedures

Data governance

Security controls

Data analysis

Automation

Education

Bachelor's degree in CS/IT

Tools

SSIS

Jira

Confluence

Job description

RSM US LLP is seeking an experienced Senior Database Developer for a temporary engagement to redesign and modernize a legacy system for a financial services client. The role focuses on analyzing existing architecture, translating business logic into scalable data models, and delivering auditable, secure data structures.

The ideal candidate has 8-10 years in SQL Server development/DBA, data modeling, and large-scale environments, with expertise in SSIS, data governance, and regulatory compliance.