Region Name: State of Indiana
Title/Role: Data Analyst (717178)
Start Date: 08/21/2023
End Date: 02/17/2024
Worksite Address: 500 North Meridian Street, Indianapolis, IN 46204
Work Arrangement: Hybrid
Candidate must currently reside in the state of IN
Job Duties:
Design, develop, and format polished data visualizations (reports and dashboards) to support business requirements. Focus on Visualization Creation using data to perform reporting and direct analysis. Perform analysis that may be descriptive, diagnostic, predictive, or prescriptive. Responsible for maintaining dashboards, generating reports, preparing data visualizations, and using data to forecast or guide business activity. Present data in a fashion that is easy to understand with proper documentation and user testing for successful adoption. Publish workbooks to appropriate QA, production, and public servers. Meet project deadlines and requirements. Participate in and contribute to the CSB-IT Data Services Team. Performs other related duties as assigned.
Job Requirements:
Experience with Analyzing data, identify trends, interpret results, and prepare reports and data visualizations for bureau leadership, county partners, and other stakeholders. Experience with creating Analytical, Time Series, Metrics, Rankings, Statistical, Christmas Tree, Tracking, and Expenditure reports. Experience with using excel data analysis functions, scripts, reports, and charts. Experience with writing SQL queries to get data from different databases like DB2 Z/OS; AWS Aurora and AWS RDS and Data Warehouse. Experience in working with Cross Technical, Functional and Business Teams. Capable to understand business requirements and develop reports based on requirements. Capable to work individually and work in a team environment.
| Skill | Required / Desired | Amount | of Experience |
| Bachelor's degree in computer science or related field, or equivalent experience. | Required | 5 | Years |
| Experience using Excel Data analysis Functions, scripts, reports, and charts | Required | 5 | Years |
| Experience with Data Preparation for Reports and Dashboards | Required | 5 | Years |
| Business Intelligence experience, Data Warehouse and Reporting | Required | 5 | Years |
| SQL and PL/SQL | Required | 5 | Years |
| Experience establishing Connections with different Data Sources | Required | 3 | Years |
| Tableau Platform (Tableau Desktop, Tableau Prep Builder, Tableau Server) | Desired | | |
| Experience with ETL frameworks and online analytical processing (OLAP) | Desired | | |
| Python and R Languages | Desired | | |
| Experience with Mainframe and DB2 Z/OS | Desired | | |
| Experience with Salesforce | Desired | | |
| Experience with MuleSoft | Desired |