At a Glance
- Tasks: Design and develop data pipelines using Python and AWS services.
- Company: Join a dynamic team in a hybrid work environment.
- Benefits: Enjoy competitive salary, health benefits, and flexible work arrangements.
- Other info: Great opportunity for career advancement in a collaborative setting.
- Why this job: Make an impact with innovative tech solutions while growing your skills.
- Qualifications: Experience in Python, AWS, and data engineering required.
The predicted salary is between 90000 - 110000 $ per year.
About the job
This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be at the Hiring Manager's discretion.
Extension/Amendment Attestation: The Statement(s) of Work (SOW) shall expire on March 31, 2026. HSC may exercise its option(s) to extend the SOW beyond March 31, 2026 using unused days/funds left on contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.
Responsibilities:
- Design, develop, test and implement:
- data pipelines using Python and AWS services (Glue, StepFunctions, Lambda)
- complex data transformation procedures
- data models for the efficient storing of data in relational databases as well as in unstructured data repositories
- re‑useable classes and modules to enhance maintainability and ability to deliver solutions quickly.
- Review existing code base and assist other more junior team members ensuring a consistent level of quality.
- Assess new business requirements and propose adequate technical solutions (using on-prem and on-cloud resources).
- Monitor automatic execution of the various data loads and proactively address issues such as data processing errors or performance degradations.
Skills Experience and Skill Set Requirements:
- General Development Experience (Python)
- Working with XLSX, CSV, JSON files, relational databases, structured and unstructured data, Data engineering and processes automation
- Experience using AWS Services such as Glue, StepFunctions, Lambda, S3 or equivalent
- Experience with cloud data warehousing and analytics (AWS Redshift or equivalent)
- Data modeling (relational & dimensional), advanced SQL
- Full SDLC from requirements gathering, design, implementation, testing to deployment and production support
- Familiar with project management (agile/scrum and waterfall)
- Change and Incident management
- Communication, presentation and negotiation skills
- Consulting, problem-solving and decision‑making skills
- Public sector experience
MUST HAVES:
- General Development Experience (Python) - Server‑side scripting
- Working with XLSX, CSV, JSON files, relational databases, structured and unstructured data
- Data engineering and processes automation
- AWS Cloud Experience - Experience with cloud data warehousing and analytics (AWS Redshift or equivalent)
- Experience using AWS Services such as Glue, StepFunctions, Lambda, S3 or equivalent
- Extract/Transform/Load data (ideally Informatica experience on Cloud)
Senior Software Developer in Toronto employer: Rubicon Path
As a Systems Testing/QA Specialist at our Toronto location, you will thrive in a collaborative and innovative work culture that prioritizes quality and continuous improvement. We offer competitive benefits, opportunities for professional growth, and a commitment to work-life balance, ensuring that you can excel in your role while contributing to meaningful projects that impact the community. Join us to be part of a dynamic team dedicated to delivering high-quality solutions in a supportive environment.
