Data Engineer, Cloud (Banking, 1-year renewable contract)

Dear Candidate,

If you or someone you know is interested in this opportunity, please forward your CV directly to [HIDDEN TEXT] (this is highly preferred, as I may miss some applications due to the volume received).

Please be aware that visa sponsorship is not available at this time.

Primary Responsibilities

• Design and enhance data and analytics solutions to meet business reporting and analytical needs.
• Create and sustain dependable data pipelines and transformation workflows utilizing SQL, Python, and contemporary data engineering tools.
• Construct and execute dimensional data models, which include Star schemas, Fact tables, Dimension tables, and Data marts.
• Develop and uphold data transformations using dbt or similar data transformation frameworks.
• Establish and oversee workflow orchestration through Airflow or an equivalent orchestration tool.
• Generate reusable business logic, semantic layers, and common business metrics to foster consistent analytics across the organization.
• Implement and manage ETL/ELT processes alongside data warehouse solutions.
• Adhere to software engineering best practices, such as Git/version control, code reviews, unit/data testing, and CI/CD.
• Monitor, diagnose, and resolve data quality, pipeline, and transformation challenges independently.
• Engage collaboratively with data engineers, analysts, developers, and business stakeholders to gather requirements and deliver impactful data solutions.
• Utilize existing business logic and processes to facilitate their migration or redesign using appropriate cloud-native technologies.
• Assist in the creation of analytical datasets used by BI, reporting, and business personnel.

Essential Requirements

• 3-6 years of pertinent experience in Data Engineering, Analytics Engineering, Data Warehousing, or related domains.
• Proficient hands-on experience with SQL.
• Working knowledge of Python for data processing and automation tasks.
• Strong comprehension and practical experience in dimensional data modeling, including:

o Star schemas

o Fact and Dimension tables

o Data marts

• Hands-on expertise with dbt or an equivalent data transformation framework.
• Experience with at least one workflow orchestration tool, such as Apache Airflow or similar.
• Solid understanding of semantic layers, business metrics, and reusable business logic.
• Thorough understanding of ETL/ELT and data warehouse concepts.
• Familiarity with modern software development practices, including:

o Git/version control

o Code reviews

o Unit and data testing

o CI/CD

• Capable of troubleshooting data and pipeline issues independently.
• Strong communication and collaboration abilities.
• Experience with Google Cloud Platform (GCP) is preferred.
• Familiarity with BigQuery, Cloud Composer, Cloud Storage, and other GCP data services is advantageous.
• Ability to comprehend existing .NET business logic and assist in the conversion or redesign of processes using suitable cloud-native technologies is preferred.
• Acquaintance with BI and reporting tools along with an understanding of how analytical datasets are utilized by business users is an advantage.