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.*
What you'll be doing:- 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.
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.
•
Preferred Qualifications: - 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.
BenefitsBenefits:
You've learned about what you'll be doing, here are some of the benefits you'll be getting when you join Calabrio:
- Global team recognized for their passion and innovation
- Innovative product culture and project exposure
- Training and development from industry-leading experts
- Cutting edge benefit programs that include: 401(k) with company matching; medical, dental, and vision insurance; disability and life insurance; flexible PTO; paid holidays and parental leave; tuition reimbursement and more
- We offer market competitive pay and benefits based upon the candidate's skills, experience, and qualifications. Starting rate of pay for this salaried position is targeted at $120,000.
Calabrio People are: Open, Clear, Ambitious, Accountable, Collaborative, Consistent
Ready for Exponential Career Opportunities? Apply now
