Data Engineer

Citi; Mississauga; On-site; CAD 80,000 - 110,000; Full time

Job summary

Citi is seeking a skilled Python and Database Developer to join their technology team in Mississauga. The role involves creating data processing pipelines, optimizing database applications, and ensuring data integrity. Ideal candidates have strong programming skills in Python, solid database knowledge, and experience with data governance.

Qualifications

• 5+ years of experience in a Data Engineering role.
• Strong proficiency in Python, complex SQL, and optimizing queries.
• Experience with data warehousing concepts and large datasets.

Responsibilities

• Develop data pipelines for ingestion, transformation, and loading.
• Optimize data models and implement data quality checks.
• Contribute to data governance policies and ensuring compliance.

Skills

Python

SQL

Data Visualization

API Development

Data Governance

Data Quality Assurance

Communication

DevOps Practices

Education

Bachelor's degree in Computer Science, Software Engineering, or a related field

Tools

Pandas

NumPy

Streamlit

Flask

Jenkins

Kubernetes

Job description

We are seeking a skilled and motivated Python and Database Developer to join our dynamic technology team. The ideal candidate will possess strong programming skills in Python, a solid understanding of database systems, and the ability to design, develop, and maintain efficient and scalable applications. This role involves working on a variety of projects, including data processing pipelines, web applications, and database integrations.
Responsibilities and Duties

• Involvement with development of data pipelines for ingestion, transformation, and loading of data from various sources (databases, APIs, streaming platforms) into our data warehouse/lake, ensuring seamless data flow and accessibility.
• Optimize data models for query performance and data accessibility.
• Ensure data models are well-documented and aligned with industry best practices.
• Data Quality Assurance: Implement robust data quality checks and monitoring systems to ensure data integrity and accuracy, proactively identifying and resolving data issues.
• Data Governance Contribution: Contribute to the design and implementation of data governance policies and procedures, ensuring compliance with regulatory requirements and internal standards.

Required Skills and Qualifications:

• 5+ years of hands-on experience in a Data Engineering role
• Strong proficiency in Python (version 3.6+), with experience in Python packaging and shared libraries like Pandas and NumPy.
• Experience working with Streamlit ,Plotly, Matplotlib, Seaborn and various popular libararies for building adhoc reporting and Data Visualization tools
• Handon experience working with relational databases, writing complex SQL, and optimizing queries for performance.
• API Development: Experience implementing REST APIs in Python using microframeworks like Flask.
• Experience with Java developed is a plus
• Good understanding of data warehousing concepts and experience working with large datasets, including data modeling and ETL processes.
• Communication Skills: Strong communication skills, both written and verbal, with the ability to explain complex technical concepts to both technical and non-technical audiences.
• DevOps Practices: Experience working in a Continuous Integration and Continuous Delivery environment and familiarity with tools like Jenkins, TeamCity, SonarQube, OpenShift, ECS, or Kubernetes.
• Communicate technical concepts and solutions effectively to both technical and non-technical audiences.
• Provide technical support and troubleshooting for production systems.
• Education: Bachelor's degree in Computer Science, Software Engineering, or a related field.

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi .

View Citi’s EEO Policy Statement and the Know Your Rights poster.