Data Engineer (blockchain)
Частный рекрутер Рекрутер Катя ( )
Опыт работы любойот 2 500 до 5 000 $
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