Data Integration Specialist 3

Data Integration Specialist 3

Location: Hybrid - Kamloops or Vancouver, BC, CA

Job Function: Information Technology

BCLC exists to generate win-wins for the greater good.

For our people, our players, our communities, our industry, and our planet.

Lottery | Casino | Sports

Being a social purpose company, we are not only able to better align our business decisions with our purpose, but more importantly, we are committing to doing our part in creating a better world.

We bring our purpose to life by ensuring all our actions, behaviours and decisions create benefits for communities and the planet.

Motivated and guided by our social purpose, everything we do must benefit the greater good. And we encourage our employees, partners, players, industry and communities to engage with us on this ambition.

We want you to be where you feel you can do your best work. Most of our jobs can be done remotely providing you reside in BC.

For those who prefer working in a community with others, we have two beautiful offices in convenient locations:

2940 Virtual Way, Vancouver | 74 Seymour Street W, Kamloops

This is a Temporary > or = 12 Months, Full Time opportunity

Expected Salary Range: $84,981.00 - $106,227.00 - $132,784.00

Our typical hiring range will be +/- 5% of the midpoint shown above

Factors influencing this decision include qualifications and market conditions for the role

The Company

For nearly four decades, BCLC has delivered exceptional gambling entertainment for British Columbians. To fulfill our social purpose we have a vision to revolutionize gambling entertainment through engaging experiences that build and benefit communities. We operate national and provincial lotteries in partnership with 3500 retail partners, provide the games, technology & oversight to 37 brick & mortar casinos, and operate a safe secure and 100% legal online gambling presence PlayNow.com. In our recently completed fiscal year, BCLC generated a record $1.5 billion in net income to the Province of B.C. to support First Nations, host local governments, health care, education and community programs across the province.

The Team

The Data Services team designs, builds and maintains the infrastructure that allows BCLC to collect, store, and analyze large volumes of data. They work on creating data pipelines that transform raw data into a usable format for data scientists and analysts to conduct advanced analytics for BCLC. In essence, data integration specialists lay the groundwork for data-driven decision-making by ensuring that data is accessible, reliable, and ready for analysis.
The team is part of our Business Technology (BT) department, which is the backbone of our organization, managing technology infrastructure, providing technical support, ensuring cybersecurity, and driving innovation. We administer systems, lead tech projects, and manage data to ensure smooth operations and strategic growth. Our mission is to leverage technology to enhance efficiency, protect data, and support the organization's goals.

The Role

As a Data Integration Specialist 3, you will design, development, and maintain BCLC's data integration solutions. Your responsibilities include developing ETL workflows (ensuring data quality), supporting and administering the Enterprise Data Warehouse (EDW) platforms, and collaborating with other Data Integration Specialists, Data analysts and management to meet data requirements. This role requires a thorough understanding of data integration concepts, SQL, strong problem-solving skills, and a willingness to learn, research and grow in a fast-paced environment. This position may also involve being scheduled for paid standby on a rotation outside of business hours, ensuring 24/7 support.

What you will accomplish

• Data Integration: Develop and implement data integration processes to combine data from multiple sources into a unified datasets using data integration toolsets.
• ETL Processes: Create and maintain ETL (Extract, Transform, Load) workflows to ensure data is accurately and efficiently processed.
• Data Quality: Monitor and improve data quality by identifying and resolving data inconsistencies and errors.
• Collaboration: Work closely with Data Integration Specialists, Data analysts and other stakeholders to understand data requirements and deliver effective solutions.
• Documentation: Maintain clear and comprehensive documentation of data integration processes and workflows.
• Learning and Research: Continuously learn and apply new technologies and best practices in data integration management.

What will make you successful

• You have a bachelor's degree in a related discipline.
• You have at least one data related technical certificate, such as Microsoft Azure Data Engineer, Oracle Certified Professional, IBM Certified Administrator, AWS (Amazon Web Services) Big Data Specialty, or other professional certifications.
• You have 3 to 5 years of experience in IT, with at least 2 of those years including experience in Data Integration tools, data lifecycle, pipelines, ingestion, manipulation, security, and quality.
• You have experience in manipulation raw data from source systems, through data warehouses or data lakes, through to usable consumption by business intelligence teams.
• You have an excellent knowledge of SQL.
• You have excellent knowledge in at least one major warehousing database (Exadata, DB2, MS SQL, Snowflake, etc)
• You can write technical documentation, including reports and procedures.
• You have a passion for making things better and improving processes and systems.

It would be awesome if you also had

• You have worked in an agile atmosphere before.
• You understand the B.C. gaming industry.
• You understand advanced data analytics and data modelling.
• You have worked in a cloud-first environment before and understand cloud infrastructure.
• You can effectively communicate complex IT solutions to non-technical people.
• Microsoft office doesn't scare you, you can utilize Word, Excel, Outlook, etc.

What's in it for you

• Defined benefit pension plan which provides a recurring income you can depend on for life throughout retirement
• We pride ourselves on our flexible working model which supports work-life integration and our 37.5 hour work week.
• Professional development including education/certification sponsorship, in house leadership cohorts, LinkedIn Learning
• See all our rewards here

However you identify, or whatever your path in life, if you see something here that makes you excited to get to work every day, please apply. We hire people for skills, capabilities and potential, not just education and experience.

We value Respect, Integrity and Community, and we provide an inclusive environment where everyone can feel like they belong.

Our social purpose is much more than returning 100% of net income to the province in the form of healthcare & education programs, and community gaming grants.

Did you know BCLC is an industry leader in player health & responsible gambling?

If you require accommodation so you can be at your best in the interview, please let us know: recruitment@bclc.com

All candidates must be at least 19 years of age and legally eligible to work in Canada

What's in it for you

• Robust wellness programs to enhance your physical, mental, social, financial and career well being
• We pride ourselves on our flexible working model which supports work-life integration and our 37.5 hour work week
• Our Play It Forward program provides volunteer hours for our people each year
• See all our rewards here

However you identify, or whatever your path in life, if you see something here that makes you excited to get to work every day, please apply. We hire people for skills, capabilities and potential, not just education and experience.

We value Respect, Integrity and Community, and we provide an inclusive environment where everyone can feel like they belong .

Our social purpose is much more than returning 100% of net income to the province in the form of healthcare & education programs, and community gaming grants. Check it out !

Did you know BCLC is an industry leader in player health and safe & responsible gambling? Find out more !

If you require accommodation so you can be at your best in the interview, please let us know: recruitment@bclc.com .

All candidates must be at least 19 years of age and legally eligible to work in Canada