Job Senior Data Engineer in Toronto

Our Company

Picton Mahoney Asset Management (“PMAM”) was founded in 2004 to provide unique investment solutions to institutional, retail and high net worth investors in Canada and around the world. We are proud to say that we are 100% employee-owned and manage approximately $10 billion in sub-advisory, pension plan and hedge fund assets on behalf of our clients. We are honoured to make the ranks as one of Canada’s Top-8 Employers as recognized through Great Place to Work™ in 2020 and 2021, Canada’s 2020 and 2021 Best Workplaces™ in Financial Services & Insurance, 2021 Best Workplaces™ for Women, 2021 Best Workplaces for Inclusion, and 2020 and 2021 Best Workplace™ in Ontario. The core values at Picton Mahoney guide the employee experience and contribute to the culture which fosters strong, transparent relationships.

Why Work at Picton Mahoney?

Picton Mahoney Asset Management is a place where employees can be proud of building a rewarding career that offers growth and the opportunity to evolve within a supportive culture that focuses on professional development. Over the past 15 years, we have learned from feedback and have developed strategies and programs that enhance employee engagement and improve the employee experience. As our values state: We work together; fully engaged and aligned. We support each other, and our actions contribute to the strategic goals of our firm. We are highly focused on continuous improvement while driving positive change and stronger results across our team and the firm. We believe in integrity and always “doing the right thing” for our clients, colleagues and the firm. We are committed to performance, excellence and winning. At Picton Mahoney, “stepping up” is an action, not a thought, which results in the development and implementation of those ideas. We accept full responsibility for personal performance and results. We believe in being open when providing and receiving feedback, because it makes us better at what we do best.

The Opportunity

Picton Mahoney Asset Management is presently seeking a Senior Data Engineer to join the newly formed Data team. Using your excellent communication skills, you are capable of conversing with both technical and non-technical 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 self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or re-designing our company’s data architecture to support our next generation of products and data initiatives. This is a fully remote opportunity.

Responsibilities of the Role

• Develop, maintain, and test infrastructures for data generation.
• Create and maintain optimal data pipeline architecture,
• Assemble large, complex data sets that meet functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AZURE cloud technologies.
• 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 data-related technical issues and support their data infrastructure needs.
• Keep data separated and secure across multiple, distinct businesses.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Work with internal and external partners to strive for greater functionality in our data systems

The Qualifications and Experience Required

• The ideal candidate will have 5+ 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 MS-SQL 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, architectures 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.
• A successful history of manipulating, processing and extracting value from large disconnected datasets.
• Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.
• Strong project management and organizational skills.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Hands-on experience on designing and developing scripts for custom ETL processes and automation in Azure data factory, Azure data bricks, Python, Pyspark etc.
• Good knowledge of AZURE Cloud platform services stack - Azure Data Factory, Azure SQL Database, AZURE Data Warehouse, Azure data bricks, Azure Blob Storage, Azure Data Lake Storage, HD Insight, Cosmos DB, etc.
• Experience using the following software/tools:
  • Big data tools: Hadoop, Spark, Kafka, etc.
  • MS-SQL
  • Azure cloud services
  • Data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
  • Object-oriented/object function scripting languages: C#.
  
  

Competencies of a Successful Leader at Picton Mahoney

• Results-Oriented: Does everything to be as productive as possible; keeps 100% focused on work; takes initiative to start and complete tasks.
• Collaboration: Relates well to all kinds of people, up, down and sideways, inside and outside the organization. Builds appropriate rapport; Builds constructive and effective relationships using diplomacy and tact; Can diffuse even high-tension situations comfortably.
• Critical Thinking: Able to objectively examine assumptions and beliefs; Makes decisions that impact problems at their cause rather than just the symptom; Uses a decision-making approach that is fair and accurate; Demonstrates insightful understanding of the organizational context and priorities; Foresees long-term implications of proposed positions.
• Customer Focus: Communicates in a positive manner, especially when handling complaints or conflict; efficiently obtains additional resources as needed to satisfy customer needs. Can refer internal or external people to the correct person in the organization
• Cultivates Innovation: Total understanding of the marketplace for products and services (what are the benefits to your customer and why do they buy your product); Is able to select from among many possible creative ideas for new products and services, those which would have the highest likelihood of success in the marketplace; Taking the raw idea and managing the transition to a successful product or process in the marketplace.
• Functional/Technical Skills: Understands technical expectations of the job and uses all resources available to improve effectiveness within the organization.
• Passion for Results: Can be counted on to exceed expectations on a regular basis; Is constantly and consistently one of the top performers; Very bottom-line oriented; Steadfastly pushes self and others for results
• Personal Learning or Self-Development: Engages in continuous self-development; Tackles challenges with enthusiasm and determination; Admits mistakes and openly identifies opportunities for personal growth; Knows personal strengths, weaknesses, opportunities, and limits

Above all, we’re looking for individuals with a mindset to think differently and who are inspired to make BIG impact. If you think that you will excel in this multi-faceted role, we want to hear from you!

Our Commitment to Employees

Picton Mahoney Asset Management is proud to offer our employees with generous perks and programs that enhance the career experience with our firm, including: Corporate Wellness & Fitness Reimbursement, Maternity and Parental Leave Top-Up, Peer Performance Recognition Awards, Semi-Annual Performance Bonuses, Generous Annual Vacation Entitlement (minimum of 15 days/year), Tuition Reimbursement, Extensive Medical & Dental Benefits, Healthcare Spending Account and more.

Health and Safety

We are doing our part to ensure the health and safety of all of our employees and visitors and to reduce the spread of COVID-19. Our office will allow for social distancing and ensuring new routines are followed, such as hand sanitizing, thorough disinfection and cleaning, mask wearing, and other protective equipment. In addition, all employees and visitors who visit our office will be mandated to be fully vaccinated against COVID-19.

Picton Mahoney Asset Management is proud to be recognized by Great Place to Work® as a 2021 “Best Workplaces for Inclusion” and 2021 “Best Workplaces for Women”. We are 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 (416) 955-4108 or at accessibility@pictonmahoney.com.