Logo of Huzzle

Home

Matches

Explore

Manage

BI Developer

image

Guidepoint

3mo ago

  • Job
    Full-time
    Senior Level
  • Data
    Software Engineering
  • Toronto

AI generated summary

  • You should have a Bachelor's, 5+ years in BI, expertise in Spark, Python, DBT, SQL, PowerBI/Tableau, data pipelines, Azure Databricks, and compliance, plus strong communication skills.
  • You will gather requirements, build data pipelines, manage Lakehouse architecture, create BI dashboards, and collaborate with teams using SQL, Spark, Python, and Azure Databricks.

Requirements

  • Bachelor’s Degree
  • 5+ years of experience as a BI Developer or similar role
  • Strong understanding of data warehousing concepts and experience working with large volumes of data and implementation of data warehousing projects
  • Proficiency in Spark, Python, and DBT
  • Experience in BI tools such as PowerBI, Tableau, etc.
  • Experience in building and optimizing data pipelines
  • Excellent written and verbal communication skills. Experience working with business stakeholders in converting requirements to solutions
  • Familiarity with compliance-based environments and experience in building compliant software solutions.
  • Advanced working SQL knowledge and experience with relational and NoSQL databases
  • Experience Azure Databricks, Delta Lake
  • Strong understanding of Data Engineering concepts
  • Working knowledge of Fivetran is a bonus

Responsibilities

  • Work closely with business stakeholders in gathering requirements and build solutions to derive insights from data
  • Utilize expertise in data warehousing concepts to work with large volumes of data to perform analysis and provide recommendations to enable data-driven decision-making
  • Build and optimize data pipelines on Azure Databricks, leveraging in-depth knowledge of Data Engineering, Data Warehousing, and Delta Lake on Databricks
  • Manage and maintain data in the Lakehouse medallion architecture
  • Build BI dashboards using tools like PowerBI, Tableau, etc.
  • Utilize advanced SQL Knowledge to work with relational and NoSQL databases, and familiarity with various database systems (e.g., SQL Server, Oracle, Cosmos)
  • Design and implement robust data pipelines to ensure seamless data flow and accessibility
  • Collaborate with cross-functional teams to build and deploy compliant software solutions in a compliance-based environment
  • Exhibit proficiency in Spark, Python, DBT, and SQL to effectively manage and manipulate data

FAQs

What is the job title for this position?

The job title is BI Developer.

Where is this position located?

This position is hybrid in Toronto, Canada.

What are the main responsibilities of a BI Developer at Guidepoint?

The main responsibilities include gathering requirements from business stakeholders, building data solutions, optimizing data pipelines on Azure Databricks, managing data in the Lakehouse medallion architecture, and creating BI dashboards using tools like PowerBI and Tableau.

What qualifications are required for this role?

A Bachelor’s Degree and 5+ years of experience as a BI Developer or in a similar role are required, along with strong understanding of data warehousing concepts and proficiency in Spark, Python, and DBT.

What BI tools should I be familiar with for this position?

Familiarity with BI tools such as PowerBI and Tableau is essential for this position.

What programming languages and technologies are emphasized in this role?

Proficiency in SQL, Spark, Python, and experience with DBT, along with knowledge of Azure Databricks and Delta Lake, are emphasized for this role.

Is experience in compliance-based environments important for this job?

Yes, familiarity with compliance-based environments and experience in building compliant software solutions are important for this job.

Are there additional benefits offered apart from salary?

Yes, the benefits include Paid Time Off, a comprehensive benefits plan, company RRSP match, and development opportunities through the LinkedIn Learning platform.

Is experience with NoSQL databases necessary?

Yes, advanced working SQL knowledge and experience with both relational and NoSQL databases are required.

What type of environment does Guidepoint promote?

Guidepoint promotes an equitable and welcoming environment for its community, valuing diversity and differing perspectives among employees, advisors, and clients.

image

Guidepoint

The Experts at Finding Expertise

Consulting
Industry
1001-5000
Employees
2003
Founded Year

Mission & Purpose

Guidepoint is a research enablement platform designed to advance understanding and empower our clients’ decision-making process. Powered by innovative technology, real-time data, and hard-to-source expertise, we enable our clients to turn answers into action. Backed by a network of nearly 1.5 million experts, and Guidepoint’s 1,300 employees worldwide we inform leading organizations’ research by delivering on-demand intelligence and research on request. With Guidepoint, companies and investors can better navigate the abundance of information available today, making it both more useful and more powerful.