Cloud Data Warehouse Technical Lead

3 days ago


Mississauga, Canada Pinnacle Full time

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

**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 Mississauga, ON



  • Mississauga, Canada The Chefs' Warehouse Full time

    **Mission**: The mission of The Chefs’ Warehouse is to provide the world’s greatest ingredients to the world’s best chefs. **Our C.H.E.F.S. Values**: Curious & Creative Hungry For Food & Results Entrepreneurial Forward Thinking & Flexible Supportive (Of Peers & Chefs) Lead and positively coach warehouse team members to safely, accurately and...


  • Mississauga, Canada Cloud SynApps Inc. Full time

    Salesforce Technical Architect | What You Will DoTechnical Architect is a Senior Consulting role at Cloud SynApps Inc. who is responsible for leading the Salesforce engagements as a senior technology leader and responsible for:Connect with clients to become a trusted technical advisor.Self-starter, self-confident, self-motivated, enthusiastic, and have an...


  • Mississauga, Canada Cloud SynApps Inc. Full time

    Salesforce Technical Architect | What You Will DoTechnical Architect is a Senior Consulting role at Cloud SynApps Inc. who is responsible for leading the Salesforce engagements as a senior technology leader and responsible for:Connect with clients to become a trusted technical advisor.Self-starter, self-confident, self-motivated, enthusiastic, and have an...

  • Data Scientist

    3 weeks ago


    Mississauga, Canada Open Cloud Consultancy Full time

    Work Term: Permanent - Work Language: English - Hours: 37.5 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years - or equivalent experience **Work setting**: - Consulting firm **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test...


  • Mississauga, Ontario, Canada Synechron Full time

    Role: Cloud Data engineer /Python DeveloperLocation: Mississauga, ONType: Full-time with HybridExperience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst...


  • Mississauga, Ontario, Canada Synechron Full time

    Role: Cloud Data engineer / Python DeveloperLocation: Mississauga, ONType: Full-time with HybridExperience: 6+ YearsThis role is for a Cloud Data engineer well-versed in Python, Pyspark, SQL, and data warehousing for high-level systems. Seeking an individual comfortable collaborating with business users and holding business analyst skills.Major...


  • Mississauga, Canada Citigroup Full time

    Security Services industry is constantly changing, requiring Citi to react and plan accordingly. An analysis has been undertaken to identify a strategic vision in response to a changing landscape. The business recognizes that investment in technology is critical to fulfilling evolving client needs. To that extent, a 5-year transformational strategy is...


  • Mississauga, Canada Citigroup Full time

    Security Services industry is constantly changing, requiring Citi to react and plan accordingly. An analysis has been undertaken to identify a strategic vision in response to a changing landscape. The business recognizes that investment in technology is critical to fulfilling evolving client needs. To that extent, a 5-year transformational strategy is...


  • Mississauga, Canada ISTITUTO MARANGONI Full time

    Security Services industry is constantly changing, requiring Citi to react and plan accordingly. An analysis has been undertaken to identify a strategic vision in response to a changing landscape. The business recognizes that investment in technology is critical to fulfilling evolving client needs. To that extent, a 5-year transformational strategy is...


  • Mississauga, Canada ISTITUTO MARANGONI Full time

    Security Services industry is constantly changing, requiring Citi to react and plan accordingly. An analysis has been undertaken to identify a strategic vision in response to a changing landscape. The business recognizes that investment in technology is critical to fulfilling evolving client needs. To that extent, a 5-year transformational strategy is...


  • Mississauga, Ontario, Canada ISTITUTO MARANGONI Full time

    Security Services industry is constantly changing, requiring Citi to react and plan accordingly. An analysis has been undertaken to identify a strategic vision in response to a changing landscape. The business recognizes that investment in technology is critical to fulfilling evolving client needs. To that extent, a 5-year transformational strategy is...


  • Mississauga, Canada Synechron Full time

    Role: Cloud Data engineer /Python Developer Location: Mississauga, ON Type: Full-time with Hybrid. Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with...


  • Mississauga, Canada Synechron Full time

    Role: Cloud Data engineer /Python DeveloperLocation: Mississauga, ONType: Full-time with Hybrid.Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst...


  • Mississauga, Canada Synechron Full time

    Role: Cloud Data engineer /Python DeveloperLocation: Mississauga, ONType: Full-time with Hybrid.Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst...


  • Mississauga, Canada Synechron Full time

    Role: Cloud Data engineer /Python DeveloperLocation: Mississauga, ONType: Full-time with Hybrid.Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst...


  • Mississauga, Canada Synechron Full time

    Role: Cloud Data engineer /Python DeveloperLocation: Mississauga, ONType: Full-time with Hybrid.Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst...


  • Mississauga, Canada Synechron Full time

    Role: Cloud Data engineer /Python Developer Location: Mississauga, ON Type: Full-time with Hybrid. Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with...


  • Mississauga, Canada Synechron Full time

    Role: Cloud Data engineer /Python DeveloperLocation: Mississauga, ONType: Full-time with Hybrid.Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst...


  • Mississauga, ON, Canada Synechron Full time

    Role: Cloud Data engineer /Python DeveloperLocation: Mississauga, ONType: Full-time with Hybrid.Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst...


  • Mississauga, ON, Canada Synechron Full time

    Role: Cloud Data engineer /Python DeveloperLocation: Mississauga, ONType: Full-time with Hybrid.Experience: 6+ Years This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst...