Senior Database Architect: SQL, ETL & Governance

RSM US LLP; Boston (MA); On-site; USD 120,000 - 160,000; Full time

Job summary

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

Responsibilities include designing new models, building SPROCs, ensuring data quality and governance, and mentoring team members in an Agile setting with Jira and

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 8–10 years in SQL Server development/DBA, data modeling, and large-scale database environments (financial services preferred).
• Strong in data migration, ETL processes, and integration tools (e.g., SSIS).
• Proven experience building high-performance, auditable database solutions.
• 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 gather and translate requirements into scalable database solutions.
• Design and develop new data models, schemas, and database objects aligned with business needs and performance standards.
• Build and optimize tables, stored procedures (SPROCs), and controls to ensure data integrity, performance, and auditability.
• Implement data governance controls and ensure compliance with regulatory and internal security requirements.
• Support iterative development, refining database structures in response to evolving requirements.
• Provide guidance and mentorship to team members on data modeling best practices.
• Collaborate cross-functionally within an Agile environment using Jira and Confluence.

Skills

Data migration

ETL processes

SQL Server

Data modeling

Stored procedures

Data quality

Automation testing

Regulatory compliance

Education

Bachelor’s degree in Computer Science / IT

Tools

SSIS

SSRS

Databricks

Snowflake

Job description

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

Responsibilities include designing new models, building SPROCs, ensuring data quality and governance, and mentoring team members in an Agile setting with Jira and