Application Developer - Sql

About Us?

Indiana Public Retirement System (INPRS’) is among the largest 100 pension systems in the United States. INPRS serves the needs of approximately 473,000 members and retirees representing approximately 1,244 employers, including public universities, school corporations, public safety, municipalities and state agencies. The Indiana Public Retirement System is a public pension fund who manages approximately over $40 billion in assets, making it one of the largest in the United States. We are located in the heart of the city, in downtown Indianapolis, near the circle & across the street from our monumental state house. This position will allow a flexible (hybrid) work arrangement, but will require Indiana state residency. We will pay for relocation assistance. This position is not eligible for H-1B or any other kind of temporary or permanent sponsorship for work authorization by the Indiana Public Retirement System. Therefore, if you will require sponsorship from us for work authorization now or in the future, we cannot consider your application at this time.

Why Join?

INPRS’ believes that people are the foundation of our success. It takes people with different backgrounds, ideas, and strengths to be successful. Balance in life is important. We strive to have a flexible and supportive environment while not sacrificing service to our members. We pride ourselves by modeling a collaborative, diverse and inclusive environment for our employees. Our mission. “As fiduciaries, educate stakeholders, collect necessary contributions, and prudently manage member assets to deliver promised defined benefit and defined contribution benefits and services”.

Your Impact?

Incumbent works under limited supervision performing application systems analysis and programming duties. This encompasses performing program design, development, unit testing, and defect correction. As well as maintain and develop ETL solutions using Oracle Data Integrator (ODI) or related ETL tools to support the INPRS EDW/BI platform. A strong working knowledge of one or more software development methodologies is expected along with familiarity with business problem analysis, system design and systems integration.

Essential Duties:

• Assists in research, fact-finding and analyzing user needs and problems required to develop and maintain information systems.
• Assists in preparing requirements, functional design, physical design and other relevant system design components.
• Assist and support business users in reporting and KPI’s using the Looker tool set.
• Executes task conforming to IT techniques, standards, policies and procedures.
• Provides documentation for new or modified information systems and/or application software programs.
• Monitors completed application software systems to ensure proper execution and performance.
• High level of expertise in report writing, analytics, and executive decision support
• Understanding of underlying table structure and application architecture.
• Familiarity with table based and SQL based APIs.
• Ability to develop and support data Extract, Transform, and Load (ETL) processes
• Ability to maintain and develop ETL solutions using Oracle Data Integrator (ODI) or related ETL tools to support the INPRS EDW/BI platform.
• Providing maintenance and support of IT applications and systems.
• Employing new, as well as tested and proven technologies to develop technical solutions to meet business requirements.
• Proactively observing system performance and initiating improvements as necessary.
• Promoting the goals and objectives of the IT Department.
• Ability to thoroughly test and certify enhancements and bug fixes.
• Highly motivated with strong analytical, interpersonal and communication skills.
• Strong technical skills with desire to stay up to date with technology changes.
• Demonstrate ability to learn the various provisions of a multiple plan pension system and concepts related to institutional investment and retirement planning.
• Trouble shooting user problems and general user support

Experience and Qualifications:

• Bachelors degree preferred; will consider years of experience in place of degree.
• 2-5 years’ experience developing, supporting, and implementing IT solutions.
• Working knowledge of SQL.
• Any of the following tool knowledge is a Plus:
  • Tableau
  • Looker
  • Power BI
  • MuleSoft

Comprehensive Benefits Package:

• Competitive compensation
• Flexible Work Arrangement (3 days in-person & 2 days remote)
• Healthcare coverage (medical / dental / vision)
• Health savings account with employer contribution
• Prescription coverage
• Employer funded retirement plan (pension plan)
• Deferred compensation plan (employer and/or employee contribution plan)
• Flexible spending account
• Work/life balance (37.5 hours weekly)
• 12 paid holidays; 14 during election year
• Paid leave (personal, sick, vacation)
• Tuition reimbursement
• Professional credential reimbursement
• Group life insurance
• Employer-paid downtown parking

If you are interested in this position, please submit your application and resume for review. For more information about our organization, please visit our INPRS Careers Page: https://www.in.gov/inprs/careers.htm.

Equal Employment Opportunity:

The Indiana Public Retirement System (INPRS) is an Equal Opportunity Employer and is committed to recruit, select, develop, and promote employees based on individual ability and job performance. Our policy is to provide equal employment opportunity to all people in all aspects of employer-employee relations without discrimination because of race, color, creed, religion, sex, national origin, ancestry, age, sexual orientation, gender identity, physical or mental disability, or veteran status. We will comply with the spirit as well as the letter of all applicable state and federal laws.

Indiana Public Retirement System has established a culture that welcomes equity, inclusion, and opportunity for all employees and applicants. We encourage you to apply if you feel you have the transferrable skills to be successful in this position and we look forward to reviewing your application.