Data Platform & Analytics Capability Lead building, positioning, and scaling Avanade’s enterprise data and analytics capability in Canada. Shaping client solutions, opportunities, partnerships, and delivery standards.
About the role
- Principal Software Engineer leading architecture and development of BI solutions for Verint. Collaborating with global teams to reshape customer experiences with advanced data insights.
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.
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.
Benefits
- 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.
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Senior Data Engineer scaling blockchain, product analytics, and experimentation infrastructure for Phantom’s global open - markets trading app. Driving data quality and architecture across a remote team.
Data engineering intern supporting ETL, data quality, and transformation projects at Canadian asset manager PICTON Investments. Collaborating across business teams using SQL, Python, databases, and cloud platforms.
Data engineering student building Azure, SQL, Python, and Power BI solutions for CMHA Peel Dufferin’s mental health services. Supporting reporting, ETL pipelines, dashboards, automation, and data - driven decisions.
Senior Product Architect guiding AWS, SaaS, data and financial technology at FCC, a Canadian agriculture lender. Shaping secure enterprise roadmaps and integrations across financial applications.
Data Engineer designing warehouse models, Python pipelines, and Power BI reporting for Silk & Snow’s sleep products. Transforming raw data into actionable business insights.
Senior Data Engineer building SQL, dbt, and Airflow data pipelines for Penn Interactive’s online gaming and sports platforms. Delivering trusted analytics and recommendations to business stakeholders.
Data Architect governing World Vision Canada's nonprofit enterprise data architecture. Defining cloud data standards, governance, security and reusable platforms remotely within Canada.
Senior software engineer building backend data services, APIs, microservices, and pipelines for Akamai’s distributed cloud platform. Optimizing databases and reliability across high - scale workloads.
Principal Data Architect defining scalable, governed data platforms for Robots & Pencils’ enterprise AI systems. Setting architecture direction, supporting clients, and mentoring senior technical teams.