Data Warehousing Analyst

Position Information

Position Details Position Title Data Warehousing Analyst Position Number 994554 Position Status Full-Time Regular Work Hours M-F, 8-5 (potential for hybrid schedule after training based on team needs) Location Wichita, KS - WSU Main Campus Description University Overview Wichita State University has a long tradition of innovation and entrepreneurship that spurs the economy and serves the needs of the local community.

This is the place where anything is possible. Where collaboration and innovative ideas shape the future, and entrepreneurship is in our bones.

If you have the creativity, passion and insight to help us build a brighter future for our city, state and world this is the place where you belong.

Position Specific Responsibilities 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! 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.

Commitment Wichita State University is the only urban-serving public university in Kansas and has the most diverse student body of all the Kansas state universities.

Wichita State recruits, employs, trains, compensates, and promotes regardless of age, ancestry, color, disability, ethnicity, gender, gender expression, gender identity, genetic information, marital status, national origin, parental status, political affiliation, pregnancy, race, religion, sex, sexual orientation, or status as a veteran.

Wichita State University has a clear goal in this regard : to be a university that promotes inclusive excellence at every level of our organization.

We pride ourselves on being the most innovative university in Kansas, delivering the best educational experience to our students with the distinction for opening pathways to real-life learning, applied research and career opportunities that make people want to stay in Kansas.

Our campus provides an experience that promotes all forms of inclusive excellence; a place to learn, work, live and play.

Requirements Minimum Education

High school diploma or equivalent by hire date

Preferred Education 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.

Preferred Experience Knowledge, Skills and Abilities

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

Licenses, Certificates and Registrations

None

Sponsorship No, due to export control requirements, the University cannot sponsor applicants for employment authorization for this position.

User Export Compliance This position requires access to EAR or ITAR controlled technologies. Applicants are required to be eligible for employment under .

export control laws and must meet the requirement of being a . Citizen . Additional Information Special Instructions Department Information Department 102537-ITS Applications Development Salary Information Pay Information Range beginning at $71,000 / yr, adjusted based on qualifications Overtime Eligibility No Eligible for Shift Differential?

No Benefits Eligible? Yes Benefit Information Wichita State University and the State of Kansas offer a variety of benefit programs which are designed to enhance employment.

Many of these benefits are available immediately and some with a wait period.

• Comprehensive health, dental, vision and supplemental coverage offerings
• Retirement plan with generous employer contributions
• Basic employer-paid life insurance and optional life insurance
• Employee and Dependent Tuition Assistance Program
• Generous time off accruals
• Full time 12-month employees typically accrue 22 vacation days and 12 days of sick leave per year in addition to 9 annual paid holidays designated by the State of Kansas.
• Additional holidays and / or a discretionary day can be granted by the governor each year.
• Part-time employee accruals are on a pro-rated basis.
• Paid Parental Leave
• State Shared Leave Program
• Employee Assistance Program
• Discounts on campus and throughout Wichita through ShockerStart

You can find more information on benefits in the .

Requisition Details

Requisition Details Posting Date 05 / 31 / 2024 Closing Date Proposed Start Date 08 / 04 / 2024

Physical Demands

Physical Requirements Physical Requirements

Ability to remain in a stationary position. Frequent 60-90%

Ability to operate a computer and other office equipment including but not limited to phone, printers, copiers, and calculators. Frequent 60-90%

Ability to communicate with others and accurately exchange information. Frequent 60-90%

Physical Weight Category Sedentary : Exerting up to 10 pounds of force occasionally and / or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects.

Sedentary work involves remaining stationary most of the time. Additional Physical Demands Physical Demands Atypical Physical Job Requirements