описание
The project modernizes retail technology and establishes 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. The customer is an established financial services provider offering solutions for individuals and organizations with long-term financial planning and investment needs.
задачи
- Analyze data requirements and source-to-target mapping specifications, and define risk-based test coverage
- Design and build a data test automation framework from scratch using Python and metadata-driven tests, targeting 80%+ automation coverage
- Automate test design, execution, and reporting
- Validate data across lakehouse layers (bronze, silver, gold) against source systems
- Perform automated data reconciliation at scale across tens of millions of records, including counts, key-level, column-level, and row-level checks
- Reconcile transformed data (3NF / Data Vault in silver, Kimball star/snowflake in gold) against source data using business keys and control totals
- Define comparison tolerances with data owners and document them in acceptance criteria
- Test data transformations, ETL processes, incremental loads, and SCD type 2 history
- Prepare synthetic test data for a greenfield data model with no migrated data
- Test data in Databricks and Microsoft Fabric
- Test Power BI reports, measures, dashboards, and paginated reports against underlying data
- Integrate automated tests into ADO pipelines as quality gates
- Develop and maintain test code alongside data engineers in GitHub / ADO repositories
- Apply AI/LLMs, including GitHub Copilot and agents, in test design, test data generation, and failure triage as part of an AI-native SDLC
- Ensure automated tests produce consistent and reliable results
- Consider verification within the wider enterprise data landscape and downstream reporting
требования
- Senior-level candidate with 6+ years of experience and solid hands-on experience in data testing
- Experience with enterprise data testing at scale, including data warehouses / lakehouses, ETL / ELT, and data migration
- Knowledge of data reconciliation approaches, including source-to-target, post-transformation, large-volume, and tolerance-based comparisons
- Strong SQL / T-SQL skills and database fundamentals
- Understanding of data modelling, including 3NF, Data Vault, Kimball dimensional models, and SCD
- Experience building data test automation frameworks from scratch
- Knowledge of Python or C#
- Experience with Databricks, including Delta Lake and PySpark / Spark
- Experience with Azure DevOps (ADO Pipelines), GitHub, and integrating automated tests into CI/CD
- Ability to work closely with data engineers and maintain test code in repositories
- English proficiency at Intermediate+ level or above
- Будет плюсом: 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
условия
- The opportunity to change the project and/or develop expertise in an interesting business domain
- Professional, financial, and career growth; mentoring and adaptation systems for each new employee
- Opportunity to earn up to an additional 1,000 EUR per month, depending on expertise level, included in the annual bonus for participating in company activities
- Access to the corporate training portal and its regularly updated knowledge base
- Corporate events and amenities, including parties, pizza days, PlayStation, fruit, coffee, snacks, and movies
- Certification compensation (AWS, PMP, etc.)
- Referral program
- Private health insurance and sports compensation, depending on the type of employment
- Work is available fully remotely, from the office, or in a hybrid format
- Work locations: Austria, Belgium, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Hungary, Italy, Latvia, Lithuania, Luxembourg, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, The Netherlands
навыки
компания
Международная компания по разработке ПО и цифровой трансформации с услугами заказной разработки и staff augmentation.