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 escalate 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