Senior Database Developer

RSM US LLP; Kansas City (MO); 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 redesign and modernize a legacy financial services system. The role emphasizes scalable data models, auditable structures, and secure data governance within an Agile team.

You will analyze current architecture, translate complex logic into robust solutions, and mentor teammates while collaborating with product owners and stakeholders to deliver high-performance databases.

Qualifications

• 8-10 years of experience in SQL Server development/DBA and data modeling for large-scale environments.

Responsibilities

• Analyze existing database architecture and decipher complex logic to design scalable data models.
• Collaborate with stakeholders to translate requirements into robust database solutions.
• Design and develop new data models, schemas, and database objects.
• Build and optimize tables, stored procedures, and controls for data integrity and auditability.
• Implements data governance and ensures regulatory and internal security compliance.
• Support iterative development and adapt structures to evolving requirements.
• Mentor team members on data modeling best practices.
• Collaborate in an Agile environment using Jira and Confluence.

Skills

SQL Server development

Data modeling

ETL/SSIS

Data migration

SQL performance tuning

Regulatory compliance

Analytical thinking

Stakeholder communication

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

SSRS

Tableau

Snowflake

Databricks

.NET/C#

ASP.NET/Web API

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