Operations Analyst 2

$52,800 - $85,200/Yr

Public Consulting Group - Hartford, CT

Full-time - Mid Level

Remote - Hartford, CT

1,001-5,000 employees

Professional, Scientific, and Technical Services

About the position

Public Consulting Group LLC (PCG) is seeking a dedicated professional to join our Quality Assurance team. This position plays a crucial role in ensuring the integrity and quality of data management processes within our organization. The successful candidate will assist in the management and distribution of tasks within the Quality Assurance team, providing supervision and support to junior staff members working on various product lines and projects. This role requires active participation in the decision-making process and goal-setting for the overall team, fostering a collaborative environment that promotes excellence in service delivery. In the realm of data management, the candidate will lead, assess, and transform Excel data to ensure compatibility with pre-defined templates. This includes loading data into these templates, confirming correct entry, and identifying any data quality issues that may arise. The role also involves validating data management tasks performed by other team members and managing a queue of data management tasks with prompt delivery and clear communication. The candidate will summarize results of ETL data activities and report findings to the team lead, producing timely reports on collected data and conducting financial analyses of cost reports, including trend and variance analyses. Quality assurance and control are paramount in this position. The candidate will perform multiple levels of quality control on various data sources, working collaboratively with colleagues to complete necessary desk and compliance reviews. Monitoring and tracking data received for projects, as well as completing quality assurance checks for assigned projects, are essential responsibilities. Client service is another critical aspect of this role. The candidate will communicate with internal clients regarding data discrepancies, missing information, and upcoming deadlines, ensuring that all issues are escalated appropriately. The role may also involve special projects as assigned, requiring flexibility and adaptability to meet the needs of the organization.

Responsibilities

• Assist in the management and distribution of tasks within the Quality Assurance team.
• Provide supervision and support to junior staff members of the Quality Assurance team working on various product lines and projects.
• Participate in the decision-making process and in goal-setting for the overall team.
• Lead, assess, and transform Excel data to be compatible with pre-defined templates.
• Load data into pre-defined templates and confirm correct entry and interaction with automated functions.
• Identify and communicate data quality issues and summarize requirements for follow-up.
• Validate data management tasks performed by other team members.
• Manage a queue of data management tasks with prompt delivery and clear communication.
• Summarize results of ETL data activities and report to team lead regarding results.
• Produce reports on collected data within mandated time frames.
• Conduct financial analysis of cost reports including trend analysis, variance analysis, and root cause data investigations.
• Gather and interpret cost and/or ratio data to identify variances and trends, create reports, and perform advanced analysis when necessary.
• Perform 'desk audits' of cost reports, validating data submitted against supporting documentation.
• Create visualizations, and ad hoc analytics and reports as necessary.
• Perform multiple levels of quality control on various data sources.
• Work collaboratively with colleagues to complete necessary desk and compliance reviews.
• Monitor and track data received for projects.
• Complete quality assurance checks for assigned projects.
• Communicate with internal clients about data discrepancies, missing information, needed documents, upcoming deadlines, and status.
• Appropriately communicate with the internal team clients and escalate issues as necessary.
• Work within a team to accomplish other duties on the project to meet necessary deadlines.
• Complete special projects as assigned.

Requirements

• Strong interpersonal, organizational, time management, and written communication skills.
• Demonstrate a detailed and process-oriented approach to problem-solving.
• Demonstrate sound judgment in completing tasks and in seeking guidance when needed.
• Demonstrate a positive attitude and demeanor; showing initiative, enthusiasm, and strong willingness to learn.
• Demonstrate a commitment to deliver exceptional client service for internal and external clients.
• Ability to report and track findings, review documentation, and notify management of key issues.
• Ability to embrace change and flexibility.
• Ability to juggle multiple assignments at once, prioritizing when necessary.
• Attention to detail.
• Ability to work independently and with a team in a remote environment.
• Proficiency with Microsoft Office applications, specifically Excel, Access, and Word.
• Experience with database software or visualization tools is also a plus.

Nice-to-haves

• Experience with or knowledge of Medicaid, Healthcare, Education, and/or customer support is beneficial.

Benefits

• Medical and dental care benefits
• 401k
• PTO
• Parental leave
• Bereavement leave