Data Analyst

The Office for Family Independence (OFI) supports the MaineCare, Food Supplement, TANF and ASPIRE programs. We use an integrated system called ACES to determine the eligibility and benefits for all these programs. You will be querying data directly from the schematic of ACES development and reporting environments, you are expected to act as a subject matter expert and to successfully extract the data from ACES to meet the requirements of the data request. You are expected to help extract the requirements from the requestor by asking clarifying questions and summarizing the results via email for confirmation to build the report from. As part of the Data Team, you will have the expertise and support of the MA-II to assist in this process. We are expecting you to maintain the Kofax Insight Dashboard, it will be your responsibility to extract and aggregate data from the ACES system into the Dashboard. We are looking for someone who has good communication skills, who can meet deadlines and someone who is willing to dig into the problem and help figure it out.

We are seeking an individual with the skill set of a PR5 level or higher. A well qualified candidate would have experience with TOAD or a similar tool in addition to SQL and or PL/SQL development, strong communication skills with the ability to ask pertinent data related questions and correctly interpret data request requirements.

Skill 1: SQL and/or PL/SQL Development

Skill 2: Oracle Database Knowledge

Skill 3: Communication