JOB DESCRIPTION
Location: Hybrid (Downtown, Toronto)
Duration: 4 months
Our client, a leading financial institution in Downtown Toronto, is looking for a Bilingual Data Engineer - Spanish, GCP, Python/ Java to move data from on-prem to the cloud, working with Mexico, Chile, and Peru as some of the main stakeholders. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.
Typical Day in role:
- There are multiple technologies in each country, so the goal is to build different data pipelines to ingest into the cloud for each
- Running processes from repositories into the cloud, including data management, connections, and patterns, and ensuring there is a clear vision for all the data sources; the main challenge is to understand how data is managed in each country and working with them; internally to organize and standardize data within the repository
- Design, develop, and maintain data pipelines and infrastructure on Google Cloud Platform (GCP) to support the creation of scalable data products. Reporting to the Senior Data Engineer, this role focuses on implementing robust and efficient data solutions to enable data-driven decision-making and support business objectives.
- Migration is the final goal
- Receiving use cases from business – sometimes mortgage, AML, analytics, and they will need to prioritize data pipelines accordingly
- Data Modelling to connect different needs from the business
- Standardize data from different sources and countries so that the Canadian banking stakeholders can understand
- Translate local business processes into global business ones
- Documentation and communication will be in English, though local communication with the remote teams for the respective countries will be in Spanish
- The main tool will be GCP and BigQuery for data storage
- Composer (Airflow on-prem) will be used for data transformation
- Build and maintain data pipelines and ETL/ELT processes on GCP to ensure reliable and efficient data flow for data products.
- Collaborate with the Senior Data Engineer and cross-functional teams (e.g., Data Scientists, Product Managers) to understand requirements and deliver high-quality data solutions.
- Implement data models, schemas, and transformations to support analytics and reporting needs.
- Ensure data quality, integrity, and performance by monitoring and optimizing data pipelines.
- Adhere to data governance, security, and compliance standards within GCP environments.
- Troubleshoot and resolve issues in data pipelines to minimize downtime and ensure operational efficiency.
- Contribute to the adoption of best practices and tools for data engineering, including documentation and testing.
- Stay updated on GCP services and data engineering trends to enhance pipeline capabilities.
Must-Have Skills:
- 8+ years of experience as a Data Engineer, with some recent experience working with ETL
- Bilingual in English and Spanish required (verbal / written professional proficiency in both)
- 3+ years of hands-on expertise in building data pipelines on cloud platforms, with a preference for Google Cloud Platform (GCP)
- 3+ years’ experience with GCP tools such as BigQuery, Dataflow, Pub/Sub, or Cloud Composer, Airflow
- 5+ years’ experience in programming languages like Python or Java and advanced SQL for data processing
Nice-To-Have Skills:
- 3+ years’ experience with data modelling, schema design, and data warehousing concepts.
- Familiarity with version control systems (e.g., Git) and basic CI/CD practices is a plus.
- Understanding of data governance and security practices in cloud environments.
- Experience in FI/banking
- Experience working in an Agile environment
Soft Skills Required:
- Strong problem-solving skills and ability to work collaboratively in a team environment.
- Effective communication skills to translate technical concepts to non-technical stakeholders.
Education:
- Bachelor’s degree in Computer Science, Data Engineering, Information Technology, or a related field.
FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The hourly compensation range for this role is C$60 - C$75. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.