At University Information Technology Services (UITS) we ensure a workplace that encourages growth, flexibility, and creativity, as well as a culture that champions inclusion, diversity, and overall employee well-being through programs supported university-wide. Our core values define who we are, how we act, and what we aspire to, which helps us to make amazing things happen in each neighborhood, community, and county we touch. As an Equal Opportunity Employer, we believe in each person's potential, and we'll help you reach yours.
The Enterprise Applications team at Indiana University designs, develops, and operates university-wide software systems. In this role, you will assist with the design and support of ETL processes using Microsoft SSIS. You will become part of a talented team that creates innovative solutions that help to power Indiana University.
Job Summary
Department Responsibilities:
Designs and implements SSIS solutions within architectural, security, and code quality guidelines considering performance, scalability, and sustainability
Troubleshoots and maintains existing SSIS processes
Estimates software engineering effort needed to complete tasks
Implements SQL development, including T-SQL programming
Designs relational schemes
Raises issues with requirements and technical implementation. Work in a fast-paced software engineering project team using agile software development techniques
Diagnoses and resolves software performance problems and opportunities
Implements data security measures
General Responsibilities:
Provides experienced design, development, and implementation of databases with an emphasis on performance, security, and stability
Determines technical feasibility and design solutions related to hardware and software requirements
Conducts related planning, programming, data modeling, data flow diagramming, structural design, and testing
Delivers and reports on data through the development of stored procedures, triggers, functions, and views
Creates database queries, indexes, and writes data load scripts
Designs, tunes, and indexes data tables
Troubleshoots issues and develops normalized database solutions
Reviews monitoring tools and query execution plans to maintain or increase query efficiency
Performs root cause analysis on query performance issues
Creates and maintains documentation for all database development projects and/or activities
Researches and stays current with database development trends and best practices
Recommends database standards, policies, and procedures
Qualifications
EDUCATION
Required
Bachelor's degree
Preferred
Degree in computer science, business systems, or a related field
WORK EXPERIENCE
Required
2 years of database planning, design, development or related experience
Preferred
4 years of software development or related experience
2 years of experience in the development of SSIS packages
Combinations of related education and experience may be considered
SKILLS
Required
Proficient communication skills
Maintains a high degree of professionalism
Demonstrated time management and priority setting skills
Demonstrates a high commitment to quality
Possesses flexibility to work in a fast paced, dynamic environment
Seeks to acquire knowledge in area of specialty
Highly thorough and dependable
Demonstrates a high level of accuracy, even under pressure
Preferred
Experience in SQL, T-SQL, PL-SQL
Knowledge of relational databases
Demonstrated knowledge of data warehouse concepts (data normalization, star schema, etc.)
Demonstrated knowledge of all phases of Software Development Lifecycle
Excellent interpersonal skills with the ability to establish working relationships with individuals at varying levels within the organization
Performs well in high-energy, dynamic, and team-oriented environments
Demonstrates attention to detail, organization, and timeliness to meet service expectations
Demonstrates effective problem-solving skills
Work independently with little supervision
Firsthand experience with Agile software development methodologies
Working Conditions / Demands
This role requires the ability to effectively communicate and to operate a computer and other standard office productivity equipment. The position involves sedentary work as well as periods of time moving around an office environment and the campus. The person in this role must be able to perform the essential functions with or without an accommodation.
Work Location
This position can be based out of any IU campus.
This position also has the possibility of a remote working arrangement.
Due to the COVID-19 pandemic, there may be differences in the working conditions as advertised in our standard job postings (e.g., the ability to travel from one campus to another, etc.). If you are invited for an interview, please discuss your questions or concerns regarding the working conditions at that time.
This posting is scheduled to close at 11:59 pm EST on the advertised Close Date. This posting may be closed at any time at the discretion of the University, but will remain open for a minimum of 5 business days. To guarantee full consideration, please submit your application within 5 business days of the Posted Date.
If you wish to include a cover letter, you may include it with your resume when uploading attachments.
New employees will be provided with information regarding Indiana University's COVID-19 vaccine policy, which includes the opportunity to request an exemption. To learn more, view our COVID-19 vaccine information page .
Equal Employment Opportunity
Indiana University is an equal employment and affirmative action employer and a provider of ADA services. All qualified applicants will receive consideration for employment based on individual qualifications. Indiana University prohibits discrimination based on age, ethnicity, color, race, religion, sex, sexual orientation, gender identity or expression, genetic information, marital status, national origin, disability status or protected veteran status. Indiana University does not discriminate on the basis of sex in its educational programs and activities, including employment and admission, as required by Title IX. Questions or complaints regarding Title IX may be referred to the U.S. Department of Education Office for Civil Rights or the university Title IX Coordinator. See Indiana University's Notice of Non-Discrimination here which includes contact information .
Campus Safety and Security
The Annual Security and Fire Safety Report, containing policy statements, crime and fire statistics for all Indiana University campuses, is available online . You may also request a physical copy by emailing IU Public Safety at iups@iu.edu or by visiting IUPD.
About Indiana University Purdue University Indianapolis
Founded in 1820, Indiana University is the state’s public university system, comprised of two core campuses—IU-Bloomington and IUPUI—and six regional campuses located throughout the state. Combined, the total student population is more than 114,000 undergraduate, graduate and professional school students. IU is one of the largest employers in the state, with over 20,000 faculty and staff. Indiana University is an equal employment and affirmative action employer and a provider of ADA services. Diversity and inclusion remains a core commitment to IU’s mission to cultivate an educational environment that supports equal access, participation and representation on all of its campuses and that provides educational and career opportunities for all.
