Associate Data Migrations Engineer

KEY RESPONSIBILITIES** **Data Ingestion & Integration** - Contribute to data ingestion workflows, pulling from relational and NoSQL databases, REST APIs, and flat files with attention to data quality and consistency. **Pipeline Development** - Support the design and development of ELT pipelines, following team standards and data engineering best practices. - Assist with monitoring pipeline executions across cloud and on-premises environments, escalating issues as appropriate. **Storage & Warehousing** - Assist in implementing and maintaining data storage solutions including Data Warehouses and Data Lakes. - Write and optimise SQL queries to support downstream analytics and reporting use cases. **Collaboration & Documentation** - Work closely with cross-functional teams — analysts, engineers, and client stakeholders — to understand requirements and deliver fit-for-purpose solutions. - Maintain clear documentation for pipelines, data models, and processes, contributing to a culture of engineering rigour. **Learning & Growth** - Actively engage with DevOps and DataOps practices, absorbing team patterns around CI/CD, version control, and code review. ## Requirements * * * - 1–2 years of hands-on experience in Python (primary) or another language such as Java, Scala, or Ruby. - Solid intermediate SQL — comfortable with joins, aggregations, and window functions. - Working knowledge of Git via GitHub, GitLab, or Bitbucket. - Basic familiarity with dbt — models, sources, and the test/documentation workflow. - Foundational understanding of at least one public cloud platform (AWS, GCP, or Azure). - Basic understanding of data structures and algorithms. - Intellectual curiosity and eagerness to learn in a fast-paced consulting environment. - Strong written and spoken English and Portuguese. - Comfortable asking questions, contributing in team discussions, and receiving technical feedback. ## Nice to have * * * - Exposure to orchestration tools such as Apache Airflow or Dagster. - Awareness of distributed processing frameworks (Spark, Dask, or similar). - Prior experience in a consulting or client-facing environment. ## Perks * * * - Holiday Entitlement: 25 days holiday plus bank holidays. - Learning & Development: €1,500 training budget + 5 training days. - Company Bonus: Discretionary company and personal bonus paid quarterly. - Pension Scheme. - Choose Your Kit: Select from a range of laptops and accessories. - Social Events: meetups, squad events, summer/Christmas events, etc. - And many others.