Senior Database Developer

RSM US LLP; New York (NY); On-site; USD 63,000 - 94,000; Full time

Benefits offered by this job

Flexible schedule

Competitive benefits

Job summary

RSM US LLP in New York seeks an experienced 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 data models, and building high-performance, auditable data structures.

You will design data models, develop new database objects, and implement governance and security controls.

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.
• Proven ability to design high-performance, auditable database solutions.

Responsibilities

• Analyze existing database architecture and decipher complex logic.
• Collaborate with stakeholders to gather requirements and translate 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 standards.
• Support iterative development in an Agile environment with Jira/Confluence.
• Provide mentorship on data modeling best practices.

Skills

Analytical thinking

Communication

Stakeholder mgmt

Time management

Agile teamwork

Education

Bachelor's degree in CS/IT

Tools

Jira

Confluence

SSIS

Tableau

SSRS

Snowflake

Databricks

C#/.NET

Job description

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, culture and talent experience and our ability to be compelling to our clients. You'll find an environment that inspires and empowers you to thrive both personally and professionally. There's no one like you and that's why there's nowhere like RSM.

Senior Database Developer

Summary: We are seeking an experienced Senior Database Developer for a temporary engagement to lead a critical initiative involving the redesign and modernization of a legacy system for a financial services client. This role will focus on analyzing existing database architecture, translating complex business logic into scalable solutions, and building high-performance, compliant data models. The ideal candidate will play a key role in delivering robust, auditable, and secure data structures aligned with evolving business needs.

Key Responsibilities:

• Analyze existing database architecture, decipher complex logic, and assess current data models.
• Partner with business stakeholders and product owners 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 tools such as Jira and Confluence.

Required 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)
  • SQL database testing and automation techniques
• Proven experience developing high-performance, auditable database solutions.
• Experience implementing data controls, security, and regulatory compliance standards.

Preferred / Nice to Have:

• Experience with reporting and visualization tools (SSRS, Tableau)
• Exposure to cloud data platforms (Snowflake, Databricks)
• Familiarity with Microsoft full-stack technologies (.NET, C#, ASP.NET, Web API)
• Experience working within DevSecOps frameworks

Core Skills & Attributes:

• Strong analytical and problem-solving skills
• Excellent communication and stakeholder management abilities
• Highly organized with the ability to manage competing priorities
• Experience working in fast-paced, deadline-driven environments
• Collaborative mindset with Agile team experience

At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life's demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits.

All applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender; sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the US uniformed service; US Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable federal, state or local law.

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please call us at 800-274-3978 or send us an email at [e-mail].

RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying, excluding internships, you may be eligible for hire as an experienced associate.

RSM will consider for employment qualified applicants with arrest or conviction records. For those living in California or applying to a position in California, please click here for additional information.

At RSM, an employee's pay at any point in their career is intended to reflect their experiences, performance, and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including, but not limited to, education, skills, work experience, certifications, location, etc. As such, pay for the successful candidate(s) could fall anywhere within the stated range.

Compensation Range: $46 - $68 per hour