> Markdown version of [/jobs/ext/2148598-data-warehousing-analyst](https://www.wearedevelopers.com/jobs/ext/2148598-data-warehousing-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehousing Analyst - **Company:** State of Indiana - **Location:** Indianapolis, IN, United States - **Experience:** Expert - **Salary:** $70,122.0 - **Contract:** Permanent contract - **Skills:** Microsoft Windows, Data Analysis, Databases, Data Transmissions, Data Definition Language, Data Dictionary, Extract Transform Load (ETL), Data Manipulation Languages, Data Mart, Data Systems, Data Warehousing, Database Design, Oracle Business Intelligence Enterprise Edition, Oracle Data Service Integrator, Oracle (Applications), Oracle SQL Developer, Software Systems, SQL Databases, Tableau (Software), Toad (Software), Custom Reports - **Published:** August 20, 2026 - **Apply:** https://www.juju.com/job/00000000go08fi ## About the Role + 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. ## Description + 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [The Data Mesh as the end of the Datalake as we know it](https://www.wearedevelopers.com/videos/156-the-data-mesh-as-the-end-of-the-datalake-as-we-know-it) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)