Job Information
Kansas State University Enterprise Data Architect in Manhattan, Kansas
This job was posted by https://www.kansasworks.com : For more information, please see: https://www.kansasworks.com/jobs/12852728
\ \ Enterprise Data Architect\ \ Department: 3670003050 Data, Assess & Inst Research\ Job no: 516829\ Employment type: Staff Full Time (Unclassified - Term)\ Location: Manhattan, Kansas\ Worksite: Hybrid eligible (partially remote, must reside in US)\ Categories: Computer Science / Information Technology\ Pay Grade: 13A\ \ \ About This Role:\ As a part of the work of Building Operational Excellence for a Next-Generation Land-Grant University and associated organizational changes, the office of Data, Assessment, and Institutional Research (DAIR) has assumed expanded roles and responsibilities in the areas of data warehouse design, implementation, maintenance and data management. DAIR is the steward of both the current (SQL Server) and the new cloud (Snowflake) data warehouse. This position is responsible for developing data design of conceptual, logical, and physical models in the data warehouses for business intelligence, analytics and application development. This position will work with data stewards and source system subject matter experts to understand the source systems that the data needs to be pulled from and into the data warehouses. This position will work on maintaining the existing data warehouse and development of the cloud data warehouse.\ \ Why Join Us:\ Kansas State University offers a comprehensive benefits package that includes health insurance, life insurance, retirement plans, paid time off - vacation, sick, and holidays. To see what benefits are available, please visit: https://www.k-state.edu/hcs/benefits\ \ We Support Diversity and Inclusion:\ Kansas State University embraces diversity and inclusion. The university actively seeks individuals who foster a collegial environment and cooperative interactions with coworkers, students, and others. The University is dedicated to promoting the Principles of Community.{target="_blank" rel="noopener"}\ \ Worksite Options:\ This position is eligible for hybrid worksite. Work is performed partially remote and partially on employer premises or designated assignment location. This role is expected to work on-site approximately three (3) days a week OR Employee must have availability to be on campus frequently during the work week.\ \ On-site employment is preferred, and hybrid work schedules are offered to all staff.\ \ At the discretion of the unit leader and to meet staffing needs, employees may be offered 100% remote work arrangements. 100% remote employees will typically be required to travel to the Manhattan campus 1-2 times during each of the fall and spring semesters for 2-5 business days. If the travel distance exceeds a 60-mile radius to the campus, the office will reimburse up to \$500 travel related costs and provide lodging at the university guest housing facility.\ \ Visit this link for K-State\'s guidance and policies on remote work and flexible work arrangements. Remote work agreements are required for all flexible work arrangements and are subject to review. An employee who is working remotely must reside within the United States in order to comply with all federal and state laws, filings, or tax requirements.\ \ What You\'ll Need to Succeed:\ Minimum Qualifications:
- Requires a bachelor\'s degree
- Five years of relevant experience
- This position may use an educational equivalency as determined relevant by a hiring manager.
\ Preferred Qualifications:\ 5+ years of relevant experience, including combination of the following:
Bachelor\'s degree in computer science or related field degree
Development of a data warehouse
Ability to create and review data models and design of overall data architecture
Data Integration concepts and strategies: ETL, EL-T, Data Warehousing, event-based processing
Database knowledge in SQL Server, Oracle, MySQL, or PostgreSQL
Programming in SQL, PL/SQL, etc
Experience in Higher Education
Experience working with Peoplesoft, SQL Server, SSIS, Oracle Financials
Working with ERP data and Reporting Systems/BI Experience with Informatica IICS and/or other cloud-based integration solutions
Mentoring and leading by example
Excellent oral and written and communication skills
Critical thinking ability
Excellent logical, analytical, and strong problem-solving capacity
Able to find root causes of problems and quickly determine efficient solutions
Personable and able to work in a team environment and respectfully interact with technical and nontechnical users
\<