Database Programmer,Data Analyst (Business Analyst)

The Kelley School of Business at Indiana University is a comprehensive provider of top-tier business education with a full portfolio of undergraduate, graduate, doctoral, and executive programs on campuses in Bloomington and Indianapolis, and online worldwide. The Kelley School has been creating career momentum for 100 years, going from 70 students in 1920 to an enrollment of more than 12,000 students today. Our innovative curriculum is built on personal development, teamwork, and experiential learning with an emphasis on global and social responsibility. Our success is reflected in our reputation among academic peers, our career placement statistics, and the accomplishments of more than 127,000 living alumni around the globe.
Job Summary
Responsibility in both data analysis and IT systems. Data analyst duties include
Department Specific Requirements

• Responsibile for understanding and analyzing how data is collected, stored, processed and used in the school.
• Generates data reports or ETL packages for clients in an accurate, secure and consistent way.
• Provides data and database design to application programmers as part of system development work.
• Toubleshoots data-related problems and answer data-related inquires.
• Documents processes or solutions to ensure work continuity and consistency.
• Manages system development projects for the School and analyzes user requirements and business processes.
• Designs, Develops and Implementes databases.
• Performs Data Modeling.
• Performs Data Flow Generation.
• Troubleshoots issues and develops normalized database solutions.
• Uses software such as SQL, SSIS Package Design, Tableau, Power BI, Data Science, SIS Data Structures, ETL Work, Academic Advisement Report Design.

General Responsibilities

• Conducts experienced assessments to understand client business needs and strategic direction and identifies technology solutions to achieve goals; consults with IT staff and business users to identify, analyze, refine and document business requirements and processes and develop associated solutions.
• Facilitates and leads interviews, focus groups, and workshops to establish current and future business requirements; coordinates the communication between stakeholders and service owners in order to effectively implement solutions.
• Performs experienced business analyses, including construction of data models, business use cases, process flows and technical specifications for transition to IT solutions; establishes system requirements through functional and technical assessments of existing software.
• Provides stakeholders with necessary analysis documentation for buy-in, leadership decision, and implementation; conducts walk-throughs of recommended system functionality and prototypes with business users in small group or large group settings.
• Ensures uniform documentation presentation and content structure including, but not limited to, online documentation.
• Develops test plans and conducts system/integration testing; can test changes, enhancements, and new programs or functions to ensure they meet business needs.

Qualifications
EDUCATION
Required

• Bachelor's degree (preferably in analytic or computer science related field)

WORK EXPERIENCE
Required

• 2 years of business analysis experience working on complex problems and producing concrete, actionable solutions

Combinations of related education and experience may be considered
SKILLS
Required

• Proficient communication skills
• Maintains a high degree of professionalism
• Demonstrates 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
• Demonstrates analytical skills
• Service-oriented and skilled in providing positive, friendly customer service

Preferred

• Knowledge of and experience relational database design, database programming
• Working knowledge of MS SQL Server, Oracle or other RDBMS
• Ability to understand of software development process
• Knowledge of SSIS package design

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 is eligible to work a hybrid schedule (mix between remote and in-person work), subject to change in the future based on university policy and business needs.
Benefits Overview
For full-time staff employees, Indiana University offers a wide array of benefits including:

• Multiple plan options for medical insurance
• Dental insurance
• Health Savings Account with generous IU contribution
• Life insurance, LTD, and AD&D options
• Base retirement plan contribution from IU, subject to vesting
• Additional supplemental retirement plan options
• Tuition benefit for IU classes
• 10 paid holidays per year
• Generous Paid Time Off
• Paid Parental Leave
• Employee Assistance Program (EAP)

Learn more about our benefits by reviewing our online Benefits Brochure .
Job Classification
Career Level: Career
FLSA: Exempt
Job Function: General Administration
Job Family: Business Analysis
Click here to learn more about Indiana University's Job Framework.
Posting Disclaimer
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.
Contact Us
Request Support
Telephone: 812-856-1234
Apply for Job

• Staff Positions
• Sign In
• New User
• Enable Screen Reader Mode