Position: Sr. Data Engineer / DBA (remote only)
Category: Data Science
English level: fluent
Years of experience: 10

- 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
Last project description: 

Fintech company providing innovative insurance products and financial solutions for residential and commercial real estate professionals as well as their residents and tenants.
Data Science team.
Consolidating data from microservices into dwh; creating bi dashboards; tuning objects in dwh in order to make them cached;
dba stuff like creating users, setting access rights on different environments, aws rds db replication;
looking for missing indexes etc in order to optimize sql queries;
checking data quality and integrity, creating various concepts for future usage;
creating star-type dwh;
creating db functions for financial forecasting;
migration from Redshift/Periscope into Snowflake/PowerBI.
Postgres, Power BI, Stitch (etl tool), dwh, Python + sql coding, GNU/Linux, unix shell scripting;
Anaconda, Jupyter Notebook, databricks / PySpark basic usage;
various performance testing under high load;
parsing and joining complex json values in Postgres and Snowflake;
preparing documentation, presentations for business users, new team members onboarding (basic).
Additionally: I'm owl type of person and can work according to US (EST) timezone.
Desired technologies on project: Rest API integrations based on Flask/Python/AWS + Snowflake/Postgres. Casually considering openings, but not available until the end of May 2021. I would consider job descriptions written solely in English with "100% remote" mention; w/o any exUSSR management; US (EST) shift.