We are looking for a System Analyst (Data Warehouse) to join the DWH Flowwow team. You will be responsible for the development of the corporate data warehouse, designing data models, creating data marts for business needs, and improving data quality.

Responsibilities

• Analysis of business requirements for data and analytics, formalization of tasks for development teams;
• Research and description of data sources: Yandex.Metrica, GA4, Adjust, Snowplow, backend e-commerce systems;
• Design of DWH data models: a detailed layer based on Data Vault 2.0 and analytical data marts based on Star Schema principles;
• Participation in the development and evolution of DWH using low-code tools;
• Development and support of data quality checks (Data Quality Checks);
• Preparation of technical documentation: technical specifications, functional requirements, descriptions of business logic and data models;
• Conducting functional testing of implemented changes;
• Development and support of a business glossary: description of metrics, entities, and business terms, agreement of definitions with business teams.

Requirements

• At least 2 years of experience as a DWH system analyst;
• Experience in designing DWH models and understanding the Data Vault 2.0 approach;
• Proficient in SQL: complex JOINs, window functions, query optimization, execution plan analysis;
• Understanding of DWH architecture: data layers, ETL/ELT processes, incremental loads, history storage, data normalization;
• Experience with data from e-commerce and marketing analytics;
• Skills in preparing technical documentation and interacting with business stakeholders.

Will be an advantage:

• Experience with Git;
• Knowledge of Airflow (DAG monitoring, log analysis);
• Experience with Python;
• Understanding of Lakehouse architecture and experience with Trino;
• Experience with BI tools Tableau and Superset: developing data marts and preparing data for dashboards.

Conditions

• Full-time employment;
• Employment type: employment contract;
• Schedule: 5/2
• Remote work format;
• Income level is discussed during the hiring stages.

What nice things we do for employees

• We offer voluntary medical insurance with dental coverage or reimbursement for medical services, as well as a psychological support service;
• We care about physical health — we reimburse expenses for sports activities or the purchase of sports equipment;
• We reimburse the cost of equipment you purchase for work;
• We create conditions for development: we pay for training, conferences, and meetups necessary for work;
• We provide access to our corporate loyalty program: personal discounts on Flowwow and offers from partners.

Our values

Care and Love Our product is based on the desire of people to please each other and be together. As long as love is alive, Flowwow will have users.

Development and Growth Flowwow is rapidly developing and gladly supports employee initiatives.

Culture of Mutual Assistance We have people involved in the process and who care about what they do.

Openness to Change Everyone can show initiative, suggest ideas, and quickly see their contribution to the overall success.

Charity One of Flowwow's goals is to help people. We are united by social responsibility and a willingness to participate in special charitable events.