Junior Analyst - Business Process

Job Description

Role Overview: This role requires strong knowledge in SQL, Python, and strong logical, analytical, and problemsolving skills. The candidate will support automated and semi-automated monitoring processes and collaborate with cross-functional teams to develop new monitoring frameworks, automate activities, and create alert systems throughout the loan lifecycle. The ideal candidate will demonstrate technical acumen, effective communication skills, and a proactive approach to quality assurance and continuous improvement. Experience: 0 - 2 years (Hands-on experience in writing SQL queries and scripts in Python would bean added advantage) Core Technical Skills: - Strong ability to create and optimize complex queries for analysis using Amazon Redshift or similar database services. - Skilled in Python scripting to develop and maintain automation scripts, monitoring tools, and alerts. - Ability to translate business needs to technical specifications, understand the requirements thoroughly and work closely with internal stakeholders to ensure the deliverability on time with great quality. - Ability to create and manage database tables, maintain data integrity, and generate reports for ongoing monitoring and analysis. - Ability to analyse and monitor the automated reports and be proactive in capturing any issues. - Ability to interpret data and turn it into analytical reports which can offer ways to improve a business, thus affecting business decisions. Roles and Responsibilities: - Evaluate, refine, and improve existing monitoring frameworks and processes. - Collaborate with cross-functional teams to integrate systems and develop end-to-end monitoring solutions. - Assist in converting semi-automated processes to fully automated frameworks using SQL, Python, and alerting systems. - Maintain, update, and improve SQL and Python scripts for enhanced efficiency and process reliability. - Develop database queries, conduct data analysis, and create visualizations and reports that support decision-making - Summarizing the monitoring reports to Managers on a daily and monthly basis - Taking part in the daily stand-up and provide updates - Taking part in release demos and product walk-through sessions Soft Skills: - Strong verbal and written communication skills to clearly document processes, communicate issues, and collaborate across teams. - Ability to function as both an individual contributor and a collaborative team member. - Analytical mindset, attention to detail, and self-motivated to learn new skills and tools as required by team needs.