Software Engineer SQL

We are looking for a Software Engineer SQL who'll join our Origination Scoring team!

Origination Scoring team:
The team is responsible for for Credit & POS integration with external services (suppliers), integration with internal services coverage of the system with metrics and alerts to monitor compliance with SLA and implementation of tools for automated integration testing

Challenges that await you:

• Build DWH for risk management purposes
• Develop data marts
• Build BI/reporting from scratch
• Creation and development of data and quality management processes
• Benchmark and forecast the current portfolio behavior based on internal and external data
• Build a framework for an integrated risk monitoring and reporting system
   

What makes you a great fit:

• Experience with databases, strong knowledge of SQL
• DWH development experience, Development of stored procedures, functions
• Knowledge of the basics and theory of building data warehouses (you can explain the difference between Kimball / Inmon / Data Vault, talk about the degrees of normalization
• Knowledge of the data versioning (SCD)
• BI/reporting experience
• Experience in risk analysis, understanding of base risk metrics - vintage analysis, roll rates, portfolio risk metrics
• Strong knowledge of mathematical statistics and understanding of probabilities
• Spoken English
  
  Your bonus skills:
• Bank/fintech risk management experience
• Experience with one of the analytical scripting languages (Python / R)
• Data Science experience (data preparation, predictive modeling)
• Build DWH for risk management purposes
• Develop data marts
• Build BI/reporting from scratch
• Creation and development of data and quality management processes
• Benchmark and forecast the current portfolio behavior based on internal and external data
• Build a framework for an integrated risk monitoring and reporting system

Our technology stack:

Amazon Cloud, Java (KafkaStreams), SnowFlake SQL Database, Amazon S3 (DataLake), Airflow for Scheduling

Our benefits:

• Relocation support with full visa & permit support to the employee and family (Cyprus, Kazakhstan, Mexico)
• Flexible work from one of our offices or remote
• Healthcare Coverage
• Education Budget: Language lessons, professional training and certifications
• Wellness Budget: Mental health and fitness activity reimbursements
• Vacation policy: 20 days of annual leave and paid sick leave