Enterprise Data Analyst

Columbus College of Art & Design•Columbus, OH

1d•Hybrid

About The Position

The Enterprise Data Analyst serves as a liaison between business stakeholders, student support areas, end-users, and IT to protect and promote data assets. This role interacts with all levels of the organization, guides the development of data assets, and ensures the use of data assets to drive the success of CCAD's academic mission. The Enterprise Data Analyst will assist end users achieve desired results by providing guidance, troubleshooting, training and assistance with various systems.

Requirements

Advanced proficiency using SQL, SSRS, and Power BI, or similar reporting programs.
Advanced proficiency of data analytics, reporting and data integration technologies.
Proficiency in business intelligence tools (e.g., Tableau, Power BI), data visualizations, data warehousing, and APIs.
A passion for helping the organization use data.
Experience writing and maintaining technical documentation.
At least 3 years of progressive experience with database systems, including integrations, reporting, and querying.
Experience on projects to transition systems to the cloud, or implement new systems, or complete major upgrades to systems.

Nice To Haves

Experience with integration platforms or IPaaS desired.

Responsibilities

Protect and promote all college data assets, including the Student Information System.
Gather and analyze data and business needs, develop, design, test and deliver internal and external reports using Power BI and SQL Server Reporting Services.
Identify and implement opportunities for process improvements and automation.
Provide support to the Enterprise Applications team in the development and enhancement of data assets, assuming responsibility for their operation, support, maintenance, and integrations.
Create and update technical documentation for data processes, reporting, and definitions of college data.
In coordination with the Senior Director of Library & Information Technology, Enterprise Applications team, and application owners, support data governance for the college.
Act as a data quality subject matter expert to the Enterprise Applications team and stakeholders.
Support all users as they learn data and associated reporting and processes.
Contribute to the development of a data warehouse of regularly captured data, ensuring stakeholders can access and utilize the data.
Provide shared experiences and expertise that will contribute to CCAD's commitment to diversity and inclusiveness.
Contribute to diversity and inclusive excellence by creating technology services and processes that are inclusive, equitable, and accessible.
Contribute to a small team of analysts in Enterprise Applications, fostering a culture of innovation and excellence.
Maintain a cooperative and professional working relationship with other members of the IT staff and with the CCAD community.
In collaboration with other IT staff, implement technology security standards as well as maintain and protect the confidentiality of information and data.
May serve on College-wide committees, task forces, working groups etc.
Other duties or responsibilities as assigned.
Represent CCAD and Library & Information Technology by attending or presenting at appropriate conferences and events.
Participate in the life of the College by attending campus events such as gallery openings, student exhibits and invited speakers.