Talent Data Management Manager - Principal Data Architect (Location Flexible)

Responsibilities

• Strategic Leadership & Data Architecture (50%)
• Develop and execute the long-term strategy and roadmap for the Talent Operational Data Store and enterprise HR data architecture.
• Lead and manage the Database Administration function by providing technical leadership, coaching, mentoring, and performance management.
• Serve as the Principal Data Architect for Talent Technology, establishing enterprise data architecture standards and best practices.
• Design scalable relational database structures and Azure-based data warehouse solutions that support current and future business needs.
• Develop conceptual, logical, and physical data models that optimize reporting, analytics, scalability, and system performance.
• Partner with HRIS, Talent Analytics, Reporting, and business leaders to ensure data architecture aligns with business strategy and enterprise objectives
• Evaluate current data structures and recommend modernization opportunities that improve usability, scalability, and operational efficiency.
• Lead architectural decisions for new HR technologies and ensure alignment with enterprise architecture standards.
• Provide architectural oversight for large-scale Talent Technology initiatives involving enterprise HR data.
• Guide technical decision-making on complex data challenges while balancing business priorities and long-term sustainability.
• Establish standards for database design, metadata management, documentation, naming conventions, and data lifecycle management.
• Communicate architectural direction, project progress, risks, and recommendations to senior leadership and key stakeholders.
• Foster a culture of continuous improvement, innovation, and technical excellence across the Talent Data Management function .
• Talent Data Management & Operational Data Store (35%)
• Lead the design, development, implementation, and ongoing evolution of the HR Operational Data Store (ODS).
• Design and maintain enterprise HR data models that accurately represent business processes and organizational relationships.
• Develop and maintain conceptual, logical, and physical data models supporting Workforce, Recruiting, Learning, Compensation, Payroll, Organizational Management, and other Talent domains.
• Build scalable Azure-based data warehouse solutions that support enterprise reporting and advanced analytics.
• Design relational database structures that optimize reporting performance and simplify downstream consumption by analytics platforms.
• Understand end-to-end HR business processes and translate functional requirements into scalable technical data solutions.
• Create and maintain technical documentation, including entity relationship diagrams (ERDs), data dictionaries, metadata, data lineage, mapping specifications, and solution architecture documentation.
• Ensure data quality, consistency, integrity, and reliability across the Talent data ecosystem.
• Partner closely with the Power BI and Reporting teams to ensure the operational data store and data warehouse are optimized for semantic modeling, dashboard development, and self-service analytics.
• Anticipate future reporting and analytical needs by designing reusable, extensible, and scalable data structures.
• Collaborate with HRIS and business stakeholders to continuously improve the firm's Tale

Benefits

Additional Information

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. The Talent Data Management Manager serves as the Principal Data Architect for Talent Technology and is responsible for defining and executing the strategic vision for the firm's HR data ecosystem. This role leads the design, governance, and evolution of the Talent Operational Data Store (ODS), ensuring HR data is scalable, secure, reliable, and optimized to support enterprise reporting, analytics, and business intelligence. As the organization's HR data architecture leader, this position is responsible for designing modern relational database solutions and Azure-based data warehouse architecture that enable trusted, high-quality data for downstream analytics and Power BI reporting. The role partners closely with HRIS, Talent Analytics, Reporting, and business stakeholders to translate complex HR business processes into scalable, sustainable data solutions. This leader will manage the Database Administrator while serving as the organization's technical authority for HR data architecture. The role will frequently operate as a player/coach by providing architectural leadership, technical guidance, mentoring, and hands-on design expertise for critical initiatives.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at rsm? Share your experience