Data & Analytics Engineer (h/f)

emagine is a high-end professional services consultancy and solutions firm specialising in providing business and technology services to the financial services sector, we power progress, solve challenges and deliver real results through tailored high-end consulting services and solutions.

We have created a culture of openness and integrity by building genuine and strong relationships and partnerships, enabling us to be uncompromising in our dedication in delivering the optimal service for our clients. Our commitment is not just towards our clients but we aim to foster a positive and equitable working environment with our consultants and colleagues which stems from our core values: Confident, Dedicated, Responsible, Genuine.

We are looking for an experienced Analytics Engineer to join our data team on a freelance basis. This is a critical role that requires a rare combination of technical expertise and the ability to integrate seamlessly into an existing data environment.

The ideal candidate will have extensive experience with Looker/LookML, dbt, and data warehouses like Snowflake and BigQuery. They should also be proficient in modern cloud platforms (AWS/GCP) and be capable of maintaining and improving our data stack. This role will support key initiatives around Real Time data processing, data modelling, and Business Intelligence during a period of growth.

Key Skills & Experience:

1. Looker/LookML Expertise:

   • Deep experience building custom reports, dashboards, and data models in Looker, including proficiency with LookML (Looker's modelling language).

   • Ability to handle complex Looker setups and support user customization needs.

2. DBT (Data Build Tool):

   • Advanced proficiency in dbt for data transformation, model building, and pipeline orchestration.

3. SQL Expertise:

   • Strong SQL skills for querying and manipulating data in relational databases.

4. Cloud Data Warehouse Experience:

   • Proficient in working with Snowflake and BigQuery for managing data models, optimizing pipelines, and ensuring data quality and performance.

5. Cloud Platforms:

   • Familiarity with AWS and GCP for managing and integrating cloud-based data systems.

6. Real Time Data Processing:

   • Experience working with Real Time data environments, especially in transaction-heavy systems.

7. Business Intelligence (BI):

   • Strong background in BI tools and processes, enabling you to transform data into actionable insights for decision-making.

8. Industry Knowledge (Ideal but not required):

   • Experience with parking transaction data, pricing optimization models, or user behavior analysis in urban environments would be beneficial.

Responsibilities:

• Maintain & Enhance Data Infrastructure:

  • Manage and improve the existing data stack (Snowflake & BigQuery), ensuring it is optimized for performance and scalability.

• Support Data Team:

  • Serve as an interim bridge, supporting the data team during the transition period while a permanent team member is sought.

• Optimize Data Models & Pipelines:

  • Enhance data models and optimize pipelines to ensure they support Real Time data processing and complex Business Intelligence needs.

• Collaborate with Stakeholders:

  • Work closely with data scientists, analysts, and other key stakeholders to translate business needs into effective data solutions.

Ideal Candidate:

• Experience: 5+ years of experience in analytics engineering or data engineering, with a focus on data transformation, business intelligence, and cloud-based data platforms.

• Technical Proficiency: Expertise in Looker, LookML, dbt, Snowflake, BigQuery, SQL, and cloud platforms like AWS/GCP.

• Adaptability: Ability to quickly understand an existing data environment and make immediate contributions.

• Collaborative Mindset: Comfortable working in a dynamic, fast-paced environment and partnering with a cross-functional team.

Location & Duration:

• Location: Amsterdam (hybrid working environment)

• Contract: Freelance or consultant, duration of 3-6 months (with immediate start)

If you're looking for a challenging opportunity where you can apply your advanced technical skills and help maintain a high-impact data environment, we'd love to hear from you.