Data Engineer (blockchain)

LATOKEN is the supermarket of assets where it is easy to discover, exchange, earn and spend crypto.

Mission: Well-structured and secure data and monitoring.

Story: Product, Finance, OKRs, and Dash Teams need well-structured and secure data and monitoring to analyze and track the improvement of the services and product performance.

Key PROBLEM's:

• The monitoring system alerts for any downtime, latency, or success rate issues of the services.
• All company data and events are merged and consolidated into the Data Base (DWH, PostgreSQL, Segment, Indicative, Google Analytics) to support the Monitoring system, Token Discovery, OKRs and Analytical Dashes.
• Acquisition channels, conversions, and users are correctly mapped and easy to access.
• Token DB is representative of the market and token data is correct and complete with on-chain and smm data. (30k tokens by end of April)

How:

• Create new data pipelines for business need.
• Maintain scripts and pipelines in case of problems or new requirements.
• Define necessary events, set up recording and make available for reports and dashboards.
• Maintain and update token DB.

Constraints:

• All OKRs of the company are consolidated into Platform Ops.
• All scripts are consolidated into Gitlab.

Main performance number: Ops OKR Health
Second performance number: Free Space DWH
Third performance number: Query response time, sec avg

Functions:
• OKRs Health : Calculate OKRs correctly, daily and in time
• DWH objects audit
• Queries : Advice on optimization and writing queries to databases.
• Data quality : Keep data in order and provide reliable reporting
• Automation : Automation of OKRs and slack bots for automated ops processes
• Audit : Audit of DWH state and automated scripts

Requirement skills and experience:

2+ years of PostgresSQL DB administration experience;

2+ years of experience writing Python scripts and applications for loading data;

Experience in configuring a database in a high-availability architecture;

Experience in database optimization for different load profiles;

Experience in automating data loading from different sources (CRM, ERP, Web resorses)

Eager to work with people with high-performance standards

Will be a plus:

Experience with financial data

Experience as a data/product analyst