MFP Data Analyst Associate

Socket.dev; Indianapolis (IN); On-site; USD 50,000 - 61,000; Full time

Benefits offered by this job

Medical plan options

Wellness rewards program

Education Reimbursement

Job summary

The State of Indiana is seeking a Money Follows the Person (MFP) Data Quality Analyst to ensure data integrity and develop quality indicators for Medicaid-related programs. The role liaises between the Bureau of Better Aging, Office of Medicaid Policy and Planning, and Bureau of Disabilities Services to ensure compliance with state, federal, and grant requirements.

You will compile, analyze, and fulfill MFP data reporting needs, assist the MFP Project Director with administrative tasks, and work

Qualifications

• Experience with data manipulation including cleansing, standardizing, and transforming.
• Knowledge of statistical software, open-source programming languages, and database querying or demonstrated ability to learn.
• Experience with SQL, Tableau, R, Python, PowerBI, and/or ArcGIS.
• Strong analytical, conceptual, and problem-solving abilities.
• Strong communication skills, both oral and written.
• Broad knowledge of data analysis, analytics, or statistics or demonstrated ability to learn.

Responsibilities

• Assists with transferring raw data to the appropriate location for use in data analysis projects.
• Wrangles, cleans, and validates agency data sources following guidance from senior staff.
• Contributes to general analysis of agency datasets.
• Conducts data quality checks to ensure validity and cleanliness of datasets before analysis.
• Interprets data from multiple sources to support statistical methodologies.
• Develops data visualizations to communicate findings to target audiences.

Skills

Data manipulation

Statistical software

SQL

Tableau

R

Python

PowerBI

ArcGIS

Analytical thinking

Communication skills

Teamwork

Learning ability

Tools

SQL

Tableau

R

Python

PowerBI

ArcGIS

Job description

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 Family & Social Services Administration (FSSA):

The Division of Disability, Aging and Rehabilitative services works to support older adults and individuals with disabilities, while also connecting them with local community resources that promote independence. Help for every life at every age.

Role Overview:

This role, Money Follows the Person (MFP) Data Quality Analyst, performs a key role in ensuring data integrity and addressing customer issues by performing data quality measurement and metric generation, data aggregation into quality performance indicators, data interpretation, and development of various data reporting structures and formats. This role serves as a liaison between the Bureau of Better Aging, Office of Medicaid Policy and Planning, and Bureau of Disabilities Services and coordinates necessary communications to ensure that all data received meets the programs objectives and ensures state, federal, and grant compliance. Your role is primarily responsible for compiling, analyzing, and fulfilling MFP data reporting requirements with regard to participant information and service budget expenditures along with the development and implementation of quality assurance initiatives, and working alongside the MFP Project Director to assist in administrative tasks related to the daily operations of the MFP program within the State of Indiana. The MFP Data Quality Analyst will report to the MFP Project Director and work closely with the Director of Community-Based Supports.

Salary:

The salary for this position traditionally starts at$55,224.00 but may be commensurate with education and work experience. Use our Compensation Calculator to view the total compensation package.

A Day in the Life:

The essential functions of this role are as follows:

• Assists with transferring raw data to the appropriate location for use in data analysis projects.
• Utilizes existing documentation and guidance from senior staff to wrangle, clean, and validate agency data sources.
• Contributes to general analysis of agency datasets.
• Conducts data quality checks to ensure the validity and cleanliness of agency datasets prior to their use in analysis and reporting.
• Interprets data and from multiple sources using a variety of analytical techniques, ranging from simple data aggregation to data mining, to supporting statistical methodologies.
• Develops compelling data visualizations to communicate findings to target audience(s).
• Adheres to HIPAA, PII, PHI and other state statutes concerned with protecting data confidentiality and individual privacy.

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:

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

• Experience with data manipulation, including cleansing, standardizing, and transforming.
• Knowledge of statistical software, open-source programming languages, and database querying or demonstrated ability to learn.
• Experience with SQL, Tableau, R, Python, PowerBI, and/or ArcGIS.
• Strong analytical, conceptual, and problem-solving abilities.
• Strong communication skills, both oral and written.
• Broad knowledge of data analysis, analytics, or statistics or demonstrated ability to learn.
• Ability to work in a team environment with multiple and fluid demands.
• Ability to maintain effective and professional working relationships with internal and external customers.

A degree is not required. However, at least 2+ 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 to401(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 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 Parkingfor most positions
• Free LinkedIn Learningaccess

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 [e-mail].