> DOU
senior
Quantango Technologies LTDData Analyst
format:Remotetype:Full-time
sqlbigquerymetabasetableaudbtdagster
pythonairflowprefectdockerci/cd
> full description
We are looking for a skilled Data Analyst to join our team and help us build a world-class data foundation. You will sit at the intersection of data engineering and business analysis, transforming raw data into high-quality, actionable datasets within our warehouse. Your goal is to establish a gold standard for our data assets, ensuring they are reliable, well-documented, and ready for strategic decision-making by Departments and Senior Management.
Requirements
- Expert SQL: Advanced proficiency in SQL (window functions, complex joins, indexing) and OLAP query optimization — 4+ years.
- Data Warehousing: Solid understanding of OLTP vs. OLAP and data modeling techniques.
- BI Development: Experience designing data sources and interactive dashboards in Metabase, Tableau, or similar tools.
- Systematic Thinking: Strong attention to detail and the ability to build scalable, logical systems.
- Requirement Formalization: Ability to gather and formalize requirements from stakeholders, even when they are not yet fully defined.
- Business Acumen: Focus on identifying business growth or risk drivers and preparing reports for senior management.
- Fluent Ukrainian, fluent Russian, English — upper intermediate or higher.
Responsibilities
- Design and implement analytics-ready data models using Fact/Dimension tables and semantic layers.
- Transform raw datasets into clean, structured Marts using dbt as the primary transformation tool.
- Ensure absolute consistency and logic alignment between the Data Warehouse (BigQuery) and the BI layer (Metabase).
- Write, test, and optimize complex SQL queries for advanced analytical use cases and reporting.
- Leverage Views and Materialized Views to improve performance and optimize BigQuery resource consumption.
- Partner with stakeholders (especially the Risk Dept) to translate business requirements into robust technical data models.
- Support and extend automated data ingestion flows from various sources using dlt.
- Manage and monitor the lifecycle of data assets and pipeline dependencies within Dagster.
- Define and standardize core business metrics and KPIs at the code level to ensure a “Single Source of Truth”.
- Implement automated data quality checks, validation rules, and proactive monitoring at the analytics layer.
- Document business logic, data definitions, and KPI catalogs for company-wide data discovery.
Nice to have
- Data Stack: Mandatory hands-on experience with dbt (models, tests, macros).
- Data Ingestion & Extraction: Practical experience with the dlt (data load tool) library or similar Python-based ingestion frameworks.
- Orchestration: Experience managing data workflows with Dagster (preferred) or similar orchestrators like Airflow/Prefect.
- Python: Proficiency in writing clean Python code for data manipulation and pipeline automation.
- Engineering Best Practices: Proficiency with Git (Pull Requests, Code Review), CI/CD, and Docker.
- FinTech Domain Experience: Previous experience working with financial transactions, digital wallets, or fraud detection systems.
Benefits
- Competitive and attractive compensation
- Remote work schedule
- Proper rest time of 24 annual leave days
- Challenging and unique tasks in the FinTech field
- Funding for gym memberships, fostering a healthy work-life balance
Interview Stages
- Interview with a Recruiter (1 hour)
- Interview with a Hiring Manager (1.5 hours)