Data Engineer (Redshift) - Freelance

Who we are

Bitrock is a high-end consulting and system integration company, strongly committed to offering cutting-edge and innovative solutions. Our tailored consulting services enable our clients to preserve the value of legacy investments while migrating to more efficient systems and infrastructure. We take a holistic approach to technology: we consider each system in its totality, as a set of interconnected elements that work together to meet business needs.

We thrive on overcoming challenges to help our clients reach their goals, by supporting them in the following areas: Data, AI & ML Engineering; Back-end Engineering, Platform Engineering, Front-end Engineering, Product Design & UX Engineering, Mobile App Development, Quality Assurance, FinOps, Governance. The effectiveness of our solutions also stems from partnerships with key technology vendors, like HashiCorp, Confluent, Lightbend, Databricks, and Meterian.

Who we are looking for

We are looking for a Data Engineer to join a high-impact project in the fintech/wealth management domain. In this role, you will contribute to the evolution of our client's data platform—built on Redshift, Airflow, and dbt—balancing fine-tuning of existing components with the modernization of legacy ones.

You are a technical problem-solver who can bridge the gap between business requirements and scalable data architecture while working seamlessly in an iterative environment.

Role Overview

As a Data Engineer, you will design, build, and maintain the data infrastructure responsible for ingestion, orchestration, and transformation. You will build analytical data models that guarantee high performance, scalability, and reliability, while reconciling large volumes of raw data from heterogeneous sources into coherent aggregates. Additionally, you will support machine learning and advanced analytics implementations, creating artifacts optimized for both human stakeholders and AI tools.

Key Responsibilities

• Design, implement, and maintain data infrastructure for ingestion, orchestration, and transformation (Airflow, dbt, Redshift).
• Build and maintain scalable, high-performing analytical data models.
• Reconcile large volumes of raw, heterogeneous data into meaningful and coherent aggregates.
• Support the deployment and implementation of Machine Learning and Advanced Analytics solutions.
• Produce data artifacts usable by both human teams and AI-driven tools.
• Collaborate cross-functionally with Data Analysts, Data Scientists, Software Engineers, Marketing Specialists, and Product Managers.

Required Skills

Must-Have:

• Experience: 3+ years of hands-on experience in Data Engineering roles.
• Core Tech Stack: Strong proficiency in SQL, Python, Airflow, and dbt.
• Data Warehousing & Cloud: Solid experience with Amazon Redshift and AWS ecosystem; familiarity with Infrastructure as Code (Terraform).
• Languages: Fluent in both Italian and English (collaborating with UK-based stakeholders).
• Soft Skills: Ability to translate complex business requirements into well-designed data solutions, excellent communication skills for non-technical stakeholders, and comfort working in iterative cycles.

Nice-to-Have:

• Experience in the Fintech or Wealth Management domain.
• Familiarity with BigQuery.
• Experience with conversion tracking and digital marketing data stacks (Adform, Adjust, Google Analytics, Google Tag Manager, Rudderstack).
• Mature, conscious use of AI tools to support daily workflow.

Contract Details:

• Type: Full-Time Consulting Project
• Start Date: asap
• Duration: 12 months
• Location: Hybrid — Milan (2 days/week on-site)

Recruitment process:

Our recruitment process has 3 stages:

1. First discovery short interview with our HR team
2. Technical interview with our Team Leaders
3. Final interview with our Client

How to apply:

You can apply via LinkedIn or send your CV to [email protected]