About the company:
We are creating a unified system for digital marking and traceability of goods in Russia and the EAEU countries. Our system reduces counterfeiting and guarantees the authenticity of goods produced in or imported into the country.
Chestny ZNAK is one of the most high-load platforms, with no analogues:
— microservice architecture on Kubernetes with Istio in our own infrastructure;
— petabytes of live data, with which our services and clients work around the clock via API;
— billions of transactions per day and tens of thousands of requests per second;
— real-time analytics on event streams and large-scale batch analytics at night;
— mobile application with 27+ million installations;
— dozens of production releases every day, feature flags, infrastructure as code.
Under the hood - Kafka, Cassandra, Spark, Airflow, Iceberg, ClickHouse, GitLab CI/CD, Helm, Prometheus, Grafana.
We are not afraid of complex tasks and launch bold engineering ideas into production!
Technology stack:
SQL, Python, Redash, Power BI, Excel, Jira, Confluence, OpenCode.
Your responsibilities:
- Analyzing business processes of traceability and marking of goods.
- Interacting with the client, analyzing, clarifying, and agreeing on requirements.
- Reflecting business processes of marking codes and related entities in the system's database.
- Identifying differences and unifying logic in the developed data structures.
- Developing non-trivial algorithms for anomaly/violation detection based on the received data.
- Preparing tasks for developing aggregates and reference books, testing them, and conducting demos for the client.
- Preparing tasks for monitoring data quality / consistency.
- Developing and implementing automated dashboards for monitoring data quality.
- Developing a methodology for assessing data quality and ensuring its integrity.
What we expect from a successful candidate:
- Confident SQL skills, including: writing complex queries using subqueries and window functions, and query performance optimization skills.
- Experience working with data in common DBMS (Oracle, PostgreSQL, MySQL, MSSQL, ClickHouse, Hive, Teradata, etc.)
- Skills in generating data extracts using detailed data, reference books, and analytical aggregates.
- Validating indicators using indirect estimates when there is no direct alternative for cross-validation.
- Experience in formulating tasks for developing analytical selections and reference books.
- Experience in data visualization and creating informative dashboards.
Why choose us:
Development opportunities
- Participation in meetups and conferences: we share knowledge and learn from others.
- Internal corporate training.
- Buddy support: a guide to the company's corporate life.
We care about our employees
- Health: Voluntary Medical Insurance (including dentistry) after the probation period, compensation for sick leave up to salary (10 working days per year), travel insurance policy, corporate psychologists.
- Financial assistance in difficult life situations.
- Benefits cafeteria: not only for sports and education, but also for IT services, extended VMI for family.
Convenience and comfort
- Employment according to the Labor Code of the Russian Federation in an accredited IT company.
- Work in a hybrid format from an office in the center of St. Petersburg (near the metro station).
- Flexible start of the workday.
- We provide work equipment: laptop, monitor, headset - everything for productive work.
Life at the company
- Open communication culture.
- Sports: football, volleyball, yoga - many options, choose or create your own community!
- Workshops, children's parties, book club - you won't be bored.
- Stylish merchandise you'll want to wear.
- Referral program: bring friends and get bonuses.
If you want to grow professionally, work with great people, and feel cared for - we are waiting for you in our team!