IN - DCS Data Analyst

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 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.
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceBachelor s degree in computer science or related field, or equivalent experience.Required5YearsExperience using Excel Data analysis Functions, scripts, reports, and charts Required5YearsExperience with Data Preparation for Reports and Dashboards Required5YearsBusiness Intelligence experience, Data Warehouse and Reporting Required5YearsSQL and PL/SQL Required5YearsExperience establishing Connections with different Data Sources Required3YearsTableau Platform (Tableau Desktop, Tableau Prep Builder, Tableau Server)Desired0Experience with ETL frameworks and online analytical processing (OLAP)Desired0Python and R LanguagesDesired0Experience with Mainframe and DB2 Z/OSDesired0Experience with SalesforceDesired0Experience with MuleSoftDesired0
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2Please list candidates email address.Question3Candidate must be paid BETWEEN NA and NA if selected for engagement. The provider markup for this position is 35%. Do you accept this requirement?Question4This position requires a passed fingerprint and back ground check. Do you accept this requirement?Question5There will be additional background checks and security training once hired/on site. Please confirm the resource understands this requirement? Question6Work schedule Monday to Friday 8:00 am to 5:00 pm. Do you accept this requirement?Question7This position is a hybrid work schedule, with at least two days a week on site. Resource will be issued equipment the first day, onsite. Please confirm the resource understands this requirement? Question8This requirement is for 2 positions. Vendors will be able to submit a total of 2 candidates for consideration. Thank you!Question9Resource must currently reside in the state of IN. Please provide the current home address.Question10Client will perform a Teams interview. Resource must have the ability to display themselves on video during the interview.