Sr. Data Architect, Digital Technology Solutions

Details

Posted : 22-Jul-24

Location : Cincinnati, Ohio

Type : Full Time

Salary : Competitive salary

Categories :

Senior / Mid-Level Management

Required Education : 4 Year Degree

4 Year Degree

Sr. Data Architect, Digital Technology Solutions

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

Responsible for integrating systems, creating, modifying or developing databases to include set-up and monitor tables, indexes, views, triggers, table spaces, fragmentation issues, monitoring processes, referential integrity, security, performance tuning and sizing.

Essential Functions

• Structure and implement moderately to highly complex databases to optimize data access and security.
• Design database systems and programs which include access methods, access time, file structure, device allocation, validation checks, and statistical methods.
• Work with user community to understand data access and integration needs; support client / server database access tools;

provide consultation to programmers on relational database design.

Ensure the integration of systems through the database structure. Ensure data and its sources are accurate and easily accessible to the user community.

Develop assigned databases to support specific applications. Conduct file maintenance. Set-up and monitor tables, indexes, views, triggers, table spaces, etc.

Monitor database standards and procedures, systems usage, and performance. Troubleshoot and resolve database problems.

Conduct virus avoidance procedures. Oversee vendor software fault resolution. Develop benchmarks for testing new software releases.

Completes database upgrades and patch maintenance.

• Monitor, analyze, and verify data to ensure data integrity. Maintain data security and integrity by developing system access standards and procedures.
• Maintain the database archives by acquiring and installing data sets and documentation. Design data storage capacity to provide for efficient and timely response and operating time.

Calculate data storage media and cost alternatives. Specify sources and methods of data storage. Manage database organization and data storage.

Plan for efficient allocation of system storage capacity. Develop system backup and archival methodology. Develop and administer disaster recovery plans.

• Assist in data transfers or sharing of files. Assist in development of policies and procedures to access or interact with remote resources.
• May develop specifications and requirements for the optimal integration of systems which may include applications, databases, networks, and related systems.
• Install, structure, tune, and maintain database management systems and software on mainframe and / or mini-computers.
• Serves as an expert resource to others; serve on committees and projects.
• Perform related duties based on departmental need. This job description can be changed at any time.

Required Education

• Bachelor's Degree in Computer Science, Information Technology, Computer Engineering, or related field.
• Eight (8) years of relevant work experience and / or other specialized training can be used in lieu of education requirement.

Required Experience

Four (4) years of relevant experience.

Additional Qualifications Considered

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• 7+ years of experience in data architecture, data management, or a related role.
• Proficiency in data modeling, data integration, and database management.
• Experience with data management tools and platforms including Snowflake, Informatica, and AWS.
• Experience with modern integration platforms, such as Mulesoft, for application-level integrations.
• Strong analytical, problem-solving, and communication skills.
• Knowledge of data security and compliance frameworks and best practices.

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.

If interested, please apply online at

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 .

For questions about the UC recruiting process or to request accommodations with the application, please contact Human Resources at .

The University of Cincinnati is an Equal Opportunity Employer.

About University of Cincinnati