data analyst in securities-based lending

Stellenbeschreibung:

Описание

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