We are seeking an experienced Data Engineer with a strong background in AWS Glue and ETL processes to join our team. The ideal candidate will be proficient in database systems, have hands-on experience with AWS ETL tools, and demonstrate expertise in data integration, transformation, and workflow orchestration.
Responsibilities:
Design, implement, and maintain data pipelines using AWS Glue, Python, PySpark and other AWS services.
Develop and manage ETL workflows to integrate, transform, and load data from various sources.
Optimize and maintain database systems, including PostgreSQL, and other SQL-based databases.
Collaborate with stakeholders to gather requirements and ensure data solutions meet business needs.
Monitor and troubleshoot data pipelines to ensure reliability and accuracy.
Leverage AWS services, including Athena, to build scalable, efficient, and secure data solutions.
Qualifications:
Strong experience with AWS Glue for data integration and transformation.
Hands-on expertise with ETL tools and processes in AWS using Python and PySpark.
Solid understanding of relational database systems, particularly PostgreSQL, and SQL.
Proficiency in writing efficient SQL queries and optimizing database performance.
Practical experience in building and managing ETL pipelines in a cloud environment.
Familiarity with other AWS services related to data processing (e.g., S3, Lambda, Athena, etc.)
Nice-to-Have Skills: Any experience with Terraform for IaC, GitLab CI or Docker.
About Innosphere:
Founded in 1997, Innosphere provides technology staffing solutions to clients across North America. We have specialized in remote work for over 15 years. Our staffing solutions include fully managed development teams coupled with expert consulting, full-time hiring, and flexible staffing.
Innosphere is a permanent remote company but we do have an office location in Guelph to provide employees opportunities to work intermittently in an office environment. We have collaborative space for meetings, lunches, and company events. Our employees have the freedom to choose where they prefer to work.
Innosphere is committed to providing its employees with endless possibilities to learn new things and to work with the latest technologies.
When we hire, we look for people who align with our core values:
Remote First: Innosphere is a remote company but offers in-office workspace. Employee connections are fostered through shared experiences and events.
Community Involvement: Innosphere strives to make a difference in the community through charity initiatives and volunteer opportunities.
Employee Growth: Innosphere provides opportunities to work with new technologies and funds employee training. Our philosophy is to promote internally when possible.
Life as an Innospherian - Who we are and how we work:
Work From Home
Flexible Work Schedule
Team Owned Deliverables
Charity Initiatives
Promote From Within
Some other perks:
Generous Time Off
Above Average Benefits (Dental, Health, Vision, STD, LTD, AD\&D, Life, Dependent Life)
Home Office Benefit Program
Yearly Professional Development Budget
Annual Fitness Benefit
Lunch \& Learns and Virtual Events
Annual In-Person Celebrations
RRSP with Company Match
Volunteer Days
Sports Tickets for Blue Jays games
Birthday Club
Innosphere welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. Only applicants meeting the criteria outlined above will be contacted as part of the shortlisting process. All applicants are subject to a criminal, educational, and employment history background check. Must be currently residing in Canada and legally permitted to work in Canada. No phone calls please.
At Innosphere, we value transparency in our hiring process. Please note that we use Applicant Tracking Systems (ATS) and AI-assisted tools to help manage applications and support our recruitment process. All applications are reviewed fairly, and final hiring decisions are always made by our hiring team.
Job Types: Full-time, Permanent
Pay: $120,000.00-$150,000.00 per year
Benefits:
Dental care
Extended health care
Paid time off
RRSP match
Work Location: Remote