We’re looking for a Data Engineer to join our Corporate Applications & Development team within our Winnipeg or remote in Canada. 

Data Engineer is responsible for designing, developing, testing, deploying, and supporting data integration, data engineering, transformation, reporting, and analytics solutions that enable effective business decision-making and operational efficiency. The role works across the full data lifecycle, including source-system integration, batch and near-realtime data ingestion, transformation, data modelling, data quality, reporting, visualization, and production support. The position develops data pipelines, reusable dbt transformations, curated data products, dashboards, reports, and visualizations using technologies including SQL, Python, dbt, AWS Glue, Apache Spark, Apache Flink, and Amazon QuickSight.

Working within a collaborative development environment, the Application Developer, Analytics translates business and technical requirements into reliable, governed, maintainable, and reusable solutions. The position applies software engineering practices including source control, peer review, automated testing, CI/CD, monitoring, documentation, and structured deployment processes.

This reflects the current platform direction in which AWS Glue provides batch and Spark-based processing, dbt defines transformation models, Flink supports near-real-time CDC ingestion, and QuickSight provides reporting and analytics capabilities

Who We Are

Experience the forefront of innovation with Pollard Digital Solutions a division of Pollard Banknote, where we lead the charge in revolutionizing digital solutions for state lotteries. From groundbreaking initiatives like iLottery to crafting immersive player experiences that champion noble causes globally, our team's innovative spirit is driving impactful changes in the industry. Join us in this exhilarating journey, where every contribution makes a difference in shaping the future of lottery gaming.

What We Offer

• Competitive compensation
• Profit sharing program – every role plays a part in our success!
• Company pension
• Comprehensive Group Benefits
• Opportunities for professional development
• Tuition reimbursement
• Employee & Family Assistance Program
• A variety of committee driven employee engagement activities
• On-Site Cafeteria & Outdoor Patio
• On Site Gym
• Free Parking
• Remote/Hybrid Work Environment

What You'll Do

• Data Pipeline and Integration Development:
  - Design, develop, test, deploy, and maintain batch and near-real-time data pipelines.
  - Develop data integration solutions using SQL, Python, AWS Glue, ApacheSpark, Apache Flink, and related technologies.
  - Implement full-load, incremental-load, change data capture, file-based, database, and API-based integration patterns
  
• Data Transformation and Modelling:
  - Develop data models and transformation logic across Bronze, Silver, and Gold data layers.
  - Implement standardization, cleansing, conformance, business rules, calculations, aggregations, and data-product creation.
• Analytics, Reporting and Visualization:
  - Design, develop, test, deploy, and maintain dashboards, reports, datasets, analyses, and visualizations using Amazon QuickSight and other approved enterprise analytics tools.
  - Translate business questions and performance measures into clear, accurate, and effective dashboards and reports.
• Data Quality and Governance:
  - Implement automated data-quality tests, validation rules, reconciliation 10% processes, and control totals.
  - Support schema discovery, schema validation, and controlled schema evolution.
• Platform Support, Troubleshooting and Optimization:
  - Monitor and support production data pipelines, dbt transformations, Glue jobs, Flink applications, databases, datasets, reports, dashboards, and
  related services.
  - Investigate failed, delayed, incomplete, or inaccurate data-processing workloads.
  Software Development and Delivery Practices:
  - Develop and maintain data-platform and analytics code using Git-based source control.
  - Develop automated tests and validation.
• Requirements Analysis and Stakeholder Collaboration:
  - Collaborate with business users, analysts, application teams, architects, DevOps, database administrators, security teams, and other technical
  stakeholders.
  - Translate requirements into solution designs, data models, pipelines, transformations, datasets, dashboards, and reports.

What You'll Bring

• Experience developing and supporting production data integration, data engineering, reporting, or analytics solutions.
• Experience developing complex SQL for data extraction, transformation, modelling, validation, reconciliation, and performance analysis.
• Experience using Python for data processing, automation, integration, or analytics.
• Experience developing and maintaining data transformations using dbt or a comparable transformation framework.
• Experience developing ETL or ELT pipelines using batch, incremental, or change data capture patterns.
• Experience with relational databases and structured data, preferably including PostgreSQL.
• Experience designing source-to-target mappings and data models.
• Experience developing dashboards, reports, datasets, and visualizations using Amazon
• QuickSight, Power BI, or a comparable enterprise analytics platform.
• Experience applying data-quality validation, testing, reconciliation, and troubleshooting techniques.
• Experience using Git-based source control and collaborative development practices.
• Experience supporting production solutions, including monitoring, incident investigation, rootcause analysis, and recovery.

Pollard Banknote Limited is an equal opportunity employer, committed to promoting and maintaining a diverse and inclusive workforce. Reasonable accommodations are available upon request.

Employment is contingent upon a satisfactory response from a Criminal Record Search.