Talent Data Management Associate Director – Principal Data Architect (Location Flexible)

About this role

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 Associate Director 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.  

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 Talent data strategy and architecture.  

• Drive database optimization initiatives to improve system performance, reliability, and reporting efficiency.  

Data Governance, Quality & Operational Excellence (15%)  

• Develop and maintain enterprise standards for HR data governance, quality, and operational data management.   ​

• Establish quality controls and validation processes that ensure trusted, accurate, and consistent HR data.  

• Partner with HRIS and business stakeholders to define data ownership, stewardship, and governance practices.  

• Ensure compliance with enterprise security, privacy, legal, and regulatory requirements.  

• Participate in architecture and solution reviews to ensure new initiatives align with enterprise data standards.  

• Support metadata management, master data management, data lineage, and data catalog initiatives.  

• Promot

Similar jobs

• Associate Director, Global Data Management and Standards, Talent & Capability Development (Hybrid) — Merck · Rahway, New Jersey, United States | Upper Gwynedd, Pennsylvania, United States
• Director, Data Engineering & Architecture (Remote) — Ceribell · Remote
• Associate Director, Data Management — Neurocrine · US CA San Diego One Paseo
• Associate Director, Data Engineering & Architecture — Biibhr · Cambridge, MA | Research Triangle Park, NC
• Senior Director, Data Architecture — Starr · NY | Atlanta, GA
• Senior Director, Data Management — Integritymarketing · Dallas, TX
• Associate Director, Enterprise Talent Management — Illumina · San Diego, California, United States
• Director, Data Strategy and Analytics Enablement (Hybrid MA, NY, NH, NJ, PA) — Insulet Corporation · Massachusetts, United States