Sr Data Reporting Analyst, Digital Technology Solutions
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
Sr. Data Reporting Analyst is responsible for the creation, management, and enhancement of scalable data models that support the varied data consumption needs of the organization. This role will also be responsible for capturing and understanding the data requirements, profiling data, developing conceptual, logical and physical data models, ensuring data quality, building business intelligence and analytical solutions.
Essential Functions
- Determine best practices and develop actionable data-driven insights and recommendations to support the organizational decision-making process. May be requested to create executive summaries, executive briefings and benchmark reports.
- Work with departments to define business problems and questions; perform analysis. Provide technical writing support.
- Collaborate with data architect or application specialists to identify the data sources required to support an analytical project or development of a complex report.
- Research, collect, develop, and implement data analysis for gap, competition landscape, and infrastructure alignment.
- Utilize ETL tools to automate standard reporting.
- 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 plans using Oracle Data Integrator (ODI), or similar program, to quickly demonstrate new concepts, reports and dashboards; utilize reporting tools (i.e. OBIEE/OBIA) to build reports and dashboards.
- May create and maintain dashboards in Tableau to solve business problems.
- May monitor fund balances and budget reporting. May coordinate with department, technical teams, business divisions, and faculty for funding opportunities, notifying management and relevant faculty.
- May maintain databases for analyzing sponsored research productivity.
- May provide direct and/or indirect supervision to exempt and non-exempt staff (i.e., hiring/firing, performance evaluations, disciplinary action, approve time off, etc.).
- Perform related duties based on departmental need. This job description can be changed at any time.
Required Education
- 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.
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, Business Intelligence Analyst, Data Modeler, or similar role
• Experience leveraging tools like Erwin, ER Studio, Tableau, Power BI, and Qlik.
• Deep experience in creating data models, reports and dashboards and providing data insights.
• Proficient in SQL along with 3+ years of experience leveraging data integration and data quality tools like Informatica.
• Experience working in Data Warehouse and Data Lakehouse in a cloud setting (AWS, Azure, Snowflake).
• Advanced understanding of data normalization and denormalization techniques.
• Strong skills and knowledge in all aspects of data movement from source to consumption, dealing with structured, un-structured, and semi-structured data.
• 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.
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 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 UC employee, and an employee of an Ohio public institution, if hired you will not contribute to the federal Social Security system, other than contributions to Medicare. Instead, UC employees have the option to contribute to a state retirement plan (OPERS, STRS) or an alternative retirement plan (ARP).
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: 97045
SF:OMJ SF:RM SF:HEJ, SF:INS SF:HERC SF:DIV SF:LJN SF:IHE
Sr Data Reporting Analyst, Digital Technology Solutions
Cincinnati, OH, US
Nearest Major Market: Cincinnati
Job Segment:
Computer Science, ERP, Developer, Data Analyst, Technical Writer, Technology, Data