Job details
Job type full-time
Full job description
We invite you to explore a future with us at pra group, a diverse and growing company that has a tangible impact on the global economy.
Position summary:
Key responsibilities (other duties may be assigned):
Data analysis & reporting using oracle sql, ms sql, and other statistical tools
Oversight of complex sql stored procedure processes
Use data to develop and optimize strategies and processes, increase profits, efficiency, quality, or security, and reduce costs.
Enhance the monitoring and control mechanisms to strategy owned processes to ensure we maintain compliance with policies and procedures.
Maintain policy and procedure documentation along with change management and testing documentation as required.
Present analytical study/research findings to other stakeholders within the d&a department when required.
Dig into data and raw information through statistical analysis to discover trends and patterns that can be used to extract valuable business insights
Manage multiple projects in addition to day to day process tasks management on larger value items.
Reviewing and improving analytics processes, methods, and tools to increase efficiency, accuracy, and security
Maintain and oversee the performance of champion / challenger testing processes as it relates to existing activities or other alternative strategies being developed.
Build and maintain power bi dashboards for showing activity performance as it relates to strategy processes being maintained by the department.
Identify issues and process improvement opportunities and work with other areas of the business to analysis, report and resolve discrepancies (including taking ownership of actions/projects where appropriate)
Partner with compliance to ensure processes are aligned with regulatory and risk mitigation criteria.
Investigate inventory gaps and areas for better optimization to inform operations, fulfillment, or model/segmentation.
Act as the subject matter expert for one area of strategy
Professional experience/qualifications:
Bachelor’s degree required, and a minimum of 4-6 years related experience and/or training; or equivalent combination of education and experience required.
Experience in npl markets or comparable work experience preferred
Sql experience.
High level analytical problem-solving skills
High level of analytics autonomy
Strong conceptual thinking and problem-solving skills using data analysis and utilizing excel or other statistical packages
Ability to write complex join, union, pivot, common table expression query statements for complex data calculations using time window functions in sql.
Ability to write and troubleshoot stored procedures in ms sql server (tsql and or plsql experience preferred).
Able to create, modify, and execute sql server scheduled jobs & sql server stored procedures
Ability to create, develop and modify reports based upon operational requirements
Proficient at developing and maintaining reporting packages through visualization tools (power bi preferred).
Must have effective organizational, time-management and high attention to detail.
Must have effective communication and interpersonal skills.
Strong excel skills (charts/graphs/formulas/macros)
Basic version control knowledge(github)
All qualified applicants will receive consideration for employment regardless of age, race, color, sex, gender, religion, national origin, physical or mental disability, citizenship, or any other classes recognized by state or local law or any other characteristic protected under applicable federal, state or local lawWe are a drug free workplace.
