Enterprise Data Analyst

Columbus College of Art & Design; Columbus (OH); Híbrido; USD 65 000 - 90 000; Tempo integral

Resumo da oferta

Columbus College of Art & Design is seeking an Enterprise Data Analyst to act as a liaison between business stakeholders, student support areas, end-users, and IT to protect and promote data assets. The role guides data asset development and ensures data is used to support CCAD's academic mission.

The analyst will assist end users with guidance, troubleshooting, training, and support for various systems, including reports from Power BI and SSRS.

Qualificações

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

Responsabilidades

• 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.
• Support data governance for the college with the Enterprise Applications team and application owners.

Conhecimentos

SQL

SSRS

Power BI

Data analytics

Data integration

BI tools

Formação académica

Bachelor's degree or equivalent related experience

3+ years experience with database systems

Ferramentas

Tableau

APIs

IPaaS

Descrição da oferta de emprego

SUMMARY

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.

ESSENTIAL DUTIES AND RESPONSIBILITIES

included but are not limited to the following:

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

Secondary Responsibilities

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

Tertiary Responsibilities

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

Supervisory Responsibilities

This job has no supervisory responsibilities.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

• 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.
• Experience with integration platforms or IPaaS desired.

Education And/or Experience

• Bachelor's degree desired or equivalent related experience in Business Analytics, Computer Science, Information Systems, or a related field; or combination of education and experience.
• 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.

Physical Demands

• The employee is regularly required to use hands to finger, handle, or feel and talk or hear.
• The employee frequently is required to sit and reach with hands and arms.
• The employee is occasionally required to stand and walk.
• The employee must frequently lift and/or move up to 10 pounds.
• Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus.

Work Environment

• This role is primarily on campus with the opportunity to work remotely one or two days out of the week. The employee may be required to come to campus to carry out specific work-related activities.
• The noise level in the work environment is usually low to moderate.

Applications

• Submit Cover Letter
• Submit Resume

Job Posted by ApplicantPro