Software Applications Engineer III

IGT; City of Moncton; On-site; CAD 85,000 - 110,000; Full time

Job summary

A leading global lottery company is seeking a skilled Data Platform Engineer to architect and optimize their enterprise data platform. The role will focus on Snowflake, requiring robust database schema design and data integration skills. The ideal candidate will have over 5 years of data engineering experience, proficiency in SQL, and programming skills in Python or Java. The position offers an opportunity to work with advanced analytics in a diverse and inclusive environment.

Qualifications

• 5+ years of experience in data engineering, database design, or data platform development.
• Strong expertise in Snowflake, including schema design and performance tuning.
• Proficiency in SQL with experience writing complex queries.
• Experience with data integration from various sources such as APIs and flat files.
• Understanding of ETL/ELT frameworks and orchestration tools.
• Solid programming skills in Python or Java.

Responsibilities

• Design and implement robust, scalable, and performant Snowflake database schemas.
• Define and maintain semantic layers for self-service analytics.
• Develop and optimize SQL for data transformation.
• Integrate data from diverse sources including relational databases.
• Monitor and tune performance of data pipelines.

Skills

Data engineering

Database design

Data platform development

Snowflake

SQL

Data integration

Python

Java

Tools

Snowflake

dbt

Airflow

AWS

Azure

GCP

Tableau

Power BI

Job description

Brightstar is an innovative, forward-thinking global leader in lottery that builds on our renowned expertise in delivering secure technology and producing reliable, comprehensive solutions for our customers. As a premier pure play global lottery company, our best-in-class lottery operations, retail and digital solutions, and award-winning lottery games enable our customers to achieve their goals, fulfill player needs and distribute meaningful benefits to communities. Brightstar has a well-established local presence and is a trusted partner to governments and regulators around the world, creating value by adhering to the highest standards of service, integrity, and responsibility. Brightstar has approximately 6,000 employees. For more information, please visit www.brightstarlottery.com.

Overview

We are seeking a highly skilled Data Platform Engineer to join our team and help architect, build, and optimize our enterprise data platform. This role will focus on Snowflake as the core data warehouse technology and will be instrumental in designing scalable data models, defining semantic layers, and enabling advanced analytics and AI-driven use cases.

Responsibilities

• Design and implement robust, scalable, and performant Snowflake database schemas and data models.
• Define and maintain semantic layers to support self-service analytics and machine learning workflows.
• Develop and optimize SQL for data transformation, aggregation, and consumption.
• Integrate data from diverse sources including relational databases, interface files, message queues, and APIs.
• Collaborate with data scientists, analysts, and application developers to ensure data accessibility and usability.
• Implement and maintain data governance, security, and RBAC policies within Snowflake.
• Monitor and tune performance of data pipelines and warehouse queries.
• Contribute to the development of data platform standards, best practices, and documentation.

Qualifications

• 5+ years of experience in data engineering, database design, or data platform development.
• Strong expertise in Snowflake, including schema design, performance tuning, and data sharing.
• Proficiency in SQL, with experience writing complex queries and stored procedures.
• Experience with data integration from varied sources (e.g., APIs, flat files, message queues).
• Familiarity with ETL/ELT frameworks and orchestration tools (e.g., dbt, Airflow).
• Understanding of semantic modeling and analytics enablement.
• Solid programming skills in Python or Java for data processing and automation.
• Knowledge of data governance, security, and access control principles.

Preferred Knowledge & Tools

• Experience with AI/ML workflows and enabling data access for model training and inference.
• Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and cloud-native data services.
• Exposure to BI tools (e.g., Tableau, Power BI) and how they interact with semantic layers.
• Experience with CI/CD and DevOps practices in data engineering.

Success Profile

• Leading Complexity
• Leading People
• Leading the Business
• Leading Self

Brightstar is committed to sustaining a workforce that reflects the diversity of the global customers and communities we serve, and to creating a fair and inclusive culture that enables all our employees to feel valued, respected and engaged. Brightstar is an equal opportunity employer. We provide equal opportunities without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, pregnancy, marital status, national origin, citizenship, covered veteran status, ancestry, age, physical or mental disability, medical condition, genetic information, or any other legally protected status in accordance with applicable local, state, federal laws or other laws. We thank all applicants for applying; however, only those selected to interview will be contacted.

All Brightstar employees have a role in information security. Annual training will be assigned and required as appropriate.

For more information, please visit www.brightstarlottery.com.