Kozak Agency

Interview process: Hr call 30min, 1 intro call + 1 technical interview (1 hour)
Location EU
Timezone: CET
English: C1 ideally
 

Critical Note
 This role is for an Architect, not a Data Engineer. Candidates who have only implemented pipelines without owning end-to-end architecture decisions will not be considered — this is explicitly called out multiple times by the client.
 

Project Overview
 Client needs a Data Architect to take ownership of an existing, complex, partially problematic Azure data platform — assess it quickly, separate tactical fixes from long-term architecture, and produce implementation-ready recommendations that engineering teams can act on immediately.
 

What You'll Do
Design, build, and optimize scalable data architectures on Databricks + Azure
Own end-to-end architecture decisions — not just implement pipelines
Assess an existing, incompletely documented platform and deliver concrete, actionable output within the first 1–2 weeks
Design scalable, reusable, metadata/configuration-driven ingestion frameworks (multiple databases, APIs, file-based sources)
Work hands-on with Azure Cosmos DB — data modeling, partition-key strategy, indexing, RU/throughput optimization, scaling, consistency, Change Feed
Work across Synapse workload patterns: Pipelines, Spark, Serverless SQL, Dedicated SQL Pools
Handle genuinely unstructured data — documents, PDFs, scans, free text, images, emails (real examples required, not theoretical)
Make technology-neutral architecture calls — comfortable concluding Databricks/Synapse/ADF may NOT be the right fit if scale/cost/requirements don't justify it
Separate and progress tactical stabilization vs. long-term target architecture in parallel
Produce clear architecture documentation, diagrams, and technical recommendations for engineering teams
Collaborate with engineering, analytics, and business stakeholders; mentor junior team members
 

Must-Have Requirements
Architecture ownership — proven, concrete examples of personally designing/owning a data platform architecture (not just pipeline implementation)
Azure — hands-on, recent (not years-old), 4+ years minimum. Azure DevOps usage alone does NOT count as Azure cloud experience
Databricks — must have real hands-on experience
Azure Cosmos DB — must have hands-on experience (scaling, partitioning, RU optimization, advanced design decisions) — this is one of the most heavily emphasized requirements in the entire brief
Azure Synapse — depth across multiple workload patterns, not surface-level exposure
Unstructured data — proven, real examples (not just structured/relational data experience)
Metadata/configuration-driven ingestion — must be able to explain a reusable ingestion framework design in depth
Existing platform modernization — concrete example of inheriting a problematic platform and improving it
Python, SQL, ETL/ELT
Strong data modeling (fact tables, dimensional/star schemas)
Batch + incremental processing/refresh
Strong communication with both technical and business stakeholders
CV must contain clear, detailed hands-on Azure experience — vague CVs will result in automatic rejection

Nice to Have
Future-oriented thinking on AI / natural-language querying of enterprise data
Experience with legislation/regulated data platforms (client referenced a similar past project: legislation data platform on Azure Synapse — XML/API pipelines, medallion architecture)
 

Interview Prep Note (for candidate)
 Client wants 2–3 strong real project examples structured as: Problem → options considered → personal decision → why → implementation → result. Expect deep technical probing on Cosmos DB and Synapse specifically, plus a scenario where Databricks is deliberately removed from the discussion to test technology-neutral thinking.

We are looking for a Java + Angular Developer for a potential client project.

Requirements:

• Strong experience with Java
• Good experience with Angular
• Polish language — conversational or higher
• Good English is a plus
• Commercial development experience

At this stage, we are only collecting CVs. Project details, scope, and other requirements will be shared later.

Type: Full-time

Position Description:
As a Data Engineer, you will play a key role in designing and maintaining scalable data pipelines and platforms.
You’ll work closely with data scientists, analysts, and product teams to ensure high-quality, reliable, and scalable data is always available. This role requires deep technical expertise, strong analytical skills, and exposure to emerging AI/LLM technologies
Location(s): Germany & EU
Working Model: remote

Role Overview
As a Senior Data Engineer, you will play a key role in designing and maintaining scalable data pipelines and platforms. You’ll work closely with
data scientists, analysts, and product teams to ensure high-quality, reliable, and scalable data is always available. This role requires deep
technical expertise, strong analytical skills, and exposure to emerging AI/LLM technologies.

Key Responsibilities

• Design, develop, and optimize scalable data pipelines using Python and PySpark.
• Build, manage, and optimize big data solutions leveraging Google Cloud Platform (BigQuery, DataProc, Dataflow).
• Collaborate with cross-functional teams to translate business requirements into efficient data models and workflows.
• Ensure data accuracy, consistency, and availability across multiple systems and applications.
• Implement best practices for data governance, quality, and security.
• Stay updated with advancements in big data, cloud, and AI technologies, recommending innovative solutions.
• Mentor junior engineers and establish best practices within the team.

Requirements for "Professional Skills"
All professional skills required to fulfill the following general task description:
Works as a developer and is responsible for the development and programming of software, tools, systems, etc., as well as the associated troubleshooting and error analysis. This role requires comprehensive knowledge of various programming languages as well as appropriate development tools, methodologies, and development processes.

Works on the integration of systems, applications, or databases with one another or into other systems/software. This role requires exceptional knowledge of scripting and various programming languages, along with relevant integration tools, methods, and processes. It also requires a strong understanding of the technologies or systems being integrated.

Also works as an engineer and documents operational requirements in the form of system performance parameters and system configurations. He/she is additionally responsible for ensuring the seamless integration of architecture and development.

This also includes system integration or network integration activities, for example, SDM.

Projects using Agile development methodology:
If the contractor works within a Scrum team, they possess extensive knowledge of Scrum methodology and have experience in developing software within such a framework.

Requirements for "Social Skills"
All social skills required to fulfill the previously mentioned general task description as well as the following requirements:
The employee has intermediate-level experience, typically between 2 and 5 years, in their role or in the tasks performed by the group. Alternatively, the role and responsibilities require solid, but not exceptional, expertise.
The activities are associated with a moderate level of complexity and responsibility and require the ability to work independently.
The project may be carried out at either a national or international level.

Other Requirements & Relativizations
Skill Sets
Core Technical Skills

• Python (expert-level coding, modular programming, debugging, performance optimization)
• PySpark (distributed processing, tuning, handling large-scale data, performance optimization)
• Google Cloud Platform (GCP):
• BigQuery – advanced SQL, optimization, partitioning, clustering, cost management
• DataProc – Spark/Hadoop cluster management, job orchestration
• Dataflow – streaming & batch pipelines, real-time processing

Big Data & Cloud Skills

• Strong understanding of big data technologies (distributed computing, Hadoop/Spark ecosystem, data lakes, Kafka, batch & stream processing)
• Experience with data modeling and designing scalable data pipelines
• Familiarity with cloud-native architectures and serverless processing
•  

Analytical & Problem-Solving Skills:

• Ability to analyze complex data sets and derive insights
• Strong logical and critical thinking
• Experience optimizing query performance and pipeline efficiency
• Comfortable troubleshooting large-scale data workflows
• Preferred / Nice-to-Have Skills
• Experience with CI/CD pipelines for data engineering workflows
• Workflow orchestration: Airflow, Cloud Composer, Dagster
• Data governance, data quality frameworks, and compliance standards
• AI & Advanced Analytics Exposure
• Familiarity with Large Language Models (LLMs) and their applications in data workflows
• General understanding of AI/ML concepts and how they integrate with data engineering pipelines
• Exposure to MLOps tools or frameworks for deploying and monitoring AI models

Soft Skills

• Strong communication and collaboration with cross-functional teams
• Ability to work in Agile environments
• Mentoring and guiding junior engineers
• Self-driven, proactive learner, and adaptable to emerging technologies

Key details:
Start date: 1 October 2026
Duration: initially until 31 December 2026
Option to extend: until 31 December 2027
Workload: approx. 400 hours in 2026, with an option to extend to approx. 1,680 hours in 2027
Location: predominantly remote (approx. 80%), with occasional assignments in Hanover or at the client’s premises.

Project background: As part of an AI and machine learning initiative, we are driving forward the further development and support of data-driven solutions for various specialist areas within the social security sector. We are seeking support in the development, optimisation and operation of modern data and AI platforms.

Responsibilities:

• Carrying out data collection, data cleaning and data transformation
• Creating and maintaining dashboards for data visualisation
• Setting up and maintaining data pipelines
• Identifying and testing new areas of application for AI-based solutions

Requirements:

• At least 2 years’ experience with SQL, data transformations, data pipelines and data storage (DB/DWH)
• At least 2 years’ practical experience in software development using Python
• At least 2 years’ experience in developing ETL pipelines
• At least 2 years’ experience in data-driven projects (please specify the project objective of each reference project, your role and the tasks you carried out)
• At least 2 years’ experience in agile development teams
• German language skills at C1 level or higher !!!

Desirable:

• Two years’ professional experience in CI/CD development
• Two years’ professional experience with Jenkins and ArgoCD
• Two years’ professional experience with Argo Workflows
• Two years’ professional experience with Kubeflow or OpenShift AI in a machine learning environment
• Two years’ professional experience with machine learning and the practical application of ML models
• Two years’ professional experience with unit and integration testing
• Two years’ experience in the field of statutory social insurance
• Two years’ project work in a SAFe environment

Workload: full-time, remote
Start: asap
Duration: long and fixed-term (~9–12 months) but with a right to a 8 week notice period
Location: Poland !!!
English: B2

Important info:
Client is very technical and knows who they are looking for, has to be Poland based, max 2-3 hours travel to Wrocław as they have a small team in Wrocław, Poland. Mid + senior profiles are okay.

The Role
A backend-focused engineering position on a transformation project for an international travel company. The engineer will own features end-to-end - from planning and design through building, testing, and release.

Key Responsibilities

• Own features end-to-end (plan, design, build, test, release)
• Build and maintain Ruby on Rails systems
• Contribute to full-stack work (Rails-heavy, with frontend involvement as needed)
• Write tested, high-quality code
• Use AI coding agents to maximize efficiency
• Participate in code reviews
• Maintain systems and resolve production issues
• Collaborate with Product, Design, and Quality Engineering teams

Required Qualifications

• Proficiency in Ruby on Rails with production experience
• Strong database schema design and data modeling skills
• RESTful API design experience
• PostgreSQL and AWS infrastructure knowledge
• Demonstrable experience with AI coding agents, or strong enthusiasm to adopt them
• Good English
• Team-oriented with strong communication skills
• Pragmatic about speed/quality/scope tradeoffs

Tech Stack
Ruby on Rails, PostgreSQL, AWS, Next.js, Vercel. Trunk-based development with CI/CD and multiple daily deployments.

Nice to Have

• E-commerce or travel platform experience
• An eye for UX/design
• Travel enthusiasm

The Consultant will be responsible for designing, developing, and maintaining Power BI reporting and automation solutions to support business decision-making across the organization. This role will drive the company’s Power BI automation strategy, leveraging Microsoft Fabric, Power Platform tools, and Azure services to implement scalable, automated, and intelligent reporting solutions.

Key Responsibilities:
1. Power BI Development & Reporting Automation

• Design, develop, and maintain interactive Power BI reports and dashboards to support various business functions.
• Implement automated reporting workflows based on predefined thresholds, alerts, and KPIs to proactively notify stakeholders of key business changes.
• Develop and optimize data models, DAX calculations, and Power Query transformations to ensure efficient performance and scalability.
• Ensure high standards of data accuracy, consistency, and security within the Power BI environment.

2. Microsoft Fabric Implementation

• setup and management of Microsoft Fabric environments, including Data Factory, Lakehouse, Warehouse, and Pipelines.
• Collaborate with the data engineering team to design and deploy end-to-end data pipelines using Fabric for unified data management.
• Leverage Fabric features to automate data ingestion, transformation, and delivery for enterprise reporting.

3. Power Platform Integration (Power Automate & Power Apps)

• Develop and maintain Power Automate workflows for data refresh scheduling, alert automation, and system integration.
• Build Power Apps solutions to provide interactive business tools that complement Power BI reporting.
• Ensure seamless integration across Power BI, Power Automate, Power Apps, and other Microsoft 365 services.

4. Copilot & AI-Driven Reporting 

• Implement and configure Microsoft Copilot agents to enable AI-powered, natural language-driven analytics and user assistance.
• Integrate Copilot within Power BI and Fabric environments to enhance report creation and automation efficiency.
• Evaluate and deploy emerging AI-driven analytics features to improve reporting intelligence and user experience.

Experience:
Professional Experience: !!!

• Minimum 10+ years of experience in Power BI development, data modeling, and business intelligence reporting.
• Proven experience in Microsoft Fabric (Data Factory, Lakehouse, Warehouse, Pipelines,Data Agent).
• Hands-on experience with Power Automate and Power Apps for workflow and app automation.
• Practical knowledge of Azure data ecosystem (Data Factory, Synapse, Azure SQL).
• Experience in SAP BW integration and data extraction to Power BI or Azure environments is a strong advantage.
• Experience with AI/Copilot-enabled reporting and data automation concepts.

 
Technical Competencies:

• Advanced proficiency in Power BI, including DAX, Power Query (M language), and data modeling.
• Advance proficiency in MS Fabric
• Strong understanding of data warehouse concepts, ETL processes, and data governance.
• Proficiency in SQL, Azure services, and data performance optimization.
• Ability to design end-to-end reporting solutions from data source to visualization.
• Strong analytical and problem-solving skills with attention to detail.

Ongoing product — developer platform;

blockchain infrastructure company that enforces regulated transaction rules (AML/CFT checks, offchain collateral requirements) at the smart contract layer with cryptographic verification before onchain execution. Role: lead technical direction of the dashboard, SDK and API infrastructure that makes the protocol accessible to developers; build visualization tools for monitoring policy enforcement and network activity; partner with protocol engineers on developer-friendly abstractions and documentation

 

• Backend: Go (production, primary language, hard requirement)
• Frontend: React, Next.js

100% overlap with EST hours required — for Europe, roughly 3pm–11pm local time ( по Києву 16:00-00:00)