Data Warehousing Analyst

About the Role

Begin a fulfilling career with the State of Indiana by joining one of the largest employers in the state, offering a range of opportunities across 60+ agencies. At the Indiana Department of Transportation (INDOT), you'll find a dynamic workplace that serves Indiana citizens, improves our state’s quality of life, and enhances its economic opportunity. INDOT has innovative programs and projects, including Public-Private Partnerships, Green Initiatives, and cutting-edge uses of materials and assets.

This position is with INDOT's Central Office in Indianapolis.

Responsibilities

• Review data loaded into the data warehouse for accuracy.
• Develop, maintain, and support enterprise data warehouse system and corresponding data marts.
• Troubleshoot and tune existing data warehouse applications.
• Conduct research into new data warehouse applications and determine viability for adoption.
• Establish written procedures, guidelines, and develop standards for data system operation.
• Evaluate existing subject areas stored in the data warehouse.
• Incorporate existing subject areas into an enterprise model.
• Research and create new or enhanced components of the data warehouse.
• Confer with management of unit to assist in planning, organizing, and controlling activities of assigned area.
• Prepare project feasibility studies.
• Provide guidance and training for lower-level staff, including helping develop difficult and complex programs.

The job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities. Other duties may change or be assigned at any time with or without notice. This position is exempt from overtime compensation.

Requirements

• Advanced knowledge of Oracle's data warehouse design and Extract, Transform, Load (ETL) design tools, specifically Oracle Data Integrator (ODI).
• Advanced knowledge of data analysis tools such as Oracle SQL Developer and TOAD.
• Advanced knowledge of enterprise database design, Structured Query Language (SQL) - data definition language (DDL) and data manipulation language (DML), and data dictionaries.
• Advanced knowledge of query/report design tools such as Oracle Business Intelligence Enterprise Edition (OBIEE), ThoughtSpot, and Tableau.
• Advanced knowledge of computer hardware/software capabilities and configurations.
• Advanced knowledge of data communication and connectivity, and Windows operating system.
• Ability to perform logic analysis.
• Ability to read and understand complex technical manuals.
• Ability to communicate effectively, both orally and in writing.
• Ability to apply theories, principles, and methodologies to existing computer or database software.
• Ability to guide and coordinate the work of others.

A degree is not required. However, at least 7+ years of experience applying the outlined knowledge, skills, and abilities in a similar role may be considered. Individuals should have the ability to perform essential functions with or without reasonable accommodation.

Supervisory Responsibilities

This role may be utilized in a supervisory capacity based on agency needs.

Pay

The salary for this position traditionally starts at $70,122.00.

Benefits

• Three (3) medical plan options (including RX coverage) as well as vision and dental plans.
• Wellness Rewards Program: Complete wellness activities to earn gift card rewards.
• Health savings account, which includes bi-weekly state contribution.
• Deferred compensation 457(b) account (similar to 401(k) plan) with employer match.
• Two (2) fully-funded pension plan options.
• A robust, comprehensive program of leave policies covering a variety of employee needs, including:
  • 150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers.
  • Up to 15 hours of paid community service leave.
  • Combined 180 hours of paid vacation, personal, and sick leave time off.
  • 12 paid holidays, 14 on election years.
• Education Reimbursement Program.
• Group life insurance.
• Referral Bonus program.
• Employee assistance program that allows for covered behavioral health visits.
• Qualified employer for the Public Service Loan Forgiveness Program.
• Free Parking for most positions.
• Free LinkedIn Learning access.