ETL Developer (Python & SQL) – Full-Time, Permanent, Remote (Canada)

ETL Developer (Python & SQL) – Full-Time, Permanent, Remote (Canada)

08 Aug
|
Lys Intelligence
|
Canada

08 Aug

Lys Intelligence

Canada

We are seeking a highly skilled ETL Developer with deep expertise in Python and SQL to join our team.
This is a full-time, permanent remote position focused on designing and implementing robust ETL pipelines and data solutions.

_ Important : The interview process is highly technical and will focus heavily on Python and SQL. You will be required to write actual, working code during the interview — no pseudocode, no AI tools. Use of AI assistance during interviews is strictly prohibited and monitored. If you are not confident in your Python and SQL skills, please do not apply._

Key Responsibilities

- Design, develop, and maintain ETL pipelines using Python.
- Build Python scripts for data extraction, transformation, and loading tasks.
- Write clean, readable, and well-documented code.
- Write complex SQL queries (joins, aggregations, filters, subqueries, etc.).
- Work with various SQL and NoSQL databases (PostgreSQL, MySQL, SQL Server, MongoDB, etc.).
- Deploy applications using Docker (experience with Kubernetes is a plus).
- Work with Linux environments and write shell scripts to automate tasks.
- Use Git for version control and collaborate on shared codebases.
- Collaborate closely with other ETL developers, data architects, and product owners.
- Maintain and continuously improve an existing codebase.
- Engage in research and development to design and test new data pipelines.

Required Skills & Experience

- Python (2+ years) – strong experience working with various data types and data manipulation libraries.
- SQL (2+ years) – ability to write, debug, and optimize complex SQL queries across multiple databases.
- Experience with multiple database systems, including both relational and non-relational.
- Linux/Shell scripting (2+ years)



– able to automate and troubleshoot command-line workflows.
- Git (1+ years) – experience collaborating in version-controlled projects.
- ETL process knowledge – parsing, filtering, transforming, and loading data efficiently.
- Understanding of Docker and basic deployment practices.
- Strong communication and documentation skills.
- Organized, autonomous, and detail-oriented.
- Enjoy exploring and developing recent pipeline architectures and technologies.

Bonus Skills

- Experience with Snowflake or Databricks.
- Familiarity with Kubernetes or other orchestration tools.
- Exposure to data visualization or reporting tools.
- Experience in data quality validation and pipeline monitoring.

Application Questions

To apply, please be aware of:

- Python challenge: Interview questions are live coding exercises that must be solved in real time.
- SQL experience: Candidates will be expected to write SQL statements during the interview to solve real data problems.
- Portfolio: Share a public GitHub or GitLab project that best reflects your Python skills. If your project is private, describe it in detail (tech stack, challenges solved, and key features).

Job Types: Full-time, Permanent

Pay: $57,070.09-$118,520.33 per year

Benefits:

- Dental care
- Disability insurance
- Extended health care
- Life insurance
- Paid time off
- Vision care
- Work from home

Application question(s):

- Important: The interview process is highly technical and will focus heavily on Python, and SQL. You will be expected to demonstrate advanced understanding of these technologies through live coding and scenario-based questions. If you are not confident in your skills in these three areas, please do not apply.
- What is the SIP code for Network Blocked?

Work Location: Remote

📌 ETL Developer (Python & SQL) – Full-Time, Permanent, Remote (Canada)
🏢 Lys Intelligence
📍 Canada

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: etl developer (python & sql) – full-time, permanent, remote (canada) / canada

Subscribe to this job alert:

Get the latest job offers by email for: etl developer (python & sql) – full-time, permanent, remote (canada) / canada