Senior Database Administrator & Data Modeler

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, inclusive 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.

The RSM USI supports RSM U.S. risk consulting, transaction advisory, technical accounting, financial consulting, technology, and management consulting, tax, and assurance engagement teams by providing access to highly skilled professionals for repeatable business processes over an extended business day. USI is a member of RSM International, the sixth largest global network of independent accounting, tax, and consulting firms. RSM’s vision is to be the first-choice advisor to middle market leaders globally. You will work directly with clients, key decision makers and business owners across various industries and geographies to deliver a top-quality client experience. RSM is a diverse and inclusive place where you will work as part of a team while being valued as an individual, mentored as a future leader, and recognized for your accomplishments.

Risk Consulting helps clients across various industries by addressing the increasingly complex strategic, operational, compliance, and governance challenges faced by those responsible for managing or overseeing dynamic businesses. Risk Consulting major offerings includes AML & Regulatory Compliance; ERP Advisory; Automation and Analytics; Enterprise Risk Management; Internal Audit; SOX Advisory; Contract Compliance; Credit Reviews; Information & Technology Audits; Cybersecurity risk management; Third-party risk management; IT due diligence; SOC1 / SOC2; Security and Privacy Risk; Governance Risk and Compliance; PCI; Cyber Transformation; Manage Security Services; Secure Architecture Solutions; Cyber Testing; Digital Forensics and Incident Response; and Cyber Threat Intelligence.

We are in search of an experienced Senior Database Administrator & Data Modeler to spearhead a critical new development project involving the rewrite of a legacy system for a prominent financial client. This role demands expertise in analyzing existing databases, deciphering complex logic, and crafting new, performance-driven data models aligned with evolving business needs. The ideal candidate will play a pivotal role in ensuring the creation of robust, auditable, and compliant data controls within the system.

Responsibilities:

• Conduct in-depth analysis of the existing database architecture, decipher complex logic, and understand legacy data models.
• Collaborate closely with business stakeholders to elicit, understand, and translate evolving business requirements into effective and scalable database solutions.
• Design and create new data models aligned with iterative business needs, ensuring optimal performance and adherence to best practices.
• Lead the development of database schemas, tables, procedures, and controls to ensure data integrity, performance, and auditability.
• Implement rigorous data controls, ensuring compliance with regulatory standards and internal security policies.
• Work iteratively, adapting, and refining data models based on evolving business requirements throughout the development lifecycle.
• Provide mentorship and guidance to the development team, ensuring alignment with best data modeling practices.
• Collaborate effectively with cross-functional teams in an Agile environment, utilizing tools like Jira, Confluence, and Gliffy for documentation and workflows.

Requirements:

• Bachelor's degree in computer science, Information Technology, or related field.
• 10-12 years of extensive experience in SQL Server DBA, data modeling, and management, focusing on large-scale development projects, particularly in financial environments.
• Expertise in:
  • Data migration, ETL (Extract Transform Load), and integration services, including SSIS.
  • Reporting services like SSRS and Tableau for visualization/report creation.
  • Data analysis, data quality, and proficient data modeling.
  • Test automation tools and techniques for SQL databases.
  • Microsoft Full Stack technologies: .NET, C#, ASP.NET, MVC, and Web API.
• Proven record of accomplishment in:
  • Designing and implementing high-performance, auditable data models aligned with evolving business needs.
  • Understanding and implementing data controls, regulatory compliance, and security measures in financial systems.
• Advantageous: Familiarity with cloud databases and full-stack technologies (such as .NET, C#).
• Excellent analytical, problem-solving, and proactive communication skills, coupled with a collaborative approach.
• Strong organizational and time management skills.
• Ability to work in a high-pressure, deadline-driven environment.
• Demonstrated experience in applying DevSecOps best practices within an Agile software development environment.

This role presents a unique opportunity for a seasoned Database Administrator & Data Modeler to lead a critical project in redefining a legacy system for our esteemed financial client, ensuring the creation of robust, performant, and compliant database solutions aligned with evolving business needs.

You want your next step to be the right one. You’ve worked hard to get where you are today. And now you’re ready to use your unique skills, talents and personality to achieve great things. RSM is a place where you are valued as an individual, mentored as a future leader, and recognized for your accomplishments and potential. Working directly with clients, key decision makers and business owners across various industries and geographies, you’ll move quickly along the learning curve and our clients will benefit from your fresh perspective.

Experience RSM. Experience the power of being understood.