Data Engineer
Toronto, Ontario, Canada
Guidepoint
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
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Business Intelligence Databricks Data governance Data pipelines Data warehouse Data Warehousing Engineering ETL FiveTran Generative AI Machine Learning Neo4j NoSQL PhD Pipelines Power BI Privacy Python Research Responsible AI Salesforce Spark SQL Tableau
Perks/benefits: Career development
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open MLOps Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs