Data Engineer
Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Great Place to WorkBest Workplaces with Most Trusted Executive TeamsBest Workplaces in Financial Services & InsuranceBest Workplaces for Mental WellnessBest Workplaces for Giving BackBest Workplaces for Inclusion 2024 Best Workplaces in Ontario 2024
One of Canadas Most Trusted Investment Brands.
At Picton Mahoney Asset Management 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 employeeowned and deeply committed to delivering results for our clients.
Thinking Alternatively is in Our DNA.
With a team of 160 bold thinkersonethird dedicated solely to investment managementwe are specialists not generalists. Managing $13.6 billion for institutional and retail clients we navigate markets with conviction resilience and a forwardthinking 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 bureaucracyfree environment join us and be part of whats next.
Thriving in Our Entrepreneurial Culture
At Picton Mahoney youll thrive in our creative and dynamic workplace where collaboration and support are at the core of everything we do. At our firm youll have the opportunity to take on significant responsibilities work in a flexible environment and tackle challenging projects from the outset. Our culture is designed for ambitious professionals who want to make an immediate impact while continuing to push boundaries and achieve our greater mission. Youll be empowered with a high level of responsibility trust and flexibility providing an exciting and creative space for you to help reshape how the world views alternative investments. With competitive total rewards performancebased bonuses and a clear path for career growth youll have everything you need to develop both now and over the longer term.
The Opportunity
Picton Mahoney Asset Managementis presently seeking a Data Engineer to join the newly formed Data team. Using your excellent communication skills you are capable of conversing with both technical and nontechnical colleagues and are comfortable contributing to a highly multidisciplinary team. If you believe that you are a true techie at heart and feel empowered working on innovative technology that makes a difference this could be the opportunity for you!
Leveraging a rich knowledge of Azure cloud and SQL database design and multiple programming languages the Data Engineer will be responsible for designing building and optimizing systems for data collection storage and analytics at scale. The successful incumbent will play a crucial role in collecting managing and converting raw data into high quality and high impact pipelines as well as constructing dataset procedures that will have an immediate and transformative impact on the business.
The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Data Engineer will support our software developers database architects data product owners web solutions architect and others on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be selfdirected and comfortable supporting the data needs of multiple teams systems and products. The right candidate will be excited by the prospect of optimizing or redesigning our companys data architecture to support our next generation of products and data initiatives. This opportunity requires a successful candidate to work in a flexible hybrid model out of our head office in Toronto Ontario.
Youll have the opportunity to lead and learn:
- Design develop and maintain ETL pipelines.
- Automate data ingestion from different data sources.
- Assemble large complex data sets that meet functional business requirements.
- Optimize workflows for performance scalability and reliability.
- Implement data validation deduplication and integrity checks.
- Optimize query performance and ensure costefficient data storage.
- Manage data lakes warehouses marts and databases.
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition operational efficiency and other key business performance metrics.
- Work with stakeholders including the Executive Product Data and Development teams to assist with datarelated technical issues and support their data needs.
- Document data flows architecture and pipeline dependencies.
- Provide support for troubleshooting and optimizing queries/pipelines.
What were looking for
- The ideal candidate will have 3 years of experience in a Data Engineer role who has attained a Graduate degree in Computer Science Statistics Informatics Information Systems or another quantitative field.
- Certifications: Azure Certifications preferred
- Advanced working MSSQL knowledge and experience working with relational databases query authoring (SQL) as well as working familiarity with a variety of databases.
- Experience building and optimizing big data data pipelines and data sets.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Strong analytic skills related to working with unstructured datasets.
- Build processes supporting data transformation data structures metadata dependency and workload management.
- Experience supporting and working with crossfunctional teams in a dynamic environment.
- Experience on designing and developing scripts for custom ETL processes and automation in Azure data factory Azure data bricks Snowflake Python Pyspark etc.
- Good knowledge of AZURE Cloud platform services stack Azure Data Factory Azure SQL Database AZURE Data Warehouse Azure data bricks Snowflake Azure Blob Storage Azure Data Lake Storage HD Insight Cosmos DB etc.
- Experience using the following software/tools:
Our Commitment to Employees
At Picton Mahoney Asset Management 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 Wealth investment counseling and portfolio management services volunteer and charitable donation matching maternity and parental leave topup recognition awards semiannual 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 wellbeing and overall success. Join us and thrive in an environment that values and invests in you!
Picton Mahoney Asset Management is 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 ator at .
Picton Mahoney Asset Management does not accept unsolicited resumes emails calls or any other form of communication from thirdparty recruitment agencies. Any unsolicited outreach including commercial electronic messages will neither be acknowledged nor considered.
Job Posting Closing Date: Wednesday March 19th at 5:00 PM EST
Please note that while we carefully review each application only those candidates selected for further consideration will be contacted. We wish you all the best in your job search and future endeavors.
Required Experience:
Manager
Employment Type
Full-Time
