Cincinnati, Ohio
Hennessey, Oklahoma
Central, South Carolina
Posted: 20-Nov-24
Location: Cincinnati, Ohio
Internal Number: 97694-en_US
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 53,235 students, more than 11,000 faculty and staff and 350,000+ living 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, three 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 stands at $1.85 billion, and its endowment totals nearly $1.8 billion.
Job Overview
This is a new position and will be primarily a data integration specialist with experience in Informatica and Snowflake required. Experience in Modern Data architecture is a great asset as well. Relational database design and stored procedure development on MS SQL would be a plus.
The responsibilities include designing and implementing ETL and ELT pipelines, maintaining documentation, and troubleshooting Informatica and other systems as required. Experience in setting up data quality and data governance in Informatica is also important.
The ideal candidate should possess a robust understanding of the development life cycle (SDLC), and experience with software and hardware troubleshooting. This position will oversee all system upgrades and manage all integration-related projects. Also understand Informatica ETL.
Essential Functions
- Create, modify or develop moderate to high complexity databases to include set-up, file structure, device allocation, etc. Participate in the preparation of moderately complex design specifications and functional documentations for assigned database projects. May participate as part of a scrum team focused on database related delivery initiatives.
- Create moderately complex functions, scripts, stored procedures, and triggers to support application development. Participate in basic to moderately complex database design and architecture to support application development projects.
- Participate in the research, design, implementation and support of systems for stand-alone and high availability environments.
- Participate in the development, maintenance, and utilization of standard operating procedures. Assist in development of policies and procedures to access or interact with remote resources; assist in data transfers or sharing of files. Review checklists for continued ways to improve procedures to save time and money.
- Participate in the creation and maintenance of moderately complex ETL/ELT solutions and integration of systems as they relate to databases.
- Monitor database performance, usage, and data integrity. Coordinate database upgrades and patch maintenance. Participate in the performance, reliability, tuning, and sizing of databases.
- Follow established standards to help maintain the security of the system and for testing new software releases.
- Ethically handle export control of restricted and controlled data.
- Troubleshoot and resolve any related hardware, software, user access, or other issues. Participate in tasks for business continuity and disaster recovery.
- Analyze and resolve security and access problems related to the overall system and database.
- Participate in the oversight of vendor database support. Assist with database updates and integration of changes through the database environments.
- Participate in the development and maintenance of moderately complex reports and visualizations.
- Work with user community to understand data access and integration needs. Participate in peer knowledge sharing groups.
- Perform related duties based on departmental need. This job description can be changed at any time.
Required Education
Bachelor's Degree in Information Technology, Computer Science, or related field.
Six (6) years of relevant work experience and/or other specialized training can be used in lieu of education requirement.
Required Experience
Two (2) years of relevant experience.
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 [email protected].
The University of Cincinnati is an Equal Opportunity Employer.
REQ: 97694
SF:OMJ SF:RM SF:HEJ, SF:INS SF:HERC SF:DIV SF:LJN SF:IHE