data analyst in securities-based lending

Описание

Supernova Technology provides a cloud-based, customizable, end-to-end software solution that automates securities-based lending from origination through the life of the loan. Its platform combines suitability and risk management, education, and technology to help advisors deliver goals-based advice and improve clients' financial wellness.

Задачи

• Collect, clean, transform, and validate data from multiple sources
• Write and optimize SQL to investigate issues, reconcile records, and answer business and client questions
• Build, maintain, and enhance dashboards, scheduled reports, and KPIs for internal stakeholders and clients
• Analyze trends and perform root-cause analysis on data discrepancies and integration or processing failures
• Deliver clear ad hoc analysis to support decision-making
• Support database maintenance, including integrity checks, performance tuning, backups, and access administration, in coordination with engineering
• Support data migrations and integrations by validating mappings, conversions, and file processing
• Document issues arising during migrations and integrations
• Serve as the point of contact for UK/Europe clients on data, reporting, and operational queries
• Triage and resolve tickets within SLA and escalates when needed
• Investigate client-reported data discrepancies across systems
• Translate findings into clear, non-technical explanations for clients
• Monitor data jobs, file processing, and reporting pipelines to proactively identify issues
• Maintain incident documentation, knowledge-base articles, and reporting definitions
• Represent the customer voice to Product, Engineering, and Program Management
• Surface recurring issues that may indicate product or process changes
• Build platform and domain expertise toward becoming a regional subject-matter expert for data and reporting

Требования

• Bachelor's degree in Data Analytics, Statistics, Computer Science, Information Systems, or a related field, or equivalent practical experience
• 2+ Years of experience in a data analyst, business intelligence, or analytical role
• Strong SQL skills across relational databases
• Working knowledge of database maintenance concepts, including data integrity, performance, and access controls
• Proficiency with Power BI, Tableau, or Looker
• Advanced Excel or Google Sheets skills
• Solid understanding of data quality, validation, and reconciliation practices
• Excellent written and verbal communication skills
• Ability to explain technical issues to non-technical stakeholders
• Strong ownership and ability to work independently
• Based in the UK and able to work across UK/European and US time zones, including occasional off-hours coverage
• Nice to have: Python or R for data analysis, familiarity with APIs, SFTP/file-based transfers and message queues, exposure to AWS or Azure data or logging/monitoring tools, financial services, banking, or securities-based lending experience

Условия

No conditions specified