Data Warehousing Analyst

State of Indiana; Indianapolis (IN); On-site; USD 63,000 - 77,000; Full time

Benefits offered by this job

Medical, vision and dental plans

Wellness rewards program

Health savings account (HSA)

Pension plans (2 options)

Paid leave and holidays

Job summary

State of Indiana, via INDOT, is seeking an experienced data warehouse professional to review and enhance our enterprise data warehouse and related data marts in Indianapolis. You will troubleshoot, optimize, and expand data warehouse components, working with ODI, OBIEE, ThoughtSpot and Tableau.

The role emphasizes data analysis, governance, and mentoring others, with a possibility of supervisory responsibilities depending on agency needs.

Qualifications

• Advanced knowledge of Oracle data warehouse design and ODI.
• Advanced knowledge of SQL, DDL/DML and data dictionaries.
• Advanced knowledge of OBIEE, ThoughtSpot and Tableau.
• Advanced knowledge of hardware/software capabilities and Windows OS.
• Ability to perform logic analysis and read complex technical manuals.
• Effective written and verbal communication skills.
• Ability to guide and coordinate the work of others.
• A degree is not required; 7+ years of relevant experience may be considered.

Responsibilities

• Review data loaded into the data warehouse for accuracy.
• Develop, maintain, and support enterprise data warehouse and data marts.
• Troubleshoot and tune data warehouse applications.
• Research new data warehouse applications and assess viability.
• Establish procedures and standards for data system operation.
• Evaluate existing data warehouse subject areas and integrate them into an enterprise model.
• Develop new or enhanced components of the data warehouse.
• Collaborate with management to plan, organize and control activities.
• Prepare project feasibility studies.
• Provide guidance and training for lower-level staff.

Skills

ODI (Oracle Data Integrator)

Oracle SQL Developer

SQL (DDL/DML)

OBIEE

ThoughtSpot

Tableau

Windows OS

Data warehousing

ETL design

Mentoring/leadership

Tools

Oracle ODI

TOAD

OBIEE

ThoughtSpot

Tableau

Job description

Work for Indiana

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 state, you'll find competitive compensation, a robust benefits package and a commitment to work-life balance. Most importantly, you'll have the chance to make a real and measurable impact on the lives of Hoosiers across Indiana.

About The Indiana Department Of Transportation

The Indiana Department of Transportation (INDOT) provides a dynamic workplace that serves Indiana citizens, improves our state’s quality of life, and enhances its economic opportunity. INDOT has a number of innovative programs and projects, including Public-Private Partnerships, Green Initiatives, and cutting-edge uses of materials and assets. As part of the State of Indiana, INDOT offers a competitive total compensation package, as well as outstanding work/life balance. Whether you are an established professional in the transportation field or just starting your career, INDOT has exciting and challenging opportunities for you.

Location:

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

Salary

The salary for this position traditionally starts at $70,122.00 but may be commensurate with education and work experience. Use our Compensation Calculator to view the total compensation package.

A Day In The Life

• 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 determines viability for adoption.
• Establish written procedures, guidelines and develops 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 that are required of the employee. Other duties, responsibilities, and activities may change or be assigned at any time with or without notice.

This position is exempt from overtime compensation for additional work hours which may be required to complete essential functions or other assigned work. Exempt employees may work more than 75 hours in a pay period without additional compensation and must report a minimum of 75 hours per pay period of work hours and/or paid leave taken to receive their base biweekly salary.

What You'll Need For Success

• Advanced knowledge of Oracle's data warehouse design and Extract, Transform, Load (ETL) design tools, specifically Oracle Data Integrator (ODI) required.
• Advanced knowledge of data analysis tools such as Oracle SQL Developer and TOAD required.
• Advanced knowledge of enterprise database design, Structured Query Language (SQL) - data definition language (DDL) and data manipulation language (DML), and data dictionaries required.
• Advanced knowledge of query/report design tools such as Oracle Business Intelligence Enterprise Edition (OBIEE), ThoughtSpot and Tableau required.
• Advanced knowledge of computer hardware/software capabilities and configurations required.
• Advanced knowledge of data communication and connectivity, and Windows operating system required.
• Ability to perform logic analysis required.
• Ability to read and understand complex technical manuals required.
• Ability to communicate effectively, both orally and in writing required.
• 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/Direct Reports

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

Benefits Of Employment With The State Of Indiana

• 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 but not limited to:
  • 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

Equal Employment Opportunity

The State of Indiana is an Equal Opportunity Employer and is committed to recruiting, selecting, developing, and promoting employees based on individual ability and job performance. Reasonable accommodations may be available to enable individuals with disabilities to complete the application and interview process as well as perform the essential functions of a role. If you require reasonable accommodations to complete this application, you can request assistance by contacting the Indiana State Personnel Department at [e-mail].