Information Management Architect

Washington and Lee University • Lexington, VA

2d • Hybrid

About The Position

The Information Management Architect serves as a data specialist and analyst for ITS within Workday and related products. This position is hybrid regionally remote within Virginia. Regular working hours on campus will be expected. The Information Management Architect ensures data is stored accurately, appropriately and with a high level of importance centered on its security to ensure that data can be easily accessed, analyzed and represented. Supporting the total data lifecycle, this role will focus primarily on all data and reporting needs while enforcing and enhancing institutional data governance activity and policies. The Information Management Architect will also be required to support new data initiatives and related integrations where required. Reporting to ITS, the Architect has direct accountability for data needs and produces timely and accurate datasets and reports. Assimilates within those functional offices and within the broader ITS department to maximize support options for best possible solutions. Washington and Lee University actively promotes a dynamic and welcoming environment that allows students and employees of multiple backgrounds and perspectives to learn, work, and thrive together. Successful candidates will contribute to that environment and exhibit potential for excellence in their areas of expertise. Learn more about what makes Washington and Lee University a great place to work and live at jobs.wlu.edu.

Requirements

• Bachelor’s degree required with a minimum of three years' of experience developing accurate reports, queries, and data outputs using tools such as Informer, SSRS, Cognos, or Excel; higher education experience preferred.
• Must understand technical architecture, security, integrations, reporting platforms, records management, data management, and overall approaches to information accuracy.
• Demonstrated experience working with HCM, Payroll and Financial datasets across cloud-based, on-premise, and hybrid environments.
• Proven ability to translate business requirements into reports, dashboards, templates, and analytical outputs.
• Strong analytical and problem-solving skills with experience handling datasets of varying size and complexity.
• Proficiency in data extraction, cleaning, transformation, and writing complex queries (e.g., SQL) to integrate data from multiple sources; knowledge of data warehousing and ETL processes required.
• Ability to communicate effectively with stakeholders at all organizational levels, manage deadlines, ensure data quality, and deliver customer-focused solutions in a timely manner.
• Proven ability to work both independently and collaboratively, adapt to ambiguity, and quickly learn new systems or concepts.

Nice To Haves

• Experience with Workday reporting, including familiarity with Workday Prism Analytics, preferred.

Responsibilities

• Supports institutional initiatives by creating reports, providing environments and solutions to aid in-depth data analysis by others, data summarization, and data visualization as requested.
• Engages directly with functional offices to define data/report requirements, translate those requirements into actionable plans, and execute those plans to provide quality solutions.
• Interprets, manages, manipulates and stages back-end data to facilitate ease of access and use by stakeholder offices.
• Identifies, obtains, and supports analysis of institutional and other relevant data as defined by functional offices in a timely manner, ensuring it is accurate and easily digestible.
• Creates and delivers reports for internal use by functional offices and/or broader offerings for the campus community.
• Consults functional areas on methods to optimize report development and delivery for the highest efficiency and ease of maintenance.
• Supports and enhances institutional data governance activities and policies, as well as, helping to administer related systems.
• Develops, documents and maintains data environment design for new or revised datasets.
• Develops and implements training protocols related to reporting and data governance activities.
• Engages in administrative duties and primary development activities with relation to reports, dashboards, discovery boards, Worksheets, Prism Analytics items, worklet development and any other new Workday functionality that falls under reporting and analytics.
• Serves as the primary resource for calculated column needs, as well as, promotes and documents any data definition requirement while working in conjunction with functional areas.
• Serves as a resource for SQL Server programming, including writing complex queries, joins, data transfers and stored procedures.
• Follows the ITS Information Security Program and industry standard best practices to help ensure the confidentiality, integrity, and availability of all data and IT resources.
• Other related duties as assigned.

Benefits

• The University provides a comprehensive benefits package aimed at supporting the work-life balance, health and wellbeing, financial security, and professional development of employees.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level