Data Engineer

Overview of the role:

Guidepoint seeks an experienced Data Engineer as an integral member of the Toronto-based Data/AI team. The Toronto Technology Hub will serve as the base of our new Data/AI team, dedicated to building a modern data infrastructure for advanced analytics and the development of responsible AI. This strategic investment is integral to Guidepoint’s vision for the future, aiming to develop cutting-edge Generative AI and analytical capabilities that will underpin Guidepoint’s Next-Gen research enablement platform and data products.

This position will be hybrid in Toronto, Canada. 

More about Guidepoint’s Technology Team:

Guidepoint’s Technology team thrives on problem-solving and creating happier users. As Guidepoint works to achieve its mission of making individuals, businesses, and the world smarter through personalized knowledge-sharing solutions, the engineering team is taking on challenges to improve our internal application architecture and create new AI-enabled products to optimize the seamless delivery of our services.

Your Day-to-Day Will Include 💻:

• Design and development of systems for the maintenance of the Azure Lakehouse, ETL processes, business intelligence and data ingestion pipelines for AI/ML use cases.
• Create and support ETL pipelines and tables schemas in order to facilitate the accommodation of new and existing data sources for the Lakehouse on Databricks.
• Maintain data governance and data privacy standards.
• Collaborate with data architects, data scientists, analysts and other business consumers to quickly and thoroughly analyze business requirements to populate the data warehouse, optimized for reporting and analytics.
• Perform root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Minimum Qualifications✔️:

• 3+ years of related experience with a Bachelor’s degree or a PhD with 1 year experience.
• Advanced working SQL knowledge and experience working with relational and NoSQL databases, query authoring (SQL) as well as working familiarity with a variety of databases (e.g. SQL Server, Neo4J, Elastic, Cosmos).
• Experience building and optimizing data pipelines on Azure Databricks.
• In depth knowledge and hands-on experience with Data Engineering, Data Warehousing and Delta Lake on Databricks.
• Highly proficient in Spark, Python, SQL
• Working knowledge of Fivetran is a bonus.
• A successful history of manipulating, processing and extracting value from large, disconnected dataset
• Exceptional stakeholder management and communication skills to effectively communicate across global teams.

Preferred Qualifications✔️:

• Knowledge of BI Tools like PowerBI, Tableau etc.
• Experience with building data pipeline from various business applications like Salesforce, NetSuite, etc.
• Knowledge of message queuing, stream processing, and highly scalable data stores.
• Experience or knowledge of working in a compliance-based environment, including building and deploying compliant software solutions throughout the software life cycle is a nice to have.

You will also be eligible for the following benefits: 

• Paid Time Off 
• Comprehensive benefits plan 
• Company RRSP Match 
• Development opportunities through the LinkedIn Learning platform 

About Guidepoint: 

Guidepoint is a leading 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 help 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. 

At Guidepoint, our success relies on the diversity of our employees, advisors, and client base, which allows us to create connections that offer a wealth of perspectives. We are committed to upholding policies that contribute to an equitable and welcoming environment for our community, regardless of background, identity, or experience. 

#LI-HYBRID