OCFS Reporting Analyst

State of Maine•Augusta, ME

2d•$23 - $32•Onsite

About The Position

The OCFS Reporting Analyst works in the Data and Analytics Unit of the Office of Child and Family Services (OCFS), supporting the production, analysis, monitoring, and auditing of child and family services and child protection data. The data supports OCFS, DHHS, other State Departments, the Maine State Legislature, the Federal Government, and other partners. The position runs and distributes routine data reports; logs and tracks incoming data requests; and works with the team to establish priorities, estimated completion dates, and assignment recommendations. The analyst learns to complete requests using appropriate data systems, software, and programming. Data produced or released must be authorized and approved by the designated OCFS or DHHS officials. The analyst assists with producing, reviewing, and auditing required Federal reporting and participates in special projects and new technology and data initiatives as needed. The role calls for strong attention to detail, multitasking, deadline management, proficiency with Microsoft Excel and Access, and experience working with and testing large datasets. Salesforce reporting experience or training is preferred.

Requirements

Six years of education, training, and/or experience analyzing, evaluating, and/or developing improvements to organizational and/or managerial systems, programs, and practices.
Ability to manage multiple tasks and meet deadlines.
Strong Microsoft Excel and Access skills.
Experience working with and testing large datasets.

Nice To Haves

Experience or training using Salesforce reporting software.
Thorough knowledge of and recent experience using information data systems to produce data and reporting.
General knowledge of database fundamentals and understanding of relational database structure.
Advanced Microsoft Excel knowledge and specific experience creating datasets, charts, graphs, and pivot tables.
Exceptional customer service and organizational skills, with the ability to manage deadlines.

Responsibilities

Run and distribute routine data reports.
Log and track incoming data requests, and confer with the team about priorities, estimated completion dates, and assignment recommendations.
Learn to complete data requests using appropriate data systems, software, and programming.
Ensure data produced and released is authorized and approved by the appropriate OCFS or DHHS officials.
Assist with the production, review, and audit of required Federal reporting.
Participate in special projects and new technological and data initiatives as needed.
Support production, analysis, monitoring, and auditing of child and family services and child protection data.

Benefits

13 paid holidays and 3+ weeks of vacation leave annually; vacation accrual increases with years of service.
Personal leave for overtime-exempt employees.
12 days of sick leave per year.
State contribution of 85%–95% of employee-only health insurance premiums, depending on salary; dependent coverage is also described in the posting.
A 5% employee-only health insurance premium credit for qualifying participation.
State-paid employee-only dental insurance premiums.
State contribution equivalent to 14.06% of employee pay toward MainePERS retirement.
Gym membership reimbursement of up to $40 per month.
Health and dependent care flexible spending accounts.
Eligibility for Public Service Student Loan Forgiveness.
Employee assistance program through the Living Resources Program.
Six weeks of fully paid parental leave for employees welcoming a child, including non-birthing and adoptive parents; additional unpaid leave may be available under the FMLA.
Voluntary deferred compensation through a MaineSaves 457(b) account.
Additional wellness benefits.