Data Engineer

This is a fully remote position, open to applicants in Canada.

📋 Description

• Build data pipelines and support data architecture on Azure to integrate data effectively.

• Assist BI developers, database architects, data analysts, and data scientists with data initiatives.

• Ensure the accuracy, accessibility, security, and appropriateness of data.

• Design and construct reusable processes for data extraction, transformation, and loading.

• Create Modern Data Warehouse solutions utilizing Azure Data Factory, Azure Data Lake, Azure Synapse, and Databricks.

• Enhance the performance of data warehouses, data models, and reusable data structures.

• Develop CI/CD, automation, and deployment processes within a DevOps framework.

• Engage in metadata management and data governance projects.

• Address complex data challenges and provide insights that align with organizational objectives.

• Collaborate with Executive, Product, Data, and Design teams to address technical data issues and infrastructure requirements.

• Create analytical tools for data science and analytics teams.

• Work closely with data and analytics specialists to enhance the functionality of data systems.

⛳️ Requirements

• A post-secondary diploma or degree in Computer Science, Data Analytics, Information Systems, or a related discipline.

• Preferred: Microsoft Azure Data Engineer Associate Certification.

• Proficient in advanced SQL.

• Background in working with relational databases, including query authoring (SQL) and performance tuning.

• Experience in building and optimizing big data pipelines, architectures, and datasets using Azure Data Factory.

• Practical experience with Azure Synapse.

• Ability to conduct root cause analysis on both internal and external data and processes.

• Strong analytical skills with unstructured datasets.

• Some familiarity with Python.

• Capability to establish processes for data transformation, data structures, metadata, dependency, and workload management.

• Understanding of SQL and relational databases.

• Knowledge of data integration and transformation principles.

• Experience with Power BI or similar analytical tools.

• Familiarity with the Microsoft 365 ecosystem; experience with Excel, Teams, and Power Platform is a plus.

• Competence in producing clear documentation and technical notes.

🏝️ Benefits

• 7% employer-matched pension plan.

• Comprehensive extended health and wellness benefits.

• Employee and family assistance program.

• Preferential loan rates for staff.

• Commitment to the community: $1.1 million invested in local organizations last year.

• Initiatives promoting diversity and inclusion.