Senior/Lead Database Engineer

I'm interested

Experience: 5+ years
Remote, full-time

Domain:

Fintech

The project that enables self-billing invoicing between the company and its insurance partner.

The app covers the whole billing process:

Calculates payments that the organization should make to the insurance company, taking into account personnel circumstances and changes in the insurance policy the organization uses;
Issues invoice that can be paid autonomously, without the participation of the insurance company.

By providing seamless self-service billing, the application helps to reduce the interactions between the company and its insurance partner and minimize excessive communication. Moreover, with the app organizations leverage accurate, automated calculations of insurance payments that minds specific organizational factors, affecting the payment amount. That reduce human error and repetitive tasks, and distinguishes the app from the competitors.

The app will be built from scratch. It is tailored for the US users.

Project Specifications:

Airflow, MsSQL, Python, Angular, ASP.NET, Azure Devops, Azure Storage, AzureSQL, Balsamiq, DevTools, EFCore, Fiddler/Charles, Figma, Git, Postman, Swagger.

What we expect:

strong development skills using Python, Airflow, MsSQL;
knowledge of OLAP, OLTP;
design database experience;
strong SQL skills (SQL coding, query optimization, partitioning data);
ETL, ELT knowledge;
English level: B2 (Upper-intermediate).

What you will do:

design, build and maintain ETL process;
working with different data sources (CSV, live traffic);
design databases and storages;
design DWH;
testing, cleaning, transforming, preparing data for analysis;
optimization of existing sql queries and procedures;
provide data analysis support;
building / Monitoring system health checks;
communicate to the Client and team to discuss existing solution, way of improvements, new features requirements.