BI Analyst
Indianapolis, IN, US, 46204
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 Workforce Development (DWD):
Our mission is to develop a premier workforce that will allow Indiana employers to flourish and entice businesses from outside our state to relocate to Indiana. Everyone at DWD will be required to think outside-the-box; to determine metrics that will allow for measurement and improvement and efficiencies to be made along the way. Cutting edge technologies will be utilized to help assess Indiana’s employment future. If managed properly, Indiana’s workforce will be second to none and completely prepared for the next phase of the state and country’s economic growth.
Role Overview:
The incumbent works within the Performance Reporting and Data Integrity team as an analyst using tools to analyze and identify key trends in program performance, which lead to proactive solutions. Specifically, the incumbent will function as a federal reporting and data validation specialist, This requires detailed knowledge of Indiana's case management and labor exchange system and workforce programs. The incumbent responds individually or as part of a team to fulfil ad hoc data requests from customers inside and outside of the agency, organizing these tasks based on priority and urgency. Work involves coordinating and leveraging resources from other teams and departments of DWD, as well as outside partners, and providing database and programming support as necessary to other teams when requested. The incumbent works with executive and program-level staff, providing data structuring, strategic research, and data analysis that can drive policy and decision-making. The incumbent must be familiar with the data sets collected in DWD application systems and understand all business rules and caveats. Responsibilities include: writing SQL to extract data from DWD application systems, creating ad-hoc reports utilizing the extracted data to fulfill performance requests for both internal and external customers, assisting with the maintenance of large and complex data sets, and customizing reports for repeated requests from data users. As a member of the performance team, the incumbent will assist with capacity planning, data element integration, data analysis, documentation, and issues as they arise. The incumbent will work with performance team members to assist database architects from various systems, applications, as well as in the development of any visualizations to be placed on our performance website. The incumbent will be responsible for keeping up with the guidance from DOL that governs our federal performance reporting and data validation responsibilities, which includes ensuring our case management system is in alignment with such guidance.
Salary Statement:
The salary for this position traditionally starts at $61,022.00 but may be commensurate with education or work experience.
A Day in the Life:
The essential functions of this role are as follows:
- Works closely with end users to gather requirements and translate them into effective/meaningful visual reporting tools.
- Presents data in a fashion that is easy to understand with proper documentation and user testing for successful adoption.
- Publishes workbooks to appropriate QA, production, and public servers.
- Provides maintenance and support for production products.
- Collaborates with other BI professionals and data engineers around data/table structures to optimize dashboards and other self-service needs.
- Maintains a high degree of customer satisfaction through the implementation, investigation, analysis, training, and relationship building efforts.
- Some essential functions of this position may be performed onsite at the agency’s worksite or other assigned worksites while some essential functions of this position may be eligible for work from home authorization in accordance with policy. Remote work authorization is not automatic and is dependent upon operational needs and agency approval.
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.
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:
The ideal candidate in this role should minimally have either
- a Bachelor’s Degree, or
- at least 3+ years of experience applying the below, outlined knowledge, skills, and abilities in a similar role.
- Tableau certification is a plus
Related certifications and coursework may be considered for education or experience.
- Visual and artistic creative skills.
- Experience manipulating large datasets.
- Experience in working with one or more BI platforms (ex: Tableau, Power BI).
- Strong understanding of relational and dimensional databases and data warehousing structures, theories, principles, and practices.
- Experience with geocoding and map visualizations.
- Experience generating public-facing visualizations.
- Experience in optimizing visualizations for web and mobile device platforms.
- Effective communicator and problem solver.
- Exceptional analytical, conceptual, and problem-solving abilities.
- Strong written/oral communication and presentation/interpersonal skills.
- Resourceful self-starter and highly motivated team player.
- Able to perform essential functions with or without reasonable accommodation.
Supervisory Responsibilities/Direct Reports:
Benefits of Employment with the State of Indiana:
The State of Indiana offers a comprehensive benefit package for full-time employees which includes:
- 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
- Flexible work scheduling options, including the potential for hybrid remote work for employees whose work may be performed outside state facilities
- Deferred compensation 457B account (similar to 401k 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 jobs@spd.IN.gov.
Nearest Major Market: Indianapolis
