- Company Name
- NLB Services
- Job Title
- Data Analyst / Developer – Banking / Lending Platforms
- Job Description
-
**Job title**
Data Analyst / Developer – Banking / Lending Platforms
**Role Summary**
Develop, maintain, and optimize data extraction, transformation, and loading (ETL) pipelines and high‑volume database solutions for corporate and commercial lending systems. Collaborate with business, QA, and development stakeholders to deliver accurate, compliant data assets and analytical insights.
**Expactations**
- 7–10 years of hands‑on data analysis and development experience in banking or financial services.
- Deep expertise in SQL and MS SQL Server, including stored procedures, utilities (BCP, SQL Server Integration Services), and performance tuning.
- Proficient in Linux shell scripting for automating workflows.
- Strong background with IBM Datastage or equivalent ETL platforms.
- Experience with Agile/Scrum project management and tools such as ServiceNow, Jira, Confluence, and GitHub.
- Excellent communication and problem‑solving skills; ability to translate business requirements into technical deliverables.
- Preferred knowledge of ACBS, AFS, LoanIQ, or similar corporate lending platforms; cloud (AWS, Azure) integration; and data profiling.
**Key Responsibilities**
- Design, develop, and maintain IBM Datastage ETL jobs for loan data integration.
- Write and optimize complex SQL queries, stored procedures, and file utilities for high‑volume processing.
- Build and maintain Linux shell scripts to orchestrate data workflows and automate repetitive tasks.
- Engage with business analysts, QA, and developers to validate data accuracy, integrity, and completeness.
- Participate in data modeling, database design, and data profiling for loan platforms.
- Use GitHub for version control, code collaboration, and deployment pipelines.
- Manage tasks and documentation in ServiceNow, Jira, and Confluence.
- Leverage lending platform knowledge to support loan reporting, analytics, and regulatory compliance.
**Required Skills**
- SQL & MS SQL Server (advanced query writing, stored procedures, BCP, performance tuning).
- Linux shell scripting (Bash, scheduling, automation).
- IBM Datastage ETL development (JCL, job design, debugging).
- Agile/Scrum practices and tools (Jira, Confluence, ServiceNow, GitHub).
- Strong analytical, communication, and problem‑solving abilities.
- Familiarity with loan management systems (ACBS, AFS, LoanIQ) and cloud platforms (AWS, Azure) is a plus.
**Required Education & Certifications**
- Bachelor’s degree in Computer Science, Information Technology, Finance, or related field.
- Certifications: Microsoft Certified: Azure Data Engineer Associate or AWS Certified Data Analytics – Specialty; or equivalent SQL Server/ETL credentials are desirable.