IT Systems Architect IV

Title: IT Systems Architect IV

Salary Range: $84,276 (Minimum) - $105,336 (Mid-Point) (Salary is to commensurate with education/experience and internal equity)

Contract Term Length: 12 Months

Standard

Hours:

37.5

Work Location: Full Remote

FLSA Status: Exempt

College: KCTCS System Office

Campus

Location:

KCTCS System Office

Department: SO/TS/Technology Solutions

Total Rewards

• Exceptional health care, vision, and dental coverage for you and your family
• Tuition reimbursement/waiver for you, your spouse, and dependents
• 403(b) retirement plan: a 5% employee contribution receives a 10% employer match
• Vacation/Sick Time
• Work-Life Balance
• 9.5 Paid Holidays
• 2 Weeks Institutional Closing Pay (Last 2 weeks of December) for qualifying positions
• Employee Assistance Program

Position Summary:

The primary purpose of this position is to design and implement enterprise‐level data strategies and security frameworks for databases, data warehouses, data lakes, and advanced analytical platforms. This role ensures the integrity, scalability, and security of data systems across the organization, supporting both operational and analytical needs.

• Define and enforce enterprise standards for database architecture, data structures, programming practices, query optimization, and security protocols.
• Establish best practices for data warehouse and data lake environments.
• Model, design, and construct large‑scale relational databases and data warehouses using advanced techniques such as columnar storage, star‑schema, speed tables, fact‑dimension modeling, and AI‑driven data modeling.
• Optimize data models for performance and scalability across enterprise systems.
• Develop and implement enterprise security strategies for data warehouses and related infrastructure.
• Ensure compliance with organizational and regulatory data security standards.
• Design and optimize workflows for Oracle Cloud Infrastructure and Oracle Analytics Cloud.
• Integrate AI systems into existing data warehouse structures and enhance system performance and functionality.
• Design and maintain Extract, Transform, Load (ETL) processes for efficient data movement between source and target systems.
• Ensure data quality and consistency across all enterprise data platforms.

A technical advisor who has experience with a wide variety of client and back‑end systems, understands and solves the challenges of developing on various client platforms and interfacing with back‑end systems and the vendors that host them. Work across functional and technical teams within Technology Solutions, Marketing, and other business units to drive consensus in product development and launch cycles for each application or feature.

Work with vendors and technical teams to define application requirements and features for students, faculty, and staff. Provide security leadership and support for all KCTCS IT areas.

Bachelor's Degree and four (4) years of relevant experience or equivalent.

Master's Degree and six (6) years of relevant experience or equivalent.

• Programming in SQL, PL/SQL, T‑SQL, Phyton, Java, Unix Shells, Redshift, Oracle Data Integrator, AWS Glue, BI Publisher, SQR, XML Publisher, PS Query, etc.
• Has a strong knowledge of relational, columnar, and multi‑dimension databases (Oracle, Redshift and Snowflake preferred).
• Strong verbal, presentation, and written communication skills.
• Experience with responsive design and programming.
• Functional knowledge of Identity Management Systems.
• Experience with Oracle Cloud environment on Oracle Analytic solutions including:
  Oracle Analytics Server (OAS), Oracle Data Integrator (ODI), Autonomous (ATP & ADW), Base Oracle database and Oracle Cloud Identify Management (IAM‑SSO).
• Experience developing and maintaining reporting solutions in Oracle Cloud Infrastructure.
• Familiar with Oracle Cloud administration and management processes to maintain the KCTCS Cloud Data Analytics cloud data warehouse environments.

Employee Rights - Employee Polygraph Protection Act

Equal Opportunity Employer - The Kentucky Community and Technical College System is an equal educational and employment opportunity institution.