Senior SQL Data Architect – Modeling & Compliance

RSM US LLP; Atlanta (GA); On-site; USD 120,000 - 190,000; Full time

Job summary

RSM US LLP in Atlanta seeks a Senior Database Developer for a temporary engagement to lead a legacy modernization initiative for a financial services client. You will analyze current database architecture, translate complex business logic into scalable data models, and build robust, auditable data structures.

The role requires 8–10 years of SQL Server experience, expertise in ETL (SSIS), data governance, and strong collaboration in an Agile environment using Jira/Confluence; experience with

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 8-10 years of experience in SQL Server development, data modeling, and large-scale database environments (financial services preferred).
• Strong expertise in data migration, ETL processes, and integration tools (e.g., SSIS).
• Experience with data governance, security controls, and regulatory/compliance standards.
• Experience with data controls, security, and regulatory compliance.

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 (SPROCs), and controls for data integrity and performance.
• Implement data governance controls and ensure regulatory compliance.
• Collaborate in an Agile environment using Jira and Confluence.
• Provide guidance and mentorship to team members on data modeling best practices.
• Collaborate cross-functionally within an Agile environment using Jira and Confluence.

Skills

SQL Server development

Data modeling

ETL processes

Data migration

Data governance

Security controls

Auditable data structures

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

SSIS

SSRS

Tableau

Snowflake

Databricks

C#/.NET

Confluence

Job description

RSM US LLP in Atlanta seeks a Senior Database Developer for a temporary engagement to lead a legacy modernization initiative for a financial services client. You will analyze current database architecture, translate complex business logic into scalable data models, and build robust, auditable data structures.

The role requires 8–10 years of SQL Server experience, expertise in ETL (SSIS), data governance, and strong collaboration in an Agile environment using Jira/Confluence; experience with