Middle Data Analyst

Що робити

Analyze transaction volumes and values, payment statuses, authorization success rates, payment conversion, declines, refunds, and disputed transactions by merchant, provider, payment method, country, and currency.
Investigate the payment funnel, distinguish business declines from technical errors, and analyze retries, routing, and the impact of integration changes on payment outcomes.
Build and maintain dashboards in Apache Superset or similar BI tools to monitor payment metrics; produce regular management and operational reports.
Write SQL queries in Amazon Athena and PostgreSQL, process data using Python, and develop analytical datasets and data marts.
Develop and maintain analytical ETL transformations in AWS Glue and data workflows in Amazon S3; coordinate changes with the responsible engineers.

Practical experience in data analytics: independently handling business requests, preparing data, validating results, and drawing conclusions.
Strong SQL skills: complex JOINs, CTEs, window functions, aggregations, date handling, and query optimization in PostgreSQL and Amazon Athena.
Python for analytics and automation: pandas, data cleansing and validation, reproducible calculations, error handling, and working with large datasets.
Hands-on skills with Amazon S3 and AWS Glue: storage formats, partitioning, data cataloging, ETL transformations, and validation of data loads.
Experience building BI dashboards in Apache Superset or similar BI tools, such as Power BI, Tableau, or Metabase: datasets, metrics, filters, visualizations, and clear presentation of metrics for different users.

Experience in fintech, payment service providers, acquiring, or payment processing; analysis of merchant and payment provider data.
Understanding of 3-D Secure, settlement, chargebacks, and reconciliation; experience reconciling transaction and financial data.
Experience analyzing payment routing, A/B