Senior Integrations Developer / AI Data Integration Engineer

Engineered Intelligence Inc. • Mississauga, ON

5d • Hybrid

About The Position

Engineered Intelligence Inc. is seeking an experienced Senior Integrations Developer / AI Data Integration Engineer to help lead the evolution of its modern data integration platform. This role merges traditional ETL and data engineering expertise with emerging AI-assisted integration development practices. The successful candidate will be responsible for building scalable data ingestion and transformation pipelines and contributing to the development of a next-generation AI-assisted ETL framework utilizing agents, metadata, reusable skills, and workflow orchestration to automate the integration lifecycle. The ideal candidate will be adept at reverse-engineering complex client systems, designing robust transformation logic, working with data models and business rules, and leveraging AI development tools. This is a foundational role that will significantly shape future integration standards, tooling, and architecture within the organization.

Requirements

• 5+ years of experience in ETL development, data integration, data engineering, or related roles
• Strong hands-on experience with Python and SQL for data transformation and pipeline development
• Experience working with modern cloud-based data processing and orchestration environments
• Strong understanding of relational data modeling, dimensional modeling, CDC concepts, ODS/data marts, and data warehousing principles
• Experience developing transformation rules, reconciliation logic, mapping logic, and data validation frameworks
• Strong understanding of data profiling, pattern recognition, natural keys vs surrogate keys, and reference/lookup data management
• Experience working with APIs, flat files, databases, and event-driven integration patterns
• Comfortable using AI-assisted development tools to generate, review, and refine technical artifacts and code
• Understanding of modern AI terminology and concepts such as agents, agentic workflows, metadata-driven processing, reusable skills, hooks, and orchestration patterns
• Familiarity with AWS cloud services and distributed data processing concepts
• Strong analytical, troubleshooting, and system discovery skills
• Excellent communication, documentation, and stakeholder collaboration abilities
• Ability to work independently in a fast-paced and evolving technical environment
• Must be able to regularly work in Calgary or Toronto

Nice To Haves

• Experience with PySpark, Apache Spark, EMR, Databricks, or distributed processing frameworks
• Experience with orchestration and workflow tools
• Experience with event-driven architectures and messaging platforms
• Familiarity with DevOps and CI/CD practices for data pipelines
• Exposure to AI/LLM-assisted software development workflows
• Experience mentoring developers or helping establish technical standards and best practices
• Experience working within utility, critical infrastructure, or industrial analytics environments

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines for onboarding external client data into the ENGIN analytics platform
• Analyze and reverse-engineer client systems, source data structures, and business processes to define integration approaches
• Develop transformation logic, mapping rules, reconciliation processes, and validation workflows for complex utility and enterprise datasets
• Contribute to the design and implementation of AI-assisted and metadata-driven integration development frameworks
• Work with agentic workflows, reusable AI skills, metadata models, and automation pipelines to accelerate integration development
• Develop integration logic using Python, PySpark, SQL, and cloud-native data processing frameworks
• Support deployment and orchestration of ETL workloads within AWS-based infrastructure environments
• Implement data quality, validation, monitoring, reconciliation, and error-handling processes across integration workflows
• Collaborate with product, delivery, customer, and engineering teams to define data contracts, transformation requirements, and integration standards
• Document integration logic, business rules, workflows, and architectural decisions
• Participate in architectural planning and contribute to long-term modernization of the company’s integration ecosystem
• Assist with project estimation, implementation planning, technical discovery, and stakeholder communication

Benefits

• Competitive compensation and benefits
• Flexible Hours – Work around a core schedule (10:00 AM – 3:00 PM) while maintaining a work-life balance that suits you.
• Autonomy & Growth – Take ownership of diverse responsibilities, explore cross-disciplinary opportunities, and advance your career in a dynamic, fast-growing company.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed