Expert Data Engineer

DCG; Województwo mazowieckie; On-site; PLN 120,000 - 180,000; Full time

Benefits offered by this job

Private medical care

Co-financing for fitness card

Dedicated consultant support

Job summary

DCG is seeking a data/ETL specialist to support multiple recruitment projects with a focus on SQL Server, SSIS, and Snowflake. You will design, develop and maintain complex ETL processes, ensuring data quality and timely deployments while collaborating with a global team.

The role requires strong analytical skills, excellent English, and hands-on experience with SQL Server, SSIS, and Git. A proactive problem solver will thrive in this environment.

Qualifications

• Strong hands-on experience in Microsoft SQL Server and T-SQL.
• Proven experience with SSIS for ETL package development and maintenance.
• Practical experience with SQL Server Agent job scheduling and monitoring.
• Solid understanding of ETL concepts, data warehousing, and dimensional modelling.
• Hands-on knowledge of Git or other version control systems.
• Experience working with Snowflake cloud data platform.
• Ability to implement data validation and data quality controls within ETL processes.
• Experience in database maintenance, query optimization, and performance tuning.
• Strong analytical and problem-solving skills.
• Very good command of English, both spoken and written.

Responsibilities

• Strong hands-on experience in Microsoft SQL Server and T-SQL.
• Develop and maintain ETL packages using SSIS.
• Manage SQL Server Agent job scheduling and monitoring.
• Maintain version control using Git.
• Work with Snowflake cloud data platform.
• Build data extraction, transformation, and loading processes from multiple sources.
• Design and optimize stored procedures, functions, views, and SQL scripts.
• Implement data validation and data quality checks in ETL.
• Understand ETL concepts, data warehousing, and dimensional modelling.
• Handle deployments and changes.
• Perform database maintenance including index and query optimization.

Skills

SQL Server

T-SQL

ETL

Data modelling

English fluency

Tools

SSIS

Git

Snowflake

SQL Server Agent

Job description

As a recruitment company, DCG understands that every business is powered by experienced professionals. Our management style and partnership approach enable us to meet your needs and provide continuous support. Due to our ongoing growth and the large number of recruitment projects we undertake for our partners, we are currently looking for:

Responsibilities:

• Strong hands-on experience in Microsoft SQL Server and T-SQL
• Experience in developing and maintaining ETL packages using SQL Server Integration Services (SSIS)
• Experience with SQL Server Agent job scheduling and monitoring
• Knowledge of version control systems such as Git
• Knowledge of cloud-based data platform Snowflake
• Build and maintain data extraction, transformation, and loading processes from multiple source systems
• Design, develop, and maintain complex stored procedures, functions, views, and SQL scripts to implement business rules and data transformation logic
• Implement data validation and data quality checks within ETL processes
• Knowledge of ETL concepts, data warehousing, and dimensional modelling
• Manage changes and deployments activities
• Perform database maintenance activities, including index, query optimization and performance tuning
• Strong analytical and problem solving abilities

Requirements:

• Strong hands-on experience in Microsoft SQL Server and T-SQL
• Proven experience with SQL Server Integration Services (SSIS) for ETL package development and maintenance
• Practical experience with SQL Server Agent job scheduling and monitoring
• Solid understanding of ETL concepts, data warehousing, and dimensional modelling
• Hands-on knowledge of Git or other version control systems
• Experience working with Snowflake cloud data platform
• Ability to implement data validation and data quality controls within ETL processes
• Experience in database maintenance, query optimization, and performance tuning
• Strong analytical and problem-solving skills
• Very good command of English, both spoken and written

Nice to have:

• Knowledge of Generative AI
• Knowledge of Machine Learning

Offer:

• Private medical care
• Co-financing for the sports card
• Constant support of dedicated consultant