About Us
Founded in 2020, Ai Financial’s core team brings over 20 years of experience from Stock market, Options, Investment banking, banking, mutual fund, insurance and segregate fund. We provide Canadian residents with professional investment advice and asset management services.
Our mission is simple: to empower all Canadians to achieve a happy, healthy, and prosperous retirement through financial investment.
Job Overview
We are looking for a Data Engineer with a strong foundation in MS SQL, ETL processes, and Python programming. The ideal candidate should have a keen interest in working with cloud technologies and server management. As a startup, we value individuals who are eager to learn, adapt to new challenges, and contribute creatively to our data initiatives.
Responsibilities
Data Pipeline Development: Design, develop, and maintain robust ETL processes to ensure efficient data flow from various sources to our data warehouse.
Database Management: Manage and optimize MS SQL databases, ensuring high performance, reliability, and scalability.
Data Integration: Work closely with data scientists, analysts, and other stakeholders to integrate and transform data to meet business needs.
Python Scripting: Write, test, and maintain Python scripts for data processing, automation, and integration tasks.
Cloud \& Server Management: Assist in setting up and maintaining cloud-based data infrastructure and servers (e.g., AWS, Azure, Google Cloud) to support scalable data operations.
Continuous Learning \& Development: Stay up-to-date with the latest industry trends, tools, and technologies. Show a willingness to experiment with and adopt new skills and methodologies.
Problem Solving: Tackle complex data challenges with creativity and a solution-oriented mindset, ensuring our data systems are robust, efficient, and future-proof.
Qualifications
Technical Skills:
Proficiency in MS SQL, including complex queries, performance tuning, and database design.
Strong experience with ETL processes and tools.
Solid programming skills in Python, with experience in data manipulation libraries.
Understanding of cloud platforms (AWS, Azure, Google Cloud) and server management is a plus.
Soft Skills:
Strong problem-solving abilities and analytical mindset.
Excellent communication skills, with the ability to work effectively in a collaborative, fast-paced environment.
Eagerness to learn new technologies and face challenging problems.
Experience:
2+ years of experience in data engineering or a related field.
Previous experience in a startup environment is a plus but not required.
Job Types: Full-time, Fixed term contract
Contract length: 6 months
Pay: $19.00-$25.00 per hour
Benefits:
Casual dress
On-site parking
Paid time off
Ability to commute/relocate:
Richmond Hill, ON L4B 3N2: reliably commute or plan to relocate before starting work (preferred)
Education:
Bachelor's Degree (preferred)
Experience:
Databases: 2 years (preferred)
Python: 2 years (preferred)
SQL: 2 years (preferred)
Work Location: In person