YWCA TORONTO EMPLOYMENT CENTRE IS SUPPORTING OUR EMPLOYER PARTNER WITH FILLING THIS POSITION. *NOTE - Due to our funding requirements, we are unable to consider international students at this time. * The CanCap Group (“CanCap”) is a privately-owned Canadian national financial services company with multiple verticals across automotive, consumer, and merchant lending portfolios. We manage the entire lifecycle of the finance receivable from credit adjudication through to contract administration, customer service, default management and post charge-off recoveries. We are a company of innovators. We learn from each other, respect each other, and create together. We strive to inspire our customers by continually understanding them, meeting their needs, and keeping them happily surprised. And we always do so with integrity. When it comes to our customers, partners, and each other, we are always motivated by doing the “right thing”. We are always looking to find the best people and the right methods that allow us to meet this goal and look to the future for growth. *What your day and week could look like* Reporting to the Engineering Lead, a Data Engineer plays an essential role in supporting all aspects of our operations. This includes: *1. Designing and implementing data management strategies through:*
* Translating complex functional, technical, and business requirements into architectural designs and solutions
* Understanding, applying, and recommending architecture principles in the context of current needs with the appropriate consideration for future growth
* Making and clearly articulating linkages between stakeholder needs and enterprise needs and constraints
* Developing the data standards and processes based on industry best practices ensuring that the ‘concepts’ are communicated and accepted across the enterprise
* Devising and implementing efficient and secure procedures for data handling, analysis, and delivery with attention to all technical aspects *2. Designing, implementing, and maintaining report delivery solutions that scale with the business. Including:*
* Managing a pipeline of intake requests from business stakeholders
* Creating reports and data extracts, building data models, and viewing to support front business stakeholders
* Creating ad-hoc SQL queries, reports, and other data deliverables from a proprietary built SQL Data Warehouse and third-party information sources
* Creating and delivering PowerBI based solutions for data consumption *3. Providing direction through leadership and decision making to team members in matters related to the design and development of the data management strategy**What you bring:*
* Background in the Financial Services industry coupled with prior experience of working with origination and servicing data from auto finance, personal loans, and credit cards
* Minimum of seven (7) years’ experience working in data analytics, SQL management, database design, requirements analysis, information delivery, and in a 24x7 production environment
* Familiarity with data analysis, data mining, source to target mapping, data domain and referential integrity verifications
* Strong work experience with database security, data ingestion and manipulation, business-to-business processes, ETL, reporting
* Seasoned experience in identifying and analyzing business requirements integrated with business vision, strategy, and roadmaps
* Collaborative abilities to build and develop relationships with key internal stakeholders
* Excellent analytical, problem-solving, and troubleshooting skills in a timely manner
* A proven record of innovation and enterprise technology support
* Excellent organizational skills; can balance several projects concurrently; highly effective at time management and setting priorities
* Deep capacity to thrive in a dynamic, changing business environment
* Passionate desire to influence and impact change; proven ability to manage and develop high performing team members
* Fluent ability to communicate business information in English
* Motivation and drive towards continuous learning and growth within your role and the company *Proven experience in:*
* SQL Server Design and Management and SSRS (minimum 7+ years)
* PowerBI - architecture and development
* Writing SQL code, Functions, Procedures, Data Ingestion and Extraction
* SSIS Design and package implementation
* Data management, notably where support was provided to cross-functional business units within the organization e.g. risk, finance, operations, sales *Location* Our office is located in downtown Toronto. Successful candidates will have the ability to participate in our hybrid work policy. *Additional Information* To be considered for employment you will need to successfully pass a criminal background check, and validation of your work experience Job Type: Full-time Application question(s):
* Are you legally entitled to work in Canada?
* Are you an international student?
* Are you currently employed? If so how many hours?
* How many years of experience working in data analytics, SQL management, database design, requirements analysis, information delivery, and in a 24x7 production environment
* Do you have a background working in Finance Services? Education:
* Bachelor's Degree (required) Work Location: Hybrid remote in Scarborough, ON M1M 1P2