Analytics Engineer
AI Summary
Designs and develops the analytics data layer, building data marts, transformations, and semantic layers to ensure consistent, trustworthy metrics for business teams and AI tools.
About this role
🌍 Do you enjoy modeling data, improving data quality and helping teams make decisions based on numbers they can trust?
As a Analytics Engineer at Ecommpay, you'll be the bridge between raw data and real business insight. You'll make sure that when two teams look at the same metric, they see the same number, and they understand exactly what it means. You'll bring structure, clarity and consistency to the way data is built and used across the company.
This role is also at the heart of how we bring AI into our everyday work. The data foundations you create will help analysts, business teams and AI tools find reliable answers faster. If you enjoy combining strong engineering practices with business understanding, and you're excited about using AI tools in your daily work, this role lets you shape how data is built and used in a fast-growing FinTech.
What you will do:
Design and develop the analytics data layer: model data marts (dimensional modeling, star schema) and define grain and business entities
Build and maintain data transformations in SQL and Python, orchestrated in Airflow
Develop the semantic layer in Looker (LookML) with a single definition for every metric and dimension
Implement data quality checks, including: tests, freshness, completeness monitoring and alerts
Document models, metrics and lineage
Work with business teams, analysts and data engineers to turn requirements into data models with agreed metric definitions
Use AI tools to speed up development, refactoring, testing and documentation
Prepare data and context for internal AI use cases, so LLM agents can work with reliable metrics and tables
What we are looking for:
2 years of hands-on experience in analytics engineering or a similar data role
Strong SQL skills, including CTEs, window functions, query optimization and reading execution plans, ideally with Vertica, MySQL or MSSQL
Experience with analytical data modeling (Kimball, SCD, facts/dimensions)
Solid Python skills and the ability to write clean, maintainable code (modules, configs, reusable functions)
Experience with Airflow or similar tools (Dagster, Prefect, Luigi)
Experience with BI tools and an understanding of how the data model affects dashboards
Git, code review and basic Linux/Bash
Hands-on experience with AI coding assistants (Claude Code, Codex, Copilot, Cursor) and the ability to critically review generated code (logic, joins and grain)
Confidence in working with the business to define exactly what is being measured, and in asking questions when something is unclear
English at B1 level or higher
It would be an advantage if you have experience with:
LookML or other semantic layers (dbt Semantic Layer, Cube)
dbt or similar approaches (modular SQL models, tests, documentation as code)
Data quality and observability tools (Great Expectations, Soda, Elementary)
Setting up AI agents for your workflow, such as repository instructions (CLAUDE.md, AGENTS.md) and MCP connections to the warehouse or BI
Kafka or NoSQL (Elastic)
Reading PHP code to understand source system logic
Why join us:
Shape the future of digital finance
Join a fast-growing global FinTech where your work has real impact. Be part of a 500+ international team, collaborate across four offices, and solve challenges that are transforming the way people and businesses move money
Grow your expertise and expand your impact
Take ownership of your growth with access to our internal Academy, relevant training and courses, and financial support for external learning. Build expertise that matters and create opportunities to take on new challenges as you grow
Work in a way that enables your best performance
Work remotely or in a hybrid setup, depending on your location, with the flexibility and autonomy to find the way of working that brings out your best. We trust our people to take ownership, make decisions, and deliver results
Ready to build a data layer that people and AI can trust? Join Ecommpay as our Analytics Engineer and help define the metrics, models and quality standards behind our business decisions. Our team will get back to you and guide you through the next steps.
Let's grow together!
Should you require any support or require alternative formats of our vacancies below please contact Natalja Krumina at [email protected]
Skills
Explore related jobs
More jobs at Ecommpay
Similar Airflow jobs
Jobs in Riga
- P
Rullofseta iespiedējs / Web Offset Printer – Müller Martini Grapha / Progress / A74Papi Printing Ltd · Riga, Latvia - J
Finnish Customer Service Representative in RigaJob Squad · Riga, Latvia - J
Polish speaking Team Leader - RigaJob Squad · Riga, Latvia - J
Polish speaking Trainer - RigaJob Squad · Riga, Latvia - J
Polish Customer Agent - RigaJob Squad · Riga, Latvia - J
Polish speaking Quality Analyst - RigaJob Squad · Riga, Latvia
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.