Information Management Architect

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 .

Essential Functions:

• 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.

Minimum Qualifications:

• Bachelors 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.

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

• 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.

Minimum Pay: $86069 - Pay commensurate with experience

Application Instructions

Review of applications will begin immediately and continue until the position is filled. Applicants requiring sponsorship will not be considered for this position. Required materials include:

• Cover letter

• Resume

• Names and contact information for three professional references

Application instructions for internal and external candidates can be found at Requirements:

• Fingering: Picking pinching typing or otherwise working primarily with fingers rather than with whole hand or arm as in handling.

• Grasping: Applying pressure to an object with the fingers and palm.

• Repetitive motions: Making substantial movements (motions) of the wrists hands and/or fingers.

Working Conditions: The worker is not substantially exposed to adverse environmental conditions.

Types of Work: Sedentary work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift carry push pull or otherwise move objects including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Washington and Lee is an Equal Opportunity Employer seekingcandidates committed to high standards of scholarship performance professionalism and to a welcoming campus community. Job description requirements are representative but not allinclusive of the knowledge skill and abilities needed to successfully perform this job. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential functions.