Cloud Data Warehouse Technical Lead

4 days ago


Scarborough, 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 Scarborough, ON


  • Cloud Data Analyst

    2 weeks ago


    Scarborough, Canada Scotiabank Full time

    Requisition ID: 185989 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. **Looking for a hybrid role? We have the job for you! Our employees in hybrid roles can alternate between work from home & onsite in the office with the details to be determined, based on business needs.** **The team**: Global...


  • Scarborough, Canada NTT DATA Services Full time

    Req ID: 281320 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Salesforce Senior Developer - Experience Cloud Why

  • Warehouse Team Lead

    1 week ago


    Scarborough, Canada CanPrev Natural Health Products Full time

    CanPrev is a fast growing natural health products company, and is currently looking for a warehouse team lead to join our team. **Hours of work**: Morning shift - 6:30AM to 2:30PM **What you’ll do**: - Pick and scan products from correct area in the warehouse, based on customer orders - Perform physical / visual inspection of the products - Label...


  • Scarborough, Canada Atlantic Packaging Products Ltd Full time

    **OVERVIEW**: From corrugated packaging, paper bags, retail displays, pre-print, supply and inventory management, paper mills and recycling, Atlantic is strategically positioned to provide customers with a total packaging solution. **THE OPPORTUNITY**: **RESPONSIBILITIES**: - Manage and maintain the Office 365 environment, including Exchange Online,...

  • Lead Generator

    2 weeks ago


    Scarborough, Canada ATS Software Full time

    **Lead Generator** ATS is the industry leader in using technology to revolutionize engineering and design processes. We create tools to help engineers and architects to integrate complex systems quickly and accurately for North America’s most exciting building projects. ATS has a strong work ethic committed to delighting clients and providing them with...


  • Scarborough, Canada Array Marketing Full time

    **About Array Marketing** For over 40 years, Array Marketing has been a global leader in the retail display and in-store merchandising services industry. Global brands like Estée Lauder, Sephora, L’Oreal and Samsung to name a few, rely on our team of more than 2,000 employees around the world, to create great retail experiences by bringing their visions...


  • Scarborough, Canada Array Marketing Full time

    **About Array Marketing** For over 40 years, Array Marketing has been a global leader in the retail display and in-store merchandising services industry. Global brands like Estée Lauder, Sephora, L’Oreal and Samsung to name a few, rely on our team of more than 2,000 employees around the world, to create great retail experiences by bringing their visions...


  • Scarborough, Canada Array Marketing Full time

    **About Array Marketing** For over 40 years, Array Marketing has been a global leader in the retail display and in-store merchandising services industry. Global brands like Estée Lauder, Sephora, L’Oreal and Samsung to name a few, rely on our team of more than 2,000 employees around the world, to create great retail experiences by bringing their visions...

  • Warehouse Team Lead

    2 weeks ago


    Scarborough, Canada Esquivel Employs Excellence Full time

    Warehouse Team Lead/Supervisor needed for a busy Plastic Manufacturing Company. No layoffs in over 20 years. Good management and a stable place to work. Overtime provided. Pay raises and benefits plus free parking. A very successful company at what they do. **Job Types**: Full-time, Permanent **Salary**: $23.00-$25.00 per hour **Benefits**: - Dental...

  • Warehouse Lead

    2 weeks ago


    Scarborough, Canada Star Force HR LTD Full time

    _**Responsible for line accurately packaging, labeling, and coding product. Ensure all special instructions or any order requirements are reviewed and fulfilled. Act as Line Leader to instruct associates as to their duties.**_ **Key Accountabilities**: - Review all special instructions and checklists prior to production. - Understand the expected duties of...

  • Vp of Technology

    2 weeks ago


    Scarborough, Canada Allied Technical Sales Full time

    ATS is the industry leader in using technology to revolutionize engineering and design processes. We create tools to help engineers and architects to integrate complex systems quickly and accurately for North America’s most exciting building projects. ATS has a strong work ethic committed to delighting clients and providing them with exceptional service....

  • Warehouse Team Lead

    1 week ago


    Scarborough Village, Ontario, Canada CanPrev Natural Health Products Full time

    CanPrev is a fast growing natural health products company, and is currently looking for a warehouse team lead to join our team.Hours of work: Morning shift - 6:30AM to 2:30PMWhat you'll do: Pick and scan products from correct area in the warehouse, based on customer orders Perform physical / visual inspection of the products Label warehouse inventory...

  • Data Scientist

    2 weeks ago


    Scarborough, Canada TEKXSYSTEMS INC. Full time

    Education: Bachelor's degree - Experience: 2 years to less than 3 years **Work setting**: - Information technology **Tasks**: - Collect and document user's requirements - Design and develop database - Research, evaluate and synthesize technical information to design, develop and test computer-based systems - Design, construct, modify, implement and test...


  • Scarborough, Canada Elevated Services Inc. Full time

    Are you a motivated, organized, multi-disciplined self-starter looking to make your mark on a young company experiencing tremendous growth? Are you looking for full-time work with a fast-paced energetic team? **Responsibilities**: - Create system to itemize, catalogue, and set up location coding for current stock of parts, material, tools, PPE and...


  • Scarborough, Canada ATS Software Full time

    **Job description**: **Junior Lead Generator** ATS is the industry leader in using technology to revolutionize engineering and design processes. We create tools to help engineers and architects to integrate complex systems quickly and accurately for North America’s most exciting building projects. ATS has a strong work ethic committed to delighting...


  • Scarborough, Canada Royal Bank of Canada Full time

    Job SummaryJob DescriptionWHAT IS THE OPPORTUNITY? Our Storage Technical Analyst provides first level storage and backups Infrastructure support for RBC globally. You will provide the support and management of RBC's Global NAS, SAN, Cloud environment including storage allocation, data replication, m

  • Manager, Data

    3 weeks ago


    Scarborough, Canada Atlantic Packaging Products Ltd Full time

    **OVERVIEW**: From corrugated packaging, paper bags, retail displays, pre-print, supply and inventory management, paper mills and recycling, Atlantic is strategically positioned to provide customers with a total packaging solution. **THE OPPORTUNITY**: The Manager - Data Analytics is an integral team member of Atlantic’s Technical Services Group...

  • Technical Lead

    3 weeks ago


    Scarborough, Canada Scotiabank Full time

    Requisition ID: 200359Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.As Technical Lead, you will be accountable for designing, developing and implementing applications that support Digital Banking business initiatives. You will focus on the Auth

  • Warehouse Clerk

    5 days ago


    Scarborough, Canada Accuenergy (Canada) Inc. Full time

    About Us Accuenergy is a Toronto-based company dedicated to research, design and manufacturing of multifunction power meters and other instruments. We also provide advanced technological solutions for distribution and industrial power system automation. Extraordinary outcomes need exceptional teams. We believe deeply in the power of a growth mindset for...

  • Small Engine Repair

    2 weeks ago


    Scarborough, Canada House of Contractors Full time

    **Job Title**: Small Engine Repair & Warehouse Manager **Location**: 746 Warden Ave, Unit 5, 6 and 7. **Company**: House of Contractors Inc. **Department**: Service Department **Reports To**: Sal **About Us** House of Contractors Inc. is a leading provider of construction equipment and machinery, known for our commitment to quality and customer...