Senior Data/Reporting Analyst – Executive Tableau Reporting
Vanguard
AWSCloudPythonSQLTableau
Job Level
Senior
About the role
- Design, build, and maintain enterprise-level HR reporting solutions across platforms such as Workday and Dayforce, with a focus on delivering complex, high-impact insights that drive strategic and operational decisions.
- Utilize advanced reporting methods to develop custom reports, dashboards, and relational datasets that address nuanced business needs.
- Apply deep knowledge of data modeling, calculated metrics, conditional logic, and user-driven interactivity to produce scalable solutions that support stakeholders at all levels of the organization.
- Maintain and enhance HR Support dashboards (e.g., Workday Help); analyze trends to identify reporting opportunities for enhanced insights.
- Meet with customers from the business to understand their problem statement and then recommend options for reporting and analytics.
- Interpret business needs and translate non-technical or ambiguous requests into clear, executable reporting solutions
- Deliver recurring and ad-hoc reports, including key metrics, KPIs, and trend analysis, to support strategic and operational decision-making
- Develop and manage Microsoft Power BI datasets and dashboards to support scalable reporting and enhanced data visualization beyond native Dayforce and Workday capabilities
- Deliver high-quality audit ready, compliance and legislative reporting including but not limited to EE0-1, State Pay Data Reporting, Multiple Worksite Reporting, Workers Compensation and other cyclical federal and state reporting and auditing requirements
- Develops reporting solutions that blend technical precision with creative problem-solving—thinking beyond out-of-the-box functionality to design scalable, business-aligned outcomes.
- Continuously identifies opportunities to optimize Workday reports for performance, usability, and reusability—reducing manual effort and improving end-user experience.
- Ensures report accuracy and integrity by embedding quality checks, investigating data discrepancies or unexpected results, and collaborating with data owners to resolve issues at the source; proactively responds to stakeholder inquiries by analyzing report logic, validating data sources, and providing clear, actionable explanations.
- Partner cross-functionally with internal team members, report consumers, and data/process owners to ensure reporting solutions are accurate, aligned with business needs, and informed by upstream processes and system configurations
- Contribute to a collaborative, cross-functional team model by actively supporting reporting responsibilities across both Workday and Dayforce, ensuring seamless delivery, skill versatility, and shared ownership of Reporting & Records functions.
- Leverage emerging technologies, including AI tools such as ChatGPT and Microsoft Copilot, to enhance productivity, support innovation, and drive operational excellence—using them as general-purpose tools to streamline work, solve problems, and generate insights, such as aiding in the design, development, and troubleshooting of complex Workday reports including calculated fields, advanced logic, and data comparisons.
Requirements
- Strong understanding of data structures, reporting logic, and workflow design within enterprise HCM systems such as Dayforce and Workday, spanning a variety of functional areas such as HCM, Recruiting, Compensation, Performance, Payroll & Timekeeping.
- Demonstrates working knowledge of HR metrics and analytics to support the development of strategic dashboards and to guide business leaders in interpreting workforce data effectively.
- Proficiency in Power BI, with demonstrated experience in data modeling, reusable datasets, and advanced data transformation techniques to prepare clean, analysis-ready datasets
- Significant experience building reporting using Report Writer, Advanced/Matrix/Composite Reports, Calculated Fields, Dashboards, Worksheets Discovery Boards
- Designs reports in alignment with role-based security model to ensure appropriate data visibility and compliance with internal access protocols and align with data governance, privacy, and compliance standards
- Strong understanding of HCM data structures, business processes, and reporting logic across a variety of functional systems and areas
- Advanced Excel skills, including pivot tables, lookups, conditional formatting, and large dataset reconciliation
- Demonstrated ability to manage competing priorities and respond to urgent reporting needs in a dynamic environment
- Demonstrates a strong desire to continuously learn and quickly apply new Workday features, tools, and methods to deliver higher-quality reports and enhance stakeholder value.
- Insight-Driven Service: Builds strong, trust-based relationships by combining technical expertise with a deep understanding of stakeholder needs. Engages in active listening to clarify vague or high-level requests and helps customers define their objectives.
- Collaboration in a Matrixed Environment: Thrives in a team-oriented culture, working closely with peers, upstream data owners, and cross-functional partners across the business.
- Adaptability and Resilience: Responds effectively to changing business priorities, shifting timelines, and ambiguous requests.
- Judgment with Flexibility: Applies best practices and reporting standards where appropriate but knows when to bend the rules to meet a specific use case or solve a time-sensitive challenge.
- Integrity and Accountability: Holds a high standard for data quality, confidentiality, and ethical handling of sensitive information.
- Owns outcomes, including mistakes, and consistently look for opportunities to improve the clarity, accuracy, and impact of reporting deliverables.
- SPECIALIZED SKILLS: Workday Pro Reporting Certification is preferred, or equivalent training and experience
- 5+ years of experience designing and delivering reports or dashboards that blend technical accuracy with a strong understanding of business needs and stakeholder priorities.
