Data Engineer / SQL Specialist

Mid • Remote

Gdańsk, Poland

Start: ASAP

Contract: B2B 12 months + prologantions

Work mode: 100% remote

Project language: English

Recruitment process: 1 screening + 2 interviews

Summary:

The primary objective of the Data Engineer / SQL Specialist role is to enhance the organization's analytical capabilities by developing and managing SQL-based data solutions on the Databricks platform. This position aims to ensure robust data modeling and transformation processes that meet business needs.

Responsibilities:

Develop and maintain SQL-based data pipelines and transformation logic on Databricks.
Design, implement, and optimize star and snowflake schemas for analytical workloads.
Write and tune advanced SQL queries for reporting, aggregation, and data validation.
Collaborate with data engineers and analysts to ensure data models meet business needs.
Work with structured and semi-structured data from multiple sources.
Contribute to improving data quality, performance, and maintainability.

Must Haves:

Solid experience with SQL (including analytical functions, joins, subqueries, CTEs, window functions, etc.).
Practical experience with Databricks, Spark SQL, or similar distributed SQL engines.
Strong understanding of data modeling principles, particularly star and snowflake schemas.
Experience with relational databases (e.g., PostgreSQL, SQL Server, or similar).
Familiarity with ETL/ELT concepts and best practices.
Ability to work independently and collaboratively within a data team.

Nice to Have:

Exposure to dbt, Delta Lake, or data warehousing concepts.
Basic knowledge of Python or PySpark.
Experience with cloud platforms (Azure, GCP, or AWS).

emagine Polska

emagine Polska is a company operating in the telecommunications industry, based in Warsaw, Poland. The company is involved in innovative projects, focusing on the development and maintenance of portals using modern technologies. Emagine Polska values creativity, motivation, and independence in its team members, emphasizing a collaborative work environment. The company is structured to support agile methodologies, particularly SCRUM, and is integrated with DevOps practices, highlighting its commitment to efficient and effective project management. Emagine Polska is distinguished by its focus on leveraging cutting-edge technologies like React.js and TypeScript, and its dedication to fostering a culture of continuous improvement and innovation.