Senior Database Developer — Modernization Contract

RSM US LLP; Center Square (PA); 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 lead a legacy system modernization for a financial services client. You will analyze current architecture, translate complex logic into scalable data models, and deliver auditable, secure data structures.

Responsibilities include designing data models, developing SPROCs, implementing governance, and mentoring teammates within an Agile setting using Jira/Confluence. Requires 8–10 years in SQL Server and data modeling.

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).
• Experience with data migration, ETL processes, and integration tools (e.g., SSIS).
• Experience implementing data controls, security, and regulatory compliance standards.

Responsibilities

• Analyze existing database architecture and data models.
• Collaborate 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 (SPROCs), and controls for data integrity and performance.
• Implement data governance controls and ensure regulatory compliance.
• Support iterative development in an Agile environment.
• Mentor team members on data modeling best practices.
• Collaborate across teams using Jira and Confluence.

Skills

SQL Server

Data modeling

ETL

Data migration

Data analysis

SQL optimization

Security controls

Education

Bachelor's degree in Computer Science/IT or related

Tools

SSRS

Tableau

Job description

RSM US LLP is seeking a Senior Database Developer for a temporary engagement to lead a legacy system modernization for a financial services client. You will analyze current architecture, translate complex logic into scalable data models, and deliver auditable, secure data structures.

Responsibilities include designing data models, developing SPROCs, implementing governance, and mentoring teammates within an Agile setting using Jira/Confluence. Requires 8–10 years in SQL Server and data modeling.