Principal Software Engineer - Platform, Identity and BI

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, Quick Sight, 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, Postgre

SQL) and non‑relational databases (Dynamo

DB, 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 Dev Ops 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.

Eligibility

Candidate must be located in Ontario or British Columbia.

Qualifications

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, Quick Sight, 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, Postgre

SQL, Athena).

Strong full‑stack development capabilities with proficiency in Java, React, JavaScript/Type Script, 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 Git Hub Copilot, Cursor, and Windsurf to accelerate development and improve code quality.

Experience with both relational databases (Redshift, Postgre

SQL, Aurora) and non‑relational databases (Dynamo

DB, Open Search, Document

DB).

Demonstrated ability to design and implement scalable REST APIs, event‑driven architectures (Lambda, Event Bridge, SQS, SNS), and microservices patterns.

Experience with AWS CDK (Cloud Development Kit) or Cloud…