Senior Data Engineer (Databricks/Azure Data Factory) | f/m/d

ERGO; Województwo pomorskie; Hybrid; PLN 140,000 - 210,000; Full time

Benefits offered by this job

Medical package

Sports card

Flexible working hours

Remote working options

Dog-friendly office

Job summary

ERGO Technology & Services S.A. (ET&S) specializes in IT and business services with a focus on insurance processes and data-driven solutions. The team designs data models, builds ETL pipelines, and collaborates across domains to deliver scalable analytics and BI capabilities.

This role operates within an international Scrum team and supports regulatory-compliant data workflows. The position emphasizes SQL optimization, CDC implementation, and secure data access using Entra ID, AD, and

Qualifications

• Proven expertise in SQL optimization and MS SQL internals.
• Hands-on experience with Azure Data Factory pipelines and data integration.
• Proficient in Databricks and Python for data processing.
• Strong dimensional modeling and schema design skills.
• Experience implementing CDC in production environments.
• Knowledge of Entra ID/AD for secure data access and access control.

Responsibilities

• Designing and implementing data models and architectures to support financial data management.
• Developing and maintaining ETL processes to integrate data from diverse sources.
• Ensuring data quality, security, and regulatory compliance.
• Collaborating with business owners, analysts, scientists, and engineers to support predictive models and BI tools.
• Optimizing data processing workflows for performance, scalability, and reliability.
• Working in an international Scrum team.

Skills

SQL

Azure Data Factory

Databricks

Python

Dimensional modeling

CDC

CI/CD

Active Directory

Entra ID

Query optimization

Troubleshooting

Tools

MS SQL

CI/CD tools

AD Group Management

Job description

ERGO Technology & Services S.A. (ET&S), a member of the Munich Re and ERGO Group, is delivering integrated IT and business services to international markets. Our expertise lies in providing advanced IT services, with a focus on modern, business-driven technology solutions. On the business side, we also support the Group in various end-to-end insurance processes, including finance, operations, and underwriting. With offices in Warsaw and Gdansk, and strong global partnerships, we foster a dynamic, multicultural environment that promotes diversity and international opportunities.

How you will get the job done

• designing and implementing data models and architectures that support financial data management
• developing and maintaining ETL processes to integrate data from diverse sources, including market data feeds, customer information systems, and transactional databases
• ensuring data quality, security, and compliance with regulatory requirements
• collaborating with business owners, data analysts and scientists, software engineers, and DevOps specialists to support the development of predictive models and business intelligence tools
• optimizing data processing workflows for performance, scalability, and reliability
• working in an international Scrum team

Skills and experience you will need

• fluent spoken and written English
• expertise in writing and optimizing SQL code and good understanding of MS SQL internals
• hands-on experience with Azure Data Factory (ADF) pipelines
• proficiency in incremental and full data loads
• familiarity with CI/CD integration for data workflows
• knowledge of Databricks and Python for advanced data processing
• strong grasp of dimensional modeling and schema design
• experience implementing Change Data Capture (CDC) in production environments
• ability to configure and troubleshoot CI/CD pipelines for database deployments
• being skilled in pre- and post-deployment validations
• expertise in query optimization and resolving performance bottlenecks
• proficiency in debugging issues across staging and production environments
• familiarity with Active Directory (AD) group management
• knowledge of role-based access control
• integration experience with Entra ID for secure data access

What we offer

Let's be healthy

– medical package, sports card, and numerous sports sections – these are some of the benefits that help our employees stay in good shape.

Let's be balanced

– work-life balance is a key aspect of a healthy workplace. We offer our employees flexible working hours, a confidential employee assistant program, as well as the possibility of remote working. However, staying at home with our in-office gaming room and dog-friendly office in Warsaw won’t be easy.

Let's be smart

– we organize numerous workshops and training courses. Thanks to hackathons and meetups, our specialists share their expertise with others. Additionally, we have a wide range of digital learning platforms and language courses.

Let's be responsible

– each year, we participate in several CSR activities, during which, together with our colleagues, we do our best to create a better future.

Let's be fun

– company-wide bike races and soccer matches, film marathons in our cinema room or other engaging team-building activities – we got it covered!

Let's be diverse

– every team member is valued, regardless of gender, nationality, religious beliefs, disability, age, and sexual orientation or identity. Your qualifications, experience, and mindset are our greatest benefit!