Data Reporting Analyst 2, Digital Technology Solutions
University of Cincinnati
Cincinnati, OH
ID: 7283985
Posted: 1 month ago
Application Deadline: Open Until Filled
Job Description
Job Overview
As a Data Reporting Analyst 2, you'll have the unique opportunity to influence decision-making across the organization by transforming data into knowledge. Identify business intelligence, reporting, and data analysis needs. Collaborate with clients and internal teams to turn data into critical information and knowledge that can be used to make sound business decisions.
Essential Functions
Work directly with clients to identify business requirements.
Convert business requirements into developed reports.
Be able to extract and integrate data from ERP and other systems.
Create data models and data sets that meet the requirements.
Develop reports and dashboards with limited supervision.
Interpret results using a variety of statistical techniques.
Profile data and implement data quality checks.
Guide business users on best practices.
Capable of maintaining existing catalog with limited guidance.
Perform related duties based on departmental need. This job description can be changed at any time.
Hybrid Onsite
This position offers a hybrid opportunity to work both remotely and onsite and therefore requires that the incumbent reside within a commutable distance to Greater Cincinnati. Hybrid work arrangements are subject to change in accordance with university policies.
Required Education
Bachelor's Degree in Business Analytics, Statistics, Computer Science, Mathematics, or related field
Required Experience
Bachelor’s degree in computer science, analytics, information technology, or a related field.
5+ years of proven experience as a Report/Analytics Developer or Business Intelligence Analyst.
3+ years if experience in SAP BW and SAP Business Objects
3+ years of experience in data integration and consumption layer data modeling.
Strong SQL skills.
Experience in tools like Power BI, Tableau, Qlik is a plus.
Knowledge of SAP S/4 HANA and SAP SuccessFactors is preferred.
Deep experience in creating reports and dashboards and providing data insights.
Preferred experience working with cloud hosted data and analytical tools.
Preferred experience working in Data Warehouse and Data Lake in a cloud setting (AWS, Azure, Snowflake, Informatica CDP).
Excellent communication and presentation skills.
Attention to detail and the ability to work with complex datasets.
Knowledge of HR and Finance data domains is preferred.
Prefer knowledge and understanding of the higher education sector.
Physical Requirements/Work Environment
Office environment/no specific unusual physical or environmental demands.
Compensation and Benefits
UC offers a wide array of complementary and affordable benefit options, to meet the financial, educational, health, and wellness needs of you and your family. Eligibility varies by position and FTE.
Competitive salary range of $87,000 - $92,000 dependent on the candidate's experience.
Comprehensive insurance plans including medical, dental, vision, and prescription coverage.
Flexible spending accounts and an award-winning employee wellness program, plus an employee assistance program.
Financial security via our life and long-term disability insurance, accident and illness insurance, and retirement savings plans.
Generous paid time off work options including vacation, sick leave, annual holidays, and winter season days in addition to paid parental leave.
Tuition remission is available for employees and their eligible dependents.
Enjoy discounts for on and off-campus activities and services.
As a Data Reporting Analyst 2, you'll have the unique opportunity to influence decision-making across the organization by transforming data into knowledge. Identify business intelligence, reporting, and data analysis needs. Collaborate with clients and internal teams to turn data into critical information and knowledge that can be used to make sound business decisions.
Essential Functions
Work directly with clients to identify business requirements.
Convert business requirements into developed reports.
Be able to extract and integrate data from ERP and other systems.
Create data models and data sets that meet the requirements.
Develop reports and dashboards with limited supervision.
Interpret results using a variety of statistical techniques.
Profile data and implement data quality checks.
Guide business users on best practices.
Capable of maintaining existing catalog with limited guidance.
Perform related duties based on departmental need. This job description can be changed at any time.
Hybrid Onsite
This position offers a hybrid opportunity to work both remotely and onsite and therefore requires that the incumbent reside within a commutable distance to Greater Cincinnati. Hybrid work arrangements are subject to change in accordance with university policies.
Required Education
Bachelor's Degree in Business Analytics, Statistics, Computer Science, Mathematics, or related field
Required Experience
Bachelor’s degree in computer science, analytics, information technology, or a related field.
5+ years of proven experience as a Report/Analytics Developer or Business Intelligence Analyst.
3+ years if experience in SAP BW and SAP Business Objects
3+ years of experience in data integration and consumption layer data modeling.
Strong SQL skills.
Experience in tools like Power BI, Tableau, Qlik is a plus.
Knowledge of SAP S/4 HANA and SAP SuccessFactors is preferred.
Deep experience in creating reports and dashboards and providing data insights.
Preferred experience working with cloud hosted data and analytical tools.
Preferred experience working in Data Warehouse and Data Lake in a cloud setting (AWS, Azure, Snowflake, Informatica CDP).
Excellent communication and presentation skills.
Attention to detail and the ability to work with complex datasets.
Knowledge of HR and Finance data domains is preferred.
Prefer knowledge and understanding of the higher education sector.
Physical Requirements/Work Environment
Office environment/no specific unusual physical or environmental demands.
Compensation and Benefits
UC offers a wide array of complementary and affordable benefit options, to meet the financial, educational, health, and wellness needs of you and your family. Eligibility varies by position and FTE.
Competitive salary range of $87,000 - $92,000 dependent on the candidate's experience.
Comprehensive insurance plans including medical, dental, vision, and prescription coverage.
Flexible spending accounts and an award-winning employee wellness program, plus an employee assistance program.
Financial security via our life and long-term disability insurance, accident and illness insurance, and retirement savings plans.
Generous paid time off work options including vacation, sick leave, annual holidays, and winter season days in addition to paid parental leave.
Tuition remission is available for employees and their eligible dependents.
Enjoy discounts for on and off-campus activities and services.