Software Applications Engineer III

Brightstar Lottery; 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 its enterprise data platform using Snowflake. The role includes designing scalable data models, developing SQL queries, and ensuring data accessibility. Candidates should possess over 5 years of experience, strong SQL skills, and expertise in Snowflake, along with knowledge of data governance practices. This position is pivotal in supporting advanced analytics and AI-driven use cases while adhering to industry standards.

Qualifications

• 5+ years of experience in data engineering, database design, or data platform development.
• Strong expertise in Snowflake and performance tuning.
• Proficiency in SQL with experience writing complex queries.

Responsibilities

• Design and implement robust, scalable Snowflake database schemas.
• Develop and optimize SQL for data transformation.
• Integrate data from diverse sources including APIs and databases.

Skills

Data engineering

SQL proficiency

Snowflake expertise

ETL/ELT frameworks

Python programming

Data governance knowledge

Tools

Snowflake

Airflow

Tableau

AWS

Job description

Location: Moncton, CA, E1H 2R6

Requisition ID: 18864

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.