Enterprise Data Architect
Application Procedure:
How to Apply:
Please submit the following documents:
- Cover letter
- Resume
- Three professional references
Screening of Application Begins:
Immediately and continues until position is filled.
Equal Employment Opportunity:
Kansas State University is an Equal Opportunity Employer, valuing diversity in all aspects of employment.
Background Screening Statement:
Background screening will be conducted as part of the employment process.
Job Duties
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.
Job Qualifications
What You'll Need to Succeed:
Minimum Qualifications:
- Bachelor's degree
- Five years of relevant experience
- Educational equivalency may be considered
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.
Institution Description
Benefits
Why Join Us:
Kansas State University offers a comprehensive benefits package including health insurance, life insurance, retirement plans, paid time off – vacation, sick, and holidays. For details, visit: https://www.k-state.edu/hcs/benefits
We Support Diversity and Inclusion:
Kansas State University values diversity and inclusion, actively seeking individuals who promote a collaborative environment and positive interactions. KSU is committed to fostering the Principles of Community.
Worksite Options:
Visit this link for KSU’s guidance and policies on remote work and flexible work arrangements.
Search for openings in IR, effectiveness, assessment, planning, and related fields at higher education institutions in the U.S. and abroad.