Software Developer L2 - Data and AI
About The Position
Hammond Power Solutions Inc. is a global manufacturer headquartered in Guelph, Ontario, Canada. HPS has grown to become the leader in North America in the custom design and manufacture of dry type transformers. For the past century, HPS has grown to deliver electrical power solutions to global markets and provides solutions for complex applications like, mining, rectifier, drives, traction, wind, solar and many other electrical power applications. The world relies on HPS to continually conceive and produce state-of-the-art transformer technology. We currently have an opening for a Software Developer, Data and AI – 12 month contract, come grow with us! Reporting to the Manager, Software Development, this role designs, develops and maintains enterprise data solutions that support business operations and strategic decision-making, including data solution architecture, integration and transformation. The incumbent also contributes to AI project lifecycle activities --- data preparation, model implementation, deployment, and ongoing support --- while building scalable, cloud-ready software applications. Working closely with business stakeholders across departments, this role gathers requirements, implements and delivers data and AI-driven solutions, and ensures effective knowledge transfer through user training and support.
Requirements
- Bachelor’s degree in Computer Science, Data Science, Artificial Intelligence, or related field, or equivalent professional experience.
- 2+ years’ professional experience in SQL and ETL design, with solid understanding dimensional modelling and data warehousing concepts, ensuring efficient storage, retrieval and analysis of large datasets.
- Experience with AI/ML technologies including: LLM, Prompt Engineering, Vector Databases, AI Agents, Agentic AI, AI-powered coding, and MCP.
- Prior experience in Azure Technologies such as Data Fabric, Synapse, ADFS, App Service, CI/CD pipeline and Power BI.
- AI-powered programming experience with Python, C or C#.
- Strong problem-solving skills and a passion for software development.
- Excellent communication and teamwork abilities.
Responsibilities
- Design end-to-end data solutions (data models, data warehouse, data marts, semantic layers and OLAP cubes) to support analytics, reporting and AI use cases.
- Implement modernization and cloud migration for legacy warehouses and pipelines
- Ensure data quality, lineage and observability across pipelines and models;
- Design and deliver BI dashboards, self-service reports.
- Document architecture, data flows and data definitions to support maintainability
- Collaborate on AI/ML project design; translate business problems into data and modeling requirements.
- Prepare datasets: cleaning, enrichment and feature engineering
- Assist with model integration, deployment, monitoring and retraining procedures
- Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications.
- Efficiently leverage AI-powered coding assistants to develop and deliver high-quality software solutions.
- Create and maintain efficient, scalable, and secure code.
- Participate in code reviews and contribute to continuous improvement.
- Streamline business processes by creating seamless data flows.
- Troubleshoot and resolve issues related to existing data systems and software applications.
Benefits
- market‑competitive compensation that reflects performance, skills, and current market conditions
- comprehensive benefits package
- eligible for performance‑based incentives
- Great Place to Work Certified!
- equitable pay, benefits, and practices prioritize security, health, and well-being
- variable pay programs
- Employee Stock Ownership Program
- core benefits focus on wellness, mental health, and financial security
- support work-life balance through flexible work schedules, paid time off, and leaves of absence.
- confidential, best-in-class Employee and Family Assistance Program (EFAP).
- committed to sustainable business practices
- opportunities for our employees to support the communities where we live and work through our Hammond Giving Strategy.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
