Cloud Data Warehouse Technical Lead

Welcome to Pinnacle, the ultimate destination for sports enthusiasts seeking an exhilarating sportsbook and gaming experience! Established in 1998, we have solidified our position as one of the globe's foremost licensed online gaming companies. With our cutting-edge offerings, we guarantee an electrifying experience that will keep you on the edge of your seat.

Pinnacle invites you to join our team and become an instrumental figure in the exciting realm of sports betting. Our vibrant team is fueled by passion and driven by innovation, working together to redefine the landscape of sports betting and gaming. Together, we constantly strive to surpass limitations and deliver unparalleled experiences to sports enthusiasts worldwide. Prepare yourself for a thrilling journey and discover sports in an entirely new dimension with Pinnacle!

To support our continued growth, we are currently looking for a Cloud Data Warehouse Technical Lead.

Job Purpose:

The Cloud Data Warehouse Technical Lead is responsible for planning, building, and maintaining the future Data warehouse architecture. Working with teams of internal and external data engineers and architects, this role will be instrumental in modernizing our current and future reporting data infrastructure, including Data Warehouses, data lakes and data marts. This role will be responsible for leading and contributing to the architecture and development of data ingestion processes, performance, administration, and design of database structures.

Essential Job Functions / Main Duties & Responsibilities:

• Assist in the delivery of cloud-based Data Warehouse, lake, and mart solutions
• Understand data landscape i.e. tooling, tech stack, source systems etc. and work closely with technology teams to improve data collection, quality, reporting and analytics capabilities
• Design, document, and implement Data Warehouse strategies, including building ETL, ELT, and Data Pipeline processes
• Develop processes for loading and transforming of large volumes of structured and semi structured data
• Responsible for data architecture, data modeling, performance and cost optimization of the new Cloud Data Warehouse solution
• Participate in Data Warehouse development by defining metadata and security standards
• Mentor less experienced team members

Skills & Qualifications:

• Excellent communication skills both verbally and written
• Strong analytical, conceptual, and problem-solving abilities with attention to detail
• Ability to break down complex problems and projects into manageable goals
• Highest personal and professional integrity and strong work ethics
• Excellent organizational skills

Knowledge & Experience (mandatory):

• 3+ years of Cloud experience with GCP
• 8+ years of experience in Data Warehouse, data modeling, ETL, BI projects
• 3+ years hands-on experience with Big Query Data warehousing
• 3+ years hands-on experience in development using ETL tools such as DBT, Data Form, Dataflow, Data Fusion, SSIS, Talend, etc.

Knowledge & Experience (optional, but desired):

• 5+ years of experience with SQL
• 5+ years of experience with CI/CD
• 3+ years of experience leading technical team of data engineers and architects
• Completed cloud warehouse projects in at least 2 of AWS, Azure, GCP cloud technologies
• Ability to work and communicate with both business and technical experts
• College or University degree in Computer Science, Mathematics, Data Science and/or relevant degree
• Familiar with infrastructure as code

What we offer:

• A lean, performance-oriented environment with a strong sense of team, collaboration, and imagination
• Corporate Bonus Plan pending on company’s profit and individual performance
• Social activities organized by the company
• Reimbursement of monthly gym membership upon receipt

Job Type: Full-time

Benefits:

• Casual dress
• Company events
• Dental care
• Discounted or free food
• Employee assistance program
• Extended health care
• Life insurance
• On-site parking
• Vision care
• Wellness program
• Work from home

Schedule:

• Monday to Friday

Work Location: Hybrid remote in Toronto, ON M2N 6K1