Enterprise Data Architect - Kansas State University

Manhattan, KS

About the Job

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.

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.
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 Proven experience in On-Premise, Cloud and Hybrid environments Clear understanding of software development life cycle phases and practices Other Requirements: Applicants must be currently authorized to work in the United States at the time of employment.
How to Apply:	Please submit the following documents: Cover letter Resume Three professional references
Screening of Applications Begins:	Immediately and continues until position is filled.
Anticipated Hiring Pay Range:	$80,000 - $110,000
Equal Employment Opportunity:	Kansas State University is an Equal Opportunity Employer. All applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, gender identity, age, national origin, disability or status as a protected veteran.
Background Screening Statement:	In connection with your application for employment, Kansas State University will procure a Background Screen on you as part of the process of considering your candidacy as an employee.

Source : Kansas State University