Sr Data Reporting Analyst, Digital Technology Solutions
University of Cincinnati
Cincinnati, OH
Full-time
Information Services / Technology (IT)
Posted on April 30, 2024
Current UC employees must apply internally via SuccessFactors - http://bit.ly/UCEMPL
Founded in 1819, the University of Cincinnati ranks among the nation's best urban public research universities. Home to more than 50,000 students, 11,000 faculty and staff and 340,000 alumni, UC combines a Top 35 public research university with a physical setting The New York Times calls “the most ambitious campus design program in the country.”
With the launch of Next Lives Here, the Cincinnati Innovation District, a $100 million JobsOhio investment, nine straight years of record enrollment, worldwide leadership in cooperative education, a dynamic academic health center and entry into the Big 12 Conference, UC's momentum has never been stronger. UC's annual budget tops $1.65 billion and its endowment totals $1.8 billion. The University's overall regional economic impact exceeds $10.6 billion, paving the way for the future of Cincinnati.
Job Overview
Perform business analysis using various techniques, e.g. statistical analysis, explanatory and predictive modeling, data mining to create high quality reports to be used for operational and executive level decision making.
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.
Essential Functions
N/A
Required Experience
Three (3) years of experience in reporting, ETL processing and/or background in complex data analysis techniques.
Additional Qualifications Considered
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.
To learn more about why UC is a great place to work, please visit our careers page at https://www.uc.edu/careers.html.
For questions about the UC recruiting process or to request accommodations with the application, please contact Human Resources at jobs@uc.edu.
The University of Cincinnati is an Equal Opportunity Employer.
REQ:95951
SF:OMJ SF:RM SF:HEJ, SF:INS SF:HERC SF:DIV SF:LJN SF:IHE
Founded in 1819, the University of Cincinnati ranks among the nation's best urban public research universities. Home to more than 50,000 students, 11,000 faculty and staff and 340,000 alumni, UC combines a Top 35 public research university with a physical setting The New York Times calls “the most ambitious campus design program in the country.”
With the launch of Next Lives Here, the Cincinnati Innovation District, a $100 million JobsOhio investment, nine straight years of record enrollment, worldwide leadership in cooperative education, a dynamic academic health center and entry into the Big 12 Conference, UC's momentum has never been stronger. UC's annual budget tops $1.65 billion and its endowment totals $1.8 billion. The University's overall regional economic impact exceeds $10.6 billion, paving the way for the future of Cincinnati.
Job Overview
Perform business analysis using various techniques, e.g. statistical analysis, explanatory and predictive modeling, data mining to create high quality reports to be used for operational and executive level decision making.
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.
Essential Functions
- Determine best practices and develop actionable data-driven insights and recommendations to support the organizational decision-making.
- Create and present executive summaries, executive briefings, benchmark reports and dashboards.
- Work with departments to define business problems and questions; perform data analysis.
- Collaborate with data architect or application specialists to identify the data sources required to support an analytical project or development of complex report.
- Research, collect, develop, and implement data analysis and identify data quality issues.
- Utilize data integration tools to automate data extraction, transformation, and storage to deliver reports and dashboards.
- Evaluate diverse data sets, identify new types of data and data sources to determine patterns; synthesize data into meaningful metrics and numbers; monitor data quality, identify inconsistencies, and develop recommendations to optimize business processes and performance.
- Develop load plan using data integration tools (Informatica Cloud Data Integrator), or similar program, to quickly demonstrate new concepts, reports and dashboards; utilize reporting tools (like PowerBI, Tableau, Qlik) to build reports and dashboards.
- Assess current set of BI and analytical tools and its usage and work on consolidation plan while researching on new tools to add to address the missing capabilities.
- Perform other duties as needed.
- Bachelor's Degree in Business Analytics, Statistics, Computer Science, Mathematics, or related field.
- Seven (7) years of relevant work experience and/or other specialized training can be used in lieu of education requirement.
N/A
Required Experience
Three (3) years of experience in reporting, ETL processing and/or background in complex data analysis techniques.
Additional Qualifications Considered
- Bachelor's degree in computer science, analytics, data science, or a related field.
- 7+ years of proven experience as a Report/Analytics Developer or Business Intelligence Analyst or similar role leveraging tools like Tableau, Power BI, and Qlik.
- Deep experience in creating reports and dashboards and providing data insights.
- Experience working with cloud hosted BI and analytical tools.
- Proficient in SQL along with 3+ years of experience leveraging data integration tools.
- Experience working in Data Warehouse and Data Lakehouse in a cloud setting (AWS, Azure, Snowflake).
- Strong familiarity with data governance, data architecture, data modeling, data collection, data cleansing, and transformation processes.
- Excellent communication and presentation skills.
- Attention to detail and the ability to work with complex datasets.
- Prefer knowledge and understanding of the higher education sector.
- Office environment/no specific unusual physical or environmental demands.
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 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.
To learn more about why UC is a great place to work, please visit our careers page at https://www.uc.edu/careers.html.
For questions about the UC recruiting process or to request accommodations with the application, please contact Human Resources at jobs@uc.edu.
The University of Cincinnati is an Equal Opportunity Employer.
REQ:95951
SF:OMJ SF:RM SF:HEJ, SF:INS SF:HERC SF:DIV SF:LJN SF:IHE
