Data Warehousing Analyst

  • Wichita State University
  • Wichita, KS & hybrid
  • Jul 02, 2024
Full time Database SQL XML Other Research

Job Description

Imagine stepping into a well-oiled machine with a data maturity level that is higher than most. Our data is clean, organized, and ready for action, supported by the latest tools (IBM products). What a dream that would be…… Well, you don’t have to dream anymore as that could be the reality for a certain someone.  


Being an ETL Master is the heart of this role, and you need to be a pro at ensuring seamless data migration and transformation. Work closely with many across the university at all stages in their decision-making process to assist in their data needs. We are not a silo here with our cozy team, we are creating a cross-functional team to conqueror all for the future. Learn the ins and outs of our business processes, how we accumulate data, and what happens next. 

What’s in It for You?

    • Professional Growth: We support your growth with on-the-job training, self-taught opportunities, and training conferences. Your career development is a priority.
    • Innovative Environment: Working with new and advanced tools and technologies. We know how to do more with what we have, making it work for us rather than being restricted with it’s limitations. 
    • Community & Collaboration: Enjoy a role that’s far from siloed. You’ll interact with all areas of campus, ensuring your work is varied and engaging.
    • Impactful Work: Play a key role in maintaining our “premiere” data label. Your contributions will be recognized and valued.

Our desired qualities in a new team member, that would couple with the technical skills set above are as follows. 

  • Curious learner, motivated, eager, and constantly inquisitive. 
  • Collaborative communicator and active listener to understand the needs of your customers. 
  • Problem solver to tackle both technical and data issues with ease. 
  • Organized multitasker, managing your time effectively, prioritize projects, and handle tasks without feeling overwhelmed. 
  • Campus enthusiast where you’re excited to be part of the campus community.

If you’re ready to bring your data wizardry to a dynamic team & great opportunity for yourself, apply now! 

Official applications & to learn more about the role, visit: https://jobs.wichita.edu/postings/32585 

Summary of Responsibilities

Works in the data warehouse environment which includes data design, database architecture, metadata, and repository creation.

Essential Functions

  • Assists in the development, maintenance, and support of an enterprise data warehouse system and corresponding data marts.
  • Troubleshoots and tunes existing data warehouse applications.
  • Assists in creating new or enhanced components of the data warehouse.

Minimum Education

High school diploma or equivalent by hire date

Minimum Experience

Six (6) years of experience in data warehousing. Every 30 hours of college coursework can be substituted for one (1) year of experience.

Knowledge, Skills and Abilities

  • Well versed in development and application of Relational databases, e.g. Oracle and SQL Server Relational databases, e.g. Oracle and SQL Server.
  • Well versed in design, development and application of data warehouse concepts.
  • Experience and application of ETL Tools, e.g. Informatica, SSIS, DataStage.
  • Well versed in development and application of reporting tools, e.g. Cognos, Tableau, PowerBI
  • Excellent SQL query writing skills.
  • Excellent communications skills.

Pay Info

Range beginning at $71,000/yr, adjusted based on qualifications

Occupations

Database Development-Administration, Usability-Information Architecture

URL

Official applications & to learn more about the role, visit: https://jobs.wichita.edu/postings/32585 

Salary

Range beginning at $71,000/yr, adjusted based on qualifications

Listing Logo