Senior Data Engineer

Best Workplaces in Canada 2020 - 2025 Best Workplaces with Most Trusted Executive TeamsBest Workplaces in Financial Services & Insurance 2020 - 2025 Best Workplaces for Mental Wellness 2023 - 2025 Best Workplaces for Giving BackBest Workplaces for InclusionBest Workplaces for Women 2021 Best Workplaces in OntarioBest Workplaces for Professional Development

One of Canadas Most Trusted Investment Brands.

AtPicton Mahoney Asset Management (PICTON Investments) being alternative isnt just what we doits who we are.

Founded by industry pioneer David Picton weve spent 20 years challenging conventional wisdom and redefining the investing landscape. As one of Canadas most trusted investment brands we are proudly independentprivately run 100% employee-owned and deeply committed to delivering results for our clients.

Thinking Alternatively is in Our DNA.

With a team of 203 bold thinkersone-third dedicated solely to investment managementwe are specialists not generalists. Managing $16.1 billion for institutional and retail clients we navigate markets with conviction resilience and a forward-thinking approach.

Were more than investors were innovators. We challenge traditional investment mindsets constantly pushing the boundaries to achieve our mission: To bring greater certainty to investors.

Our success is built on four guiding principles:

• Treat investors money like our own.
• Redefine the way investors invest.
• Be humanalways approachable.
• Succeed together one investment at a time.

These arent just wordsthey define how we think how we invest and how we work.

Now were entering our next chapter. Were transforming our brand and reshaping the way the world invests. If you think alternatively embrace an entrepreneurial spirit and thrive in a dynamic bureaucracy-free environment join us and be part of whats next.

The Opportunity

PICTON Investments is seeking a skilled Senior Data Engineer to join our newly formed Data team. If youre a tech enthusiast who thrives on innovation and enjoys turning complex data into actionable insights this is the role for you. You will collaborate with both technical and non-technical colleagues in a highly multidisciplinary team contributing to projects that make a real business impact.

As a Data Engineer you will leverage your expertise in Azure Databricks Snowflake Azure Cloud SQL and programming languages to design build and optimize large-scale systems for data collection storage and analytics. Your work will directly influence high-quality pipelines and datasets that support critical business decisions.

Youll have the opportunity to lead and learn:

• Design develop and maintain ETL pipelines.
• Automate data ingestion from multiple sources.
• Assemble large complex datasets that meet business requirements.
• Optimize workflows for performance scalability and reliability.
• Implement data validation deduplication and integrity checks.
• Optimize query performance and ensure cost-efficient data storage.
• Manage data lakes warehouses marts and databases.
• Build analytics tools to deliver actionable insights into customer acquisition operational efficiency and business performance metrics.
• Collaborate with stakeholders including Executive Product Data and Development teams to solve data-related challenges.
• Document data flows architecture and pipeline dependencies.
• Support troubleshooting and optimization of queries and pipelines.

What were looking for

• Experience: 7 years as a Data Engineer preferably with a Graduate degree in Computer Science Statistics Informatics Information Systems or another quantitative field.
• Technical Skills:
  • Designing and developing custom ETL processes using Azure Data Factory Azure Databricks Snowflake Python PySpark.
  • Advanced MS-SQL and relational database experience.
  • Experience designing and optimizing big data pipelines and datasets.
  • Experience with big data tools: Hadoop Spark Kafka.
  • Knowledge of Azure Cloud services including Data Factory SQL Database Data Warehouse Blob Storage Data Lake Storage HDInsight Cosmos DB etc.
  • Familiarity with data pipeline and workflow tools: Azkaban Luigi Airflow.
  • Proficiency in object-oriented scripting languages such as Python or C#.
• Soft Skills:

• • Excellent communication skills for technical and non-technical stakeholders.
  • Comfortable supporting multiple teams systems and products simultaneously.
  • Self-directed with a proactive approach to solving complex data challenges.

• Certifications: Azure certifications preferred.

Our Commitment to Employees

AtPICTON Investments we take pride in enhancing our employees experiences through a comprehensive suite of exceptional perks and programs. Our benefits include corporate fitness reimbursement and discounts VersaFi memberships (formerly Women in Capital Markets) Picton investment counseling and portfolio management services volunteer and charitable donation matching maternity and parental leave top-up recognition awards semi-annual performance bonuses a generous annual vacation entitlement (minimum of 15 days per year) training and development reimbursement extensive health and dental benefits a healthcare spending account and more.

These offerings are designed to support your career growth well-being and overall success. Join us and thrive in an environment that values and invests in you!

PICTON Investmentsis committed to providing an equitable and fair work environment for everyone and all hiring and other personnel actions will be taken without regard to race colour creed religion sex disability gender identity gender expression family status age language or national origin. If you require an accommodation at any point in time throughout the application and hiring process please contact Human Resources at or at.

PICTON Investmentsdoes not accept unsolicited resumes emails calls or any other form of communication from third-party recruitment agencies. Any unsolicited outreach including commercial electronic messages will neither be acknowledged nor considered.

Required Experience:

Manager