Clinical data analyst h1.location_city

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 Education (DOE):

The Indiana Department of Education provides innovative support to Indiana schools, teachers, students, and parents. We proactively work with educators, policymakers, business leaders, and community-based organizations to build student success. Our strategic priorities include:

• Delivering quality, purposeful educational opportunities for each student
• Elevating and supporting Indiana’s educators
• Increasing partnerships and delivering aligned, effective, and efficient support
  

Role Overview:

This role utilizes Microsoft Power BI to create data visualization reports to provide self service dashboards to end users.
Experience with Azure Synapse and Microsoft Fabric is a plus.

Salary Statement:

The salary for this position traditionally starts at $70,;but may be commensurate with education or work experience.

A Day in the Life:

The essential functions of this role are as follows:

• Coordinates with key business stakeholders to understand their analytical and operational challenges.
• Designs, develops, and formats polished data visualizations (reports and dashboards) to support generated user stories from stakeholders.
• Prioritizes requirements and create prototypes for end users.
• Works closely with end users to gather requirements and translate them into effective/meaningful visual reporting tools.
• Determines the structure, content, and quality of the data through examination of source systems and data samples.
• Conducts data quality checks, as needed, to ensure the validity and cleanliness of agency datasets prior to their use in analysis and reporting.
• Publishes workbooks to appropriate QA, production, and public servers.
• Provides maintenance and support for production products.
• Documents and communicates technical specifications to ensure that proper and optimized techniques, queries, and final deliverables are understood and incorporated into data and analytics processes.
• Supports a portfolio of data domains to identify and implement continuous ideas for visualizing data for self-service analytics.
• Uses source code repositories for source code version control.
• Presents data in a fashion that is easy to understand with proper documentation and user testing for successful adoption.
• Provides end user education for interpretation of business data.
• Tests and evaluates upgrades to existing software.
• Collaborates with other BI professionals and data engineers around data/table structures to optimize dashboards and other self-service needs.
• Looks for opportunities to improve current processes or find efficiencies by applying industry best practices.
• Maintains a high degree of customer satisfaction through the implementation, investigation, analysis, training, and relationship building efforts.

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.

What You'll Need for Success:

Individuals in this role should minimally be able to articulate or demonstrate the following:

• Experience manipulating very 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.
• Visual and artistic creative skills.
• Strong written/oral communication and presentation/interpersonal skills.
• Advanced SQL coding and troubleshooting skills.
• Experience with data modeling, database design, and query performance tuning and optimization.
• Experience with database development and data manipulation using PL/SQL and T-SQL.
• Strong understanding of relational and dimensional databases.

A degree is not required. However, at least 5+ 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.

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
• Deferred compensation 457(b) account (similar to 401(k) 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 mothersUp 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