data analyst in securities-based lending

Darum lohnt es sich

Описание 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