Software Engineer in Test (EU)

About the project

Andersen is hiring a Software Engineer in Test in the EU for a project modernizing retail technology and ensuring quality across a scalable enterprise data and analytics platform.

Our customer is an established financial services provider offering a range of solutions designed to support individuals and organizations with long-term financial planning and investment needs. The company combines industry expertise with modern technology to deliver reliable, customer-focused services and simplify complex financial processes. By continuously developing its digital capabilities and service offerings, the organization aims to improve customer experience, operational efficiency, and accessibility while supporting sustainable long-term financial outcomes.

The project is focused on modernizing retail technology and establishing a secure, scalable, and governed enterprise data and analytics platform. It aims to transform reporting capabilities, integrate key data sources, and support regulatory and operational reporting, advanced analytics, data migration, and future strategic data products.

Responsibilities

• Analysing data requirements and source-to-target mapping specifications and defining risk-based test coverage.
• Designing and building a data test automation framework from scratch (Python, metadata-driven tests, target 80%+ automation coverage).
• Automating test design, test execution and test reporting.
• Validating data across lakehouse layers (bronze, silver, gold) against source systems.
• Performing automated data reconciliation at scale (tens of millions of records): counts, key-level, column-level and row-level checks.
• Reconciling transformed data (3NF / Data Vault in silver, Kimball star/snowflake in gold) back to source on business keys and control totals.
• Defining comparison tolerances together with data owners and documenting them in acceptance criteria.
• Testing data transformations / ETL processes, incremental loads and SCD type 2 history.
• Preparing synthetic test data for a greenfield data model with no migrated data.
• Testing data in Databricks and Microsoft Fabric.
• Testing Power BI reports, measures, dashboards and paginated reports against the underlying data.
• Integrating automated tests into ADO pipelines as quality gates.
• Developing and maintaining test code alongside data engineers in GitHub / ADO repositories.
• Applying AI/LLMs (GitHub Copilot, agents) in test design, test data generation and failure triage as part of an AI-native SDLC.
• Ensuring automated tests give consistent and reliable results.
• Thinking about verification in the context of the wider enterprise data landscape and downstream reporting.

Requirements

• Senior level, 6+ years of experience, with solid hands-on experience in data testing.
• Enterprise data testing at scale: data warehouse / lakehouse, ETL / ELT, data migration.
• Data reconciliation approaches: source-to-target, after transformation, large volumes, tolerance-based comparison.
• Strong SQL / T-SQL and database fundamentals.
• Understanding of data modelling: 3NF, Data Vault, Kimball dimensional models, SCD.
• Experience building data test automation frameworks from scratch.
• Knowledge of Python/C#.
• Databricks (Delta Lake, PySpark / Spark).
• Azure DevOps (ADO Pipelines), GitHub; integrating automated tests into CI/CD.
• Ability to work closely with data engineers and maintain test code in repositories.
• Level of English – from Intermediate+ and above.

Nice to have

• Microsoft Fabric, Azure Data Factory.
• Power BI, DAX; testing reports, paginated reports and dashboards.
• Practical experience with AI/LLM-based testing approaches and GitHub Copilot, with concrete examples.
• Great Expectations or similar data quality frameworks.
• Insurance, pensions or financial services data domain.
• Microsoft Fabric certification DP-600 or DP-700; Databricks certification.
• Data engineering background.

Why join us

• Experience in teamwork with leaders in FinTech, Healthcare, Retail, Telecom, and others. Andersen cooperates with such businesses as Samsung, Siemens, Johnson & Johnson, BNP Paribas, Ryanair, Mercedes, TUI, Verivox, Allianz, T-Systems, etc..
• The opportunity to change the project and/or develop expertise in an interesting business domain.
• Job conditions – you can work both fully remotely and from the office or can choose a hybrid variant.
• Guarantee of professional, financial, and career growth! The company has introduced systems of mentoring and adaptation for each new employee.
• The opportunity to earn up to an additional 1,000 EUR per month, depending on the level of expertise, which will be included in the annual bonus, by participating in the company's activities.
• Access to the corporate training portal, where the entire knowledge base of the company is collected and which is constantly updated.
• Bright corporate life (parties / pizza days / PlayStation / fruits / coffee / snacks / movies).
• Certification compensation (AWS, PMP, etc).
• Referral program.
• Private health insurance and sports compensation, depending on the type of employment.