Senior Dashboarding & Reporting Analyst, Finance Systems

Wake Forest University Pre-College Programs; Winston-Salem (NC); On-site; USD 95,000 - 130,000; Full time

Job summary

Wake Forest University Finance Systems is seeking a Senior Dashboarding & Reporting Analyst to lead design, development, testing and maintenance of high-impact reports and dashboards. You will partner with Finance and the business partner community to ensure accurate, timely analytics and secure access across systems.

The role requires expert SQL, Workday reporting, Power BI expertise and strong ETL/data warehousing knowledge.

Qualifications

• Bachelor's degree in business, accounting or computer science with 5–7 years' ERP/reporting experience.
• Expert SQL authoring and Workday Report Writer proficiency.
• Strong knowledge of ETL processes, data warehousing and data modeling.

Responsibilities

• Designs and maintains reports and dashboards to support analytics and decision making.
• Leads reporting lifecycle and ensures secure, production-ready dashboards.
• Collaborates with Finance and business partners to translate requirements into actionable visuals.
• Manages project plans, testing, data security controls and data integrity.
• Continuously improves reporting workflows and stays current with best practices.

Skills

SQL

Workday Report Writer

Power BI

ETL

Data Warehousing

Data Modeling

ERP Systems

Education

Bachelor's degree in Business/CS/Accounting

Tools

Workday

Power BI

Prism

Job description

Senior Dashboarding & Reporting Analyst, Finance SystemsWake Forest University uses cookies to create a secure and effective application experience. Information regarding the University's privacy policy and cookies can be found here.# Staff Employment Opportunities## Senior Dashboarding & Reporting Analyst, Finance SystemsApply: Winston Salem, NC: Full time: Posted Today: R0009230****External Applicants:****Please ensure all required documents are ready to upload before beginning your application, including your resume, cover letter, and any additional materials specified in the job description.Cover Letter and Supporting Documents:* Navigate to the \"My Experience\" application page.* Locate the \"Resume/CV\" document upload section at the bottom of the page.* Use the \"Select Files\" button to upload your cover letter, resume, and any other required supporting documents. You can select multiple files.**Important Note: The \"My Experience\" page is the *only* opportunity to attach your cover letter, resume, and supporting documents. *You will not be able to modify your application or add attachments after submission.*******Current Employees:****Apply from your existing Workday account in the Jobs Hub. *Do not apply from this website.***A *cover letter is required for all positions;* optional for facilities, campus services, and hospitality roles unless otherwise specified.****Job Description Summary**This position is responsible for the strategic design, advanced development, testing and maintenance of reports and dashboards to optimize analytics and reporting in support of the University’s data-driven strategies and decision making. This role operates beyond standard report development and maintenance to partner with functional units within Finance as well as the business partner community to ensure reporting needs are appropriately addressed in an efficient and consistent manner. This position leads the reporting application lifecycle, performs deep-dive impact analyses for system upgrades, and serves as a primary liaison between Information Systems and the Finance division to ensure data integrity and process efficiency. Other key responsibilities include maintaining and reviewing application security to ensure data is appropriately protected.**Job Description****Essential Functions:*** *Data Repository Development:* Develops data extracts from key systems (e.g. Workday) to populate the financial-related data repository that will support dashboard development. Architects and governs formal metadata descriptions including complex data models, flow diagrams, and advanced data definitions.* *Data Management:* Ensure the accuracy, completeness, and integrity of financial-related data by working closely with the finance team to validate and reconcile data across systems. Recommends automated solutions for accuracy and completeness.* *Reporting & Dashboard Development:* Partners with functional users to gather business requirements and translate complex business needs into high-impact reports and dashboards. Employs advanced visualization techniques to highlight trends, anomalies, and strategic KPIs for executive review. Partners with functional users and Information Systems to ensure reports and dashboards are deployed to production in a timely manner. Ensures reports and dashboards are appropriately secured and shared appropriately.* *Liaison & Consultation*: Acts as a senior consultant to the business partner community, providing expert guidance on data availability and self-service reporting capabilities.* *Project Management*: Develops dashboarding and reporting-related project plans representing the full project lifecycle from inception to completion, including project scope, timelines, stakeholder communications and ensuring deliverables are met according to stakeholder requirements. Creates and maintains comprehensive project documentation to ensure clarity and continuity.* *Data Security:* Develops, maintains and reviews application security access for reports to ensure internal controls are maintained systematically and data is protected from unauthorized access.* *Quality Assurance and Testing:* Conducts thorough quality assurance checks on reports to ensure accuracy, consistency, and adherence to established standards. Develops and executes detailed test plans to ensure that reports meet the original specifications and run efficiently, securely and correctly.* *System Upgrade Support:* Evaluates system impact as a result of available upgrades, including patches/fixes, and business change requests. Performs testing in collaboration with functional users, Information Systems, and third parties for supported application upgrades.* *System Maintenance Support:* Leads the investigation and resolution of reporting issues encountered by users. Logs support incidents and coordinates timely problem resolution with user and/or Information Systems staff as needed.* *Continuous Improvement:* Stays abreast of industry best practices and emerging trends in reporting and analytics. Proactively identifies, recommends, and implements improvements to existing reporting workflows, transforming manual tasks into automated, efficient processes. Understands and communicates the upstream and downstream impacts of system changes to stakeholders.* Performs other related functions and duties as required.**Required Education, Knowledge, Skills, Abilities:*** Bachelor’s degree in a business, accounting or computer science-related major and five to seven years of experience with ERP systems and related applications or an equivalent combination of education and experience.* Expert-level SQL authoring and advanced proficiency in Workday Report Writer, Prism, and Power BI. Deep understanding of ETL (Extract, Transform, Load) processes and relational database concepts. Experience with data warehousing concepts and development.* Creative problem solver who identifies hidden opportunities, optimizes broken processes, and designs intuitive, actionable visualizations to guide strategic decisions.* Ability to pivot when confronted with an obstacle and think outside the box to problem solve.* Embrace exploring new reporting tools or functionality and consider appropriate use cases for a new technology.* Experience creating compelling visualizations to communicate data insights effectively.* Ability to maintain the security and confidentiality of any proprietary or sensitive data.* Experience in documenting, developing and testing reports.* Knowledge of project management methodology and practices.* Knowledge of Microsoft Office (including Access and Visio) and Google Workspace.* Strong written and verbal communication skills and interpersonal finesse to interact effectively within the organization and with external suppliers.* Above-average interpersonal skills with the ability to resolve technical conflicts and communicate complex data concepts to non-technical audiences without escalation.* Experience working in a finance or accounting function.* Ability to work in a team environment as a participant and with a proven ability to lead cross-functional project teams and manage multiple high-priority deadlines in a fast-paced environment.* Exceptional organization skills, attention to detail, and a proven ability to follow projects and issues through to completion.* Must be comfortable in an environment that places high emphasis on continuous improvement, teamwork, and excellent customer service.**Preferred Education, Knowledge, Skills, Abilities:*** Experience in higher education administration and related current best practices and leading-edge technologies.* Workday Pro Reporting or Advanced certification in Power BI.**Accountabilities:*** Responsible for own work only.**Additional Job Description****This position is not eligible for sponsorship of non-immigrant or immigrant visa status through Wake Forest University. All eligible applicants are encouraged to apply.** **Time Type Requirement**Full time### ### **Note to Applicant:**This position profile identifies the key responsibilities and expectations for performance. It cannot encompass all specific job tasks that an employee may be required to perform. Employees are required to follow any other job-related instructions and perform job-related duties as may be reasonably assigned by his/her supervisor.*In order to provide a safe and productive learning and living community, Wake Forest University conducts background investigations and drug screens for all final staff candidates being considered for employment.*****Equal Opportunity Statement****The University is an equal opportunity employer and welcomes all qualified candidates to apply without regard to race, color, religion, national origin, sex, age, sexual orientation, gender identity and expression, genetic information, disability and military or veteran status. ****Accommodations for Applicants****If you are an individual with a disability and need an accommodation to participate in the application or interview process, please contact [e-mail] or [phone].