Ecommpay is a fintech payments platform for businesses selling online. It brings global and local acquiring, payment processing and orchestration together through one API, with support for more than 180 payment methods. Merchants can also use open banking, recurring billing and direct debits within the platform. Ecommpay’s focus is on helping businesses manage payments as they grow across markets. The company is regulated by the UK Financial Conduct Authority and is a principal member of Visa and Mastercard.
Junior to Mid-Level Analytics Engineer, Europe (Hybrid)
Build dependable SQL, Python, and Looker data foundations for Ecommpay’s global payments business. Support consistent business metrics and internal AI applications.
Description
- Create and improve the analytics data layer
- Shape data marts with dimensional models and star schemas
- Set data grain and define business entities
- Build and maintain SQL and Python transformations orchestrated with Airflow
- Develop Looker’s semantic layer with LookML
- Create consistent definitions for metrics and dimensions
- Add data quality tests, monitor freshness and completeness, and configure alerts
- Document data models, metrics, and lineage
- Work with business teams, analysts, and data engineers to turn needs into agreed models and metric definitions
- Use AI tools to develop, refactor, test, and document code
- Prepare reliable data and context for internal AI applications and LLM agents
- Help establish the metrics, models, and quality standards that inform decisions at Ecommpay, a global fintech and payments company
Requirements
- At least two years of practical experience in analytics engineering or a related data role
- Strong SQL skills, including CTEs, window functions, query optimization, and reading execution plans; experience with Vertica, MySQL, or MSSQL is preferred
- Experience with analytical data modeling, including Kimball methods, slowly changing dimensions, facts, and dimensions
- Solid Python skills and the ability to write clean, maintainable code with modules, configuration, and reusable functions
- Experience with Airflow or a comparable orchestration tool such as Dagster, Prefect, or Luigi
- Experience with BI tools and an understanding of how data models affect dashboards
- Knowledge of Git, code review, and basic Linux or Bash
- Practical experience with AI coding assistants such as Claude Code, Codex, Copilot, or Cursor
- Ability to critically assess AI-generated code, including its logic, joins, and data grain
- Confidence working with business stakeholders to define measurements and clarify requirements
- English proficiency at B1 level or higher
- LookML or experience with another semantic layer is an advantage
- Experience with dbt or a similar approach is an advantage
- Familiarity with data quality and observability tools such as Great Expectations, Soda, or Elementary is an advantage
- Experience configuring AI agents and repository instructions such as CLAUDE.md or AGENTS.md, and connecting MCP to warehouse or BI systems, is an advantage
- Kafka or NoSQL experience, including Elastic, is an advantage
- Ability to read PHP code to understand source system logic is an advantage
Benefits
- Access to Ecommpay’s internal Academy
- Relevant training and courses
- Financial support for external learning
- Remote or hybrid work arrangements, depending on location
- Flexible and independent working arrangements
- Collaboration with an international team
- Support and alternative vacancy formats available on request