Data Engineer - Freelance
Descrizione dell'offerta
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, GovernanceThe effectiveness 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 skilled and motivated Data Engineer - Freelance to join our team at Bitrock. You will be supporting a data platform migration project for a client operating in the fintech / wealth management sector, working autonomously on a well-defined scope that combines backend data pipeline work with frontend dashboard replication.
The ideal candidate is a hands-on Data Engineer with an eye for analytics, able to both build robust data pipelines and ensure the accuracy of business-facing dashboards. Experience working with dbt, Amazon Redshift, and BI tools is essential.
Key Responsibilities
Data Pipeline Engineering
- SQL Transformation: Reverse-engineer and replicate complex BigQuery SQL logic within the existing dbt project on Redshift
- Ingestion: Leverage the MongoDB to Redshift connector to ingest raw data, ensuring reliability and completeness
- Data Quality: Validate migrated data against source systems with full numerical reconciliation
- Documentation: Maintain well-structured metadata for all final tables, following the client team conventions
Dashboard & Analytics
- Dashboard Migration: Replicate Looker Studio dashboards in Metabase, preserving layout, metrics and filtering logic
- Accuracy: Ensure all migrated dashboards display exactly the same numbers as the originals
- Stakeholder Awareness: Dashboards serve non-technical users in commercial, ops, compliance and ExCo functions - clarity and correctness are critical
Collaboration
- Autonomy: Work independently within the client's existing toolset, using available documentation and migrated assets as reference
- Communication: Provide clear updates and flag blockers to the Bitrock and client teams in English
What wee need from you
- Solid experience with advanced SQL and complex data transformations
- Hands-on experience with Amazon Redshift
- Experience with dbt (Data Build Tool) for transformation pipeline management
- Familiarity with BI / data visualization tools (Metabase, Looker Studio or equivalent)
- Knowledge of Google BigQuery
- Experience with MongoDB or NoSQL databases as data sources
- Ability to analyse and reverse-engineer existing data pipelines
- Strong attention to detail and data accuracy (data reconciliation mindset)
- Fluent English
Start date: ASAP
Duration of the project: 3 months
Recruitment process:
Our recruitment process has 3 stages:
- First discovery short interview with our HR team
- Technical interview with our Data Engineering Lead
- Technical interview with the Client's Team
How to apply:
You can apply via LinkedIn or send your CV to