Business Data Analyst - Project-Based Consultant

October 30

Apply Now

Receive Emails with Similar Jobs

CampusWorks, Inc.

WebsiteLinkedInAll Job Openings

Consulting for Higher Education • Functional area consulting (financial aid • enrollment • HR • Finance)

51 - 200

Description

• Are you a skilled professional with a passion for higher education and expertise in Workday? Join our dynamic team as a Business Data Analyst, where you will leverage your knowledge of Workday to provide top-tier consulting services to our higher education clients. As a consultant, you will enjoy the flexibility of remote work while contributing to the success of leading institutions. • CampusWorks consultants engage with our clients in higher education to assist them in fully leveraging their people, processes, policies, and technologies. We work collaboratively with clients' functional and technical teams and our CampusWorks colleagues to evaluate current processes, design future-state optimal processes, and to architect, develop, test, train, and rollout process and technical solutions that delight our clients. • The Business Data Analyst will be working within a program that is transforming the Finance, Human Resources, and Research Administration support environments across various client colleges and universities, while focusing on people, processes, and technology. This includes the implementation of a new Enterprise Resources Planning (ERP) system (Workday) to support the changes. The activities will include the review and redesign of business processes (including use of ancillary and bolt-on IT systems), redesign of the chart of accounts, and integration of efforts with several ongoing University System projects. The Business Data Analyst will serve a vital role within the program. • As part of the consulting team, the Business Data Analyst works with customers and functional subject matter experts to gather requirements, understand needs, analyze the data, create and document data connections (using SQL tools in AWS environments), works with ETL developers on functional/technical specifications to create datasets, understands change data capture and row level security, validates data, and documents data lineage/transformations/definitions for communication and data governance purposes.

Requirements

• Associate degree • A minimum of 1- 3 years data analysis SQL query experience. • Experience coordinating and collaborating with cross functional partners in validating and documenting data, developing detailed functional specifications for ETL developers and testing the ETL code. Additional preference given for those with experience collaborating in the functional areas of HR, Finance and Grants reporting • Knowledge and/or experience with Workday data either through building reports or integrations. • Experience working with XML data. • Knowledge and/or experience with AWS tools such as Athena, Redshift and using SQL tools such as DBeaver. • Exposure to Workday, Peoplesoft, or other ERPs. • Experience using data in the AWS data warehousing platform, in Tableau, or in other warehousing and visualization tools. • Ability to train/knowledge transfer with other data analysts. • Excellent organizational, time-management, and decision-making skills. • Ability to diagnose and solve complex reporting issues. • Experience developing data views in the areas of human resources, accounting, finance, or budgets.