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