Principle Software Engineer, BI & Data Platform

Calabrio•Toronto, ON

6d•Remote

About The Position

We are seeking a Principal Software Engineer to lead the architecture and development of our next-generation Business Intelligence and data platform. This role requires deep expertise in AWS, data management, full-stack development capabilities, and a proven track record of building enterprise-scale analytics solutions. As a Principal Engineer, you will be a technical leader and strategic advisor, driving architectural decisions that impact millions of users globally. Candidate must be located in Ontario or British Columbia.

Requirements

10+ years of professional experience in software development, with at least 5 years focused on data engineering, business intelligence, or analytics platforms in enterprise SaaS environments.
Deep expertise in AWS data and analytics services including Athena, Redshift, Glue, S3, QuickSight, Lake Formation, with hands-on experience architecting and operating production workloads.
Advanced proficiency in Python for data processing, ETL/ELT development, and backend services, with strong knowledge of frameworks such as FastAPI, Flask, or similar.
Expert-level SQL skills including complex query optimization, window functions, CTEs, and performance tuning across multiple database engines (Redshift, PostgreSQL, Athena).
Strong full-stack development capabilities with proficiency in React, JavaScript/TypeScript, and modern front-end frameworks for building analytics dashboards and data visualization interfaces.
Proven experience with Apache Iceberg, Parquet, or similar columnar formats and modern data lake architectures.
Deep understanding of data modeling techniques for both OLTP and OLAP workloads, including dimensional modeling, star/snowflake schemas, and denormalization strategies.
Strong, in-depth experience with AI coding assistants such as GitHub Copilot, Cursor, and Windsurf to accelerate development and improve code quality.
Experience with both relational databases (Redshift, PostgreSQL, Aurora) and non-relational databases (DynamoDB, OpenSearch, DocumentDB).
Demonstrated ability to design and implement scalable REST APIs, event-driven architectures (Lamda, EventBridge, SQS, SNS), and microservices patterns.
Experience with AWS CDK (Cloud Development Kit) or CloudFormation/Terraform for infrastructure-as-code and automated deployment pipelines.
Strong background in data pipeline orchestration using AWS Step Functions, Glue workflows, or similar tools.
Proven track record of leading technical initiatives, mentoring senior engineers, and driving architectural decisions in complex distributed systems.
Experience with CI/CD pipelines, automated testing frameworks (pytest, Playwright), and DevOps practices for data platforms.
Excellent problem-solving skills with the ability to troubleshoot complex issues in large-scale, distributed data systems.
Strong understanding of software development lifecycle (SDLC), Agile methodology, and experience leading technical teams through the full development lifecycle.
Outstanding communication skills with the ability to articulate complex technical concepts to both technical and non-technical stakeholders.
Adaptable with the ability to switch technical stacks and domains to respond to changing customer and business needs while maintaining strategic focus.

Nice To Haves

Experience with QuickSight embedding, dashboard development, and custom analytics solutions.
Knowledge of data governance, security, and compliance requirements (GDPR, SOC2, etc.) in multi-tenant SaaS environments.
Familiarity with machine learning workflows and integration of ML models into data pipelines.
Experience with real-time streaming data processing using Kinesis, Kafka, or similar technologies.
Contributions to open-source projects or technical thought leadership (blog posts, conference talks, patents).
Experience with multi-cloud or hybrid cloud architectures.

Responsibilities

Architect and develop large-scale, mission-critical BI and data platform solutions serving millions of users across the globe, leveraging AWS native technologies including Athena, Redshift, Glue, QuickSight, and S3.
Lead the design and implementation of robust data pipelines, data lakes, and data warehouses using modern architectures (Iceberg, Parquet, columnar formats) to support real-time and batch analytics at scale.
Drive technical strategy and architectural decisions for the BI platform, including data modeling, query optimization, performance tuning, and cost optimization across AWS services.
Build and maintain sophisticated back-end services, ETL/ELT workflows, and front-end analytics applications using Python, SQL, React, and modern web technologies.
Design and implement efficient data storage solutions across relational databases (Redshift, PostgreSQL) and non-relational databases (DynamoDB, S3), ensuring optimal performance and cost-efficiency.
Develop and maintain REST APIs and event-driven architectures to enable seamless integration between data services, analytics tools, and customer-facing applications.
Serve as the technical lead and mentor for engineering teams, conducting architecture reviews, code reviews, and providing guidance on complex technical challenges.
Collaborate with cross-functional teams including data engineers, analytics engineers, product managers, and DevOps to deliver innovative BI solutions that drive business value.
Champion engineering excellence by establishing best practices, design patterns, and coding standards for data-intensive applications.
Lead Agile ceremonies, drive sprint planning, and ensure timely delivery of high-quality software solutions while maintaining technical debt at manageable levels.
Evaluate and integrate emerging AWS services and open-source technologies to continuously improve platform capabilities and developer productivity.
Troubleshoot and resolve complex performance issues in distributed data systems, optimizing query performance, data processing workflows, and infrastructure costs.
Participate in strategic planning and roadmap development, translating business requirements into scalable technical solutions.
Contribute to the team on-call rotation, providing expert-level support for production environments and mentoring team members on incident response.