Senior Database Architect - Data Modeling & Compliance

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

Job summary

RSM US LLP in Philadelphia is seeking a Senior Database Developer for a temporary engagement to lead a critical modernization of a legacy system for a financial services client. This role focuses on analyzing existing database architecture, translating complex business logic into scalable solutions, and building high-performance, compliant data models.

The ideal candidate will mentor team members, implement data governance, and collaborate in an Agile environment using Jira and Confluence to

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).
• Data analysis, data quality, and data modeling.
• Writing and optimizing complex stored procedures (SPROCs).
• Experience implementing data controls, security, and regulatory compliance standards.

Responsibilities

• Analyze existing database architecture, decipher complex logic, and assess current data models.
• Partner with business 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 to ensure data integrity and auditability.
• Implement data governance controls and ensure regulatory compliance.
• Support iterative development and refine database structures as requirements evolve.
• Provide mentorship to team members on data modeling best practices.
• Collaborate in an Agile environment using Jira and Confluence.

Skills

SQL Server

Data modeling

Data migration

Data analysis

Data security

Education

Bachelor's degree in CS/IT or related field

Tools

SSIS

Tableau

SSRS

Snowflake

Databricks

C#

ASP.NET

Job description

RSM US LLP in Philadelphia is seeking a Senior Database Developer for a temporary engagement to lead a critical modernization of a legacy system for a financial services client. This role focuses on analyzing existing database architecture, translating complex business logic into scalable solutions, and building high-performance, compliant data models.

The ideal candidate will mentor team members, implement data governance, and collaborate in an Agile environment using Jira and Confluence to