Position: Sr. Full-Stack Data Engineer
Category: Data Engineer
English level: fluent
Years of experience: 11

Data pipelines using Python & databricks: 
- Snowflake -> csv -> Google Cloud
- Postgresql -> csv -> AWS S3 bucket -> creating pre-signed url -> shortening url using bit.ly -> sending via AWS SES
- Hubspot CRM API -> Snowflake
- Snowflake -> Hubspot CRM API

- discovered json parsing related bug in Snowflake that was confirmed by their support;
- created custom ETL process based on Python for handling key-based replication deleted records and for cross-instance data quality checks (Postgres vs Redshift and Postgres vs Snowflake);
- created custom process based on panda | Python for various data quality checks;
- created data pipeline alert process based on Python for notifying users about various events in database, integrated with mailjet (email service) and Slack; 
- created basic frontend subsystem based on Python & Flask for notifications management;
- created databricks to hubspot API integration using Python
- created basic web api based on Flask and Google Cloud; also created wrapper for calling api from google spreadsheets based on Google Apps Script
Full-Stack: Python / Flask / bash back-end development, JS / Jinja2 / CSS / AJAX / jquery / html front-end development;
creating RESTful APIs based on Flask/Python/AWS|GCP and integrating with other APIs and services;
10+ years of experience as DB Developer;
understanding of relational database concepts;
estimation, implementation planning; development, integration and deployment;
Good knowledge of SQL, PL/SQL and Transact-SQL, Cloud Computing, BigQuery;
 + sql statements performance tuning; 
 + reverse engineering of undocumented sql and pl/sql code; 
Experience with Oracle, MS SQL Server, mysql, Postgres, Snowflake and other db, DWH;
Experience with Oracle BI (repository, analysis, dashboard, agent development), SAP Business Objects (universe and report development), Power BI;
Experience with data quality & validation;
Experience with VBA, unix shell scripting;
SVN & Git;
Experience with support of front-end system (printing forms, table settings);
Experience with support of Basel II and ARZ reporting systems;
Linux enthusiast;
can do basic frontend stuff from scratch using Flask & Python;
can do panda | Python coding for various data quality checks;
ML data ingestion, ML model allocation;
English: C1 Advanced level; 
Polish: almost fluent speaking and very good writing level; 
Freelance experience with Oracle, MS SQL Server, Postgres and MySQL
Remote part-time (25 hours/week). No russians/belorussians on the team, no russians/belorussians among company founders, no company's branches in russia/belorussia, no contragents in russia/belorussia, no russian clouds/products usage on a project