Data Analyst

Title Data Analyst Location Indianapolis, IN (Hybrid) Rate DOE /If your experience and skills match call us immediately for submission Duration 7 Months Interview Type Either Webcam Interview or In Person Job Type C2C,C2H,W2 Experience 5 Years     Job Description  

Resource will be responsible for the activities of Data Analyst for the State of Indiana's child support system. Resource will work under direction of the Indiana Department of Child Services (DCS), Child Support Bureau (CSB) IT office.

Candidate must currently reside in the state of IN.

Job Duties:

• Design, develop, and format polished excel and tableau 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 and developing excel and tableau dashboards and 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 tableau 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 excel and tableau reports and data visualizations for bureau leadership, county partners, and other stakeholders.
• Experience with developing, maintaining, and managing tableau reports and dashboards.
• 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 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 with developing, maintaining, and managing Tableau Report/Dashboard using Tableau Desktop Required 3 Years Experience establishing Connections with different Data Sources Required 3 Years Bachelor's degree in computer science or related field, or equivalent experience. Required 5 Years Tableau Report/Dashboard Data Preparation using Tableau Prep Builder Desired 2 Years Tableau Platform (Tableau Desktop, 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