Research Data Analyst

PRA Group (Nasdaq: PRAA); Virginia (MN); On-site; USD 70,000 - 105,000; Full time

Job summary

PRA Group is seeking an IT Product & Process Quality Analyst to support planning and implementing a framework ensuring error-free product delivery. The role focuses on developing new letters, modifying templates, and auditing the letter process, with SQL reporting and data analysis at the core.

The candidate will interact with Compliance and General Counsel on drafts, perform testing, and coordinate with IT and other business units to define requirements.

Qualifications

• 4+ years experience as an Analyst with proficiency in Office and SQL.
• Advanced SQL skills for complex queries used in audits and reports.
• Advanced Excel with V-Lookups and Power BI skills.
• 4+ years of IT Product and Process Quality experience preferred.

Responsibilities

• Create, modify, and run intermediate to advanced SQL queries for audits, daily reports, and ad hoc tasks.
• Manage daily letter file processing and ensure letters are sent per requirements; conduct analyses to prevent audit findings.
• Coordinate with General Counsel and Compliance on letter drafts; liaise with IT and business partners to define requirements.
• Support process documentation updates and collaborate to improve performance, compliance, and efficiency.

Skills

SQL

Microsoft Office

Auditing data analysis

Education

Bachelor's degree in CS/IT/Business or related

Tools

Power BI

Excel

Job description

Role performs IT Product and Process Quality work that focuses on planning and implementing a framework to ensure error-free product to end users. Role provides support to this team primarily by developing new letters and modifying current templates and through monitoring, testing, auditing and reviewing the letter process. Performs functions directly related to compliance and internal audits and may be subject to General Council review. Creates and modifies queries using intermediate to advanced SQL skills. Performs work under minimal supervision and is responsible for multi-tasking, prioritizing work and maintaining an organized work environment.

Professional Experience/Qualifications:

• 4+ years of experience as an Analyst with solid proficiency in Microsoft Office Suite and SQL
• Must have advanced SQL skills in creating SQL queries (complex joins and table creation) used to access data needed for audits, daily reports, and ad hoc tasks.
• Advanced Excel with V-Lookups, as well as intermediate Power BI skills
• 4+ years of related IT Product and Process Quality experience preferred (Intermediate to Advanced Level)
• Able to prioritize job assignments and multi-task various recurring and ad-hoc job requirements under minimal supervision
• Strong written and verbal communication skills. Excellent attention to detail
• Bachelor’s degree in Computer Science, Information Technology, Business/Public Administration or equivalent combination of related education and experience

Key Responsibilities:

SQL Database Reporting

• Creates, modifies, and runs intermediate to advanced SQL queries used to access data needed for audits, daily reports, and ad hoc tasks.

IT Product & Process Quality

• Responsible for processing the daily letter file and ensuring that all letters are sent to customers as required. Ensure that process and procedures are carried out accurately to eliminate any audit findings or potential external complaints by running proactive analyses/reports to ensure process is running efficiently.
• Submits new or existing letter drafts for approval by General Council and Compliance.
• Interacts with business partners at all levels including maintaining all regulatory and compliance standards, conveying requests to IT and Application Development, perform user and acceptance testing, and troubleshoot issues as they occur.
• Partners with other business units to assist in defining business requirements.
• Acts as the Liaison for one or more IT development teams working closely with Product Management.
• Works closely with multiple departments on ad-hoc letter requests.
• Updates all assigned procedure documentation and collaborate within the team and with internal and external partners to improve operational performance, compliance, and efficiency
• May assist with on-the-job training within the department.
• IT Process Quality work is focused on planning and implementing a framework to ensure error-free product.
• Planning and implementing programs to ensure all information systems products and services meet minimum organization standards and end-user requirements/
• Ensuring adequate product testing prior to implementation, devising improvements to current processes and procedures, developing models of possible future configurations
• Administering problem management process, including monitoring and reporting on problem resolution
• Devising improvements to current procedures. Performing work-flow analysis and recommending quality improvements