SQL skills needed for Credit & Collections (Senior)Analyst
NICE Global (2)
- Hanover / St. James / Trelawny
- Not disclosed
- Permanent full-time
- Updated 27/08/2020
- HR Manager
Description
The Credit & Collection Analyst Lead is a highly visible role that provides business analytics, data modeling, and technical dashboard and report to achieve Operational Objectives.
Job Title: Credit & Collections (Senior)Analyst
The Credit & Collection Analyst Lead is a highly visible role that provides business analytics, data modeling, and technical dashboard and report to achieve Operational Objectives. S(he) will collaborate closely with Credit & Collections Managers and other Finance Teams to gather requirements that translate into Reporting and Analytical Deliverables and enable data-driven insights and decisions. The position will report to the Director, Global Process Owner (GPO) for Credit & Collections.
Essential Functions (Responsibilities):
• Responsible for accumulating, analyzing, interpreting and reporting Credit and Collections Operational Performance data for Credit & Collections Teams and Senior Management )
• Develop and Implement Key Performance Indicators (KPIs), Operational Plans and Forecasts, Dashboards and Reporting aligned with established KPIs / Objectives
• Develop mini tools/applications that automate manual reporting and reconciliation processes
• Quickly gather data from multiple systems and provide analysis of that data along with recommendations and actions. Explain reasons for trend increase and decreases.
• Maintain the integrity of Credit & Collections Master Data
• Maintain and manage KPIs for shared services and global outsourcing credit depts.
• Develop and implement cash and credit card application solution improvements.
Qualifications/Requirements:
• Undergraduate Degree in Finance, Accounting, Business Systems, Statistics or similar quantitative discipline
• At least 5-7 years of hands-on experience in a Business Intelligence / Data Analyst role
• Experience with Accounts Receivable metrics and data
• Experience with shared service departments and global outsource collection depts.
• Strong knowledge of automated cash application, credit card processing.
• Strong knowledge SAP (Finance and Sales/Distribution models)
• Advanced MS Excel and / or MS Access skills required
• Visual Basic for Applications (VBA), SQL / Database experience a plus
• Six Sigma / Process Improvement experience a plus
• Experience with QlikView, SAP Business Objects Business Intelligence Suite, and / or Minitab Statistical Software a plus
• Strong communication (verbal / written) skills at all levels of the organization, ability to summarize complex information into executive summaries for decision makers.
- Strong project management and cross-function collaboration skills.
• Ability to work independently with little supervision
• Some travel required (approximately 5 percent)
Ideal Candidate
- Strong analytical skills
- Strong communication and presentation skills
- Collaborative and can easily adapt to changing requirements
- Strong technical background with experience in database languages like SQL and other query languages.
- Basic knowledge of credit and collections
Comments
Post a Comment