Kentucky Community & Technical College System
IT Systems Architect IV
ETL
SQL
Unix
Edtech.com's Summary
KCTCS System Office is hiring an IT Systems Architect IV. The role involves designing and implementing enterprise-level data strategies, security frameworks for databases, data warehouses, data lakes, and advanced analytical platforms, ensuring data integrity, scalability, and security to support operational and analytical needs.
Highlights
- Design enterprise standards for database architecture, query optimization, and security protocols.
- Model and construct large-scale relational databases and data warehouses using advanced techniques such as star-schema and AI-driven data modeling.
- Develop and enforce security strategies and ensure regulatory compliance for data systems.
- Optimize workflows integrating Oracle Cloud Infrastructure and Oracle Analytics Cloud with AI systems.
- Design and maintain ETL processes ensuring data quality and consistency.
- Strong programming skills required in SQL, PL/SQL, T-SQL, Python, Java, Unix Shells, and tools like Oracle Data Integrator, AWS Glue, BI Publisher.
- Knowledge of relational, columnar, and multi-dimensional databases, preferably Oracle, Redshift, and Snowflake.
- Bachelor's degree with 4 years relevant experience required; Master's degree with 6 years relevant experience preferred.
- Collaborate with functional and technical teams, vendors, and internal stakeholders in Technology Solutions and Marketing departments.
- Salary starts at $84,276 with a 12-month contract term offering competitive benefits including health coverage, tuition reimbursement, retirement plan, and paid holidays.
IT Systems Architect IV Full Description
Title: IT Systems Arhitect IV
Salary Range: $84,276 (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
KCTCS System Office offers a competitive benefits package and an attractive work environment that supports excellence, innovation, and creativity, including:
- 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
Job Summary
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.
Key Responsibilities:
Data Strategy & Standards:
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.
Database & Data Warehouse Design:
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.
Security & Compliance:
Develop and implement enterprise security strategies for data warehouses and related infrastructure.
Ensure compliance with organizational and regulatory data security standards.
Cloud & AI Integration:
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.
ETL & Data Movement:
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.
Job Duties:A technical advisor who has experience with a wide variety of client and back-end systems, understand and solve the challenges of developing on the various client platforms and interfacing with the 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
Provide security leadership and support for all KCTCS IT areas
Minimum Qualifications:Bachelor's Degree and four (4) years of relevant experience or equivalent.
Preferred Qualifications:Master's Degree and six (6) years of relevant experience or equivalent
Additional Skills Requested:
• 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.
Employee Rights - Employee Polygraph Protection Act
Equal Opportunity Employer - The Kentucky Community and Technical College System is an equal educational and employment opportunity institution.
Similar Jobs
Operating Systems Administrator
California State University, Long Beach
🇺🇸 Long Beach, CA
Corporate IT Administrator
Campus
🇺🇸 Hybrid - Atlanta, GA
IT Accessibility Lead
Arizona State University
🇺🇸 Hybrid - Tempe, AZ
Network Services Engineer
Tidewater Community College
🇺🇸 Norfolk, VA
Desktop Support Engineers
University of Utah
🇺🇸 Salt Lake City, UT
