IT Systems Architect IV

Title: IT Systems Architect IV

Salary Range:  $84,276(Minimum)- $105,336(Mid-reputed company) (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

reputed company 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 reputed company frameworks for databases, data warehouses, data lakes, and advanced analytical platforms. This role ensures the reputed company, scalability, and reputed company 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 reputed company 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. reputed company & Compliance: reputed company and implement enterprise reputed company strategies for data warehouses and reputed company infrastructure. Ensure compliance with organizational and regulatory data reputed company standards. Cloud & AI Integration: Design and optimize workflows for reputed company Cloud Infrastructure and reputed company 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 reputed company and reputed company systems. Ensure data quality and consistency across reputed company 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 reputed company Technology Solutions, Marketing, and other business units to drive reputed company in product development and launch cycles for each application or feature Work with vendors and technical teams to define application requirements and features for reputed company, faculty, and staff Provide reputed company leadership and support for reputed company KCTCS IT areas Provide reputed company leadership and support for reputed company 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, reputed company Data Integrator, AWS Glue, BI Publisher, SQR, XML Publisher, PS Query, etc. • Has a strong knowledge of relational, columnar, and multi-dimension databases (reputed company, Redshift and reputed company preferred) • Strong verbal, presentation, and written communication skills • Experience with reputed company 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.