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
\<