Senior Database Architect: High-Performance & Secure Data

RSM US LLP; Dallas (TX); On-site; USD 63,000 - 94,000; Full 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. You will analyze existing architecture, translate complex business logic into scalable data models, and build auditable, secure data structures to meet evolving needs.

You will lead data modeling efforts, collaborate with stakeholders, and work in an Agile team using Jira/Confluence to deliver high-performance databases with strong

Qualifications

• Bachelor's degree in CS/IT or related field.
• 8–10 years in SQL Server development/DBA and data modeling.
• Experience with ETL (SSIS) and large-scale databases in financial services preferred.
• Proven ability to develop high-performance, auditable database solutions.
• Experience implementing data controls, security, and regulatory compliance standards.

Responsibilities

• Analyze existing database architecture and decipher complex logic.
• 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 performance.
• Implement data governance controls and regulatory compliance requirements.
• Support iterative development and refine structures as requirements evolve.
• Provide mentorship on data modeling best practices.
• Collaborate in an Agile environment using Jira and Confluence.

Skills

SQL Server development

Data migration

ETL

Data analysis

Data quality

Data modeling

Stored procedures

SQL testing & automation

Data security

Regulatory compliance

Education

Bachelor's degree in Computer Science / IT or related field

Tools

SSIS

SSRS

Tableau

Snowflake

Databricks

NET stack

C#

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. You will analyze existing architecture, translate complex business logic into scalable data models, and build auditable, secure data structures to meet evolving needs.

You will lead data modeling efforts, collaborate with stakeholders, and work in an Agile team using Jira/Confluence to deliver high-performance databases with strong