Job Description

Working together to be our best!

First National is Canada's largest non-bank lender, originating and servicing both commercial and residential mortgages since 1988. Over the past thirty years, we have been committed to hiring the best and brightest with over 1,000 proud team members. Through cooperation, ongoing coaching, development opportunities and a culture that celebrates both hard work and teamwork, First National team members are supported to lead, learn and grow.

If you are ready to join First National's dynamic team, while working hard and having fun doing it, we invite you to apply online and let us know how you can be part of our success story.

We are hiring a Data Warehouse Developer to our Application Development team!

Reporting To:

Manager, Application Development

Full-Time/Part- Time:

Full-Time

Posting Date:

November 2, 2022

Closing Date:

November 16, 2022

Hours of Work:

8:30 a.m. - 5:00 p.m.

Grade:

Office Location:

7

Great location! Steps away from the main public transit station

What we offer:

Highly competitive compensation package which includes, base salary, bonus, benefits, and career advancement opportunities!

*Eligibility for benefits is dependent on the terms of employment

The Opportunity:

We are looking for great people so together we can do great things! The successful candidate will be a Data Warehouse Developer - highly experienced in deploying implementations, balances leadership and technical abilities as they work with our dedicated SCRUM team.

• Analyze business requirements for the company and design the best possible solution based on technology, infrastructure and timelines provided.
• Collaborate with Managers, Application Development, Team Leads, Business Analysts and End Users to ensure code quality, accuracy and correct business solutions have been developed.
• Participates, and at times leads, in the multiple stages of project development adhering to the application lifecycle methodologies utilized at First National Financial.
• Design and implement ETL processes in support of business analytics and reporting, including programming, documentation and testing of solutions.
• Develop and perform unit, system, performance, and regression testing on ETL mappings.
• Provide production implementation and post-implementation support along with the necessary documentation.
• Complete project deliverables within timelines and budget constraints as per business requirements.
• Create source-to-target mapping specifications for ETL development.
• Support and improve production data integration system and environment.
• Follow established coding standards, perform code reviews, and improve standards to assure compliance.

The Requirements Needed:

• University degree in Computer Science/Information Technology or equivalent experience.
• 7+ Years of experience in SSIS and use of Stored Procedures.
• 7+ years of experience in Data Warehousing and Business Intelligence.
• 5+ Years of development experience in C# .NET
• 6 months to 1 Year experience in Azure Data Warehouse, Azure Data Factory, SQL VMs.
• Strong analytical, conceptual, and problem-solving abilities.
• Deep understanding of relational database design concepts and SQL programming.
• Ability to work in a team environment and independently with minimal guidance.
• Ability to interact with Business Analysts, QA, and end users, excellent communication skills, both verbal and written.
• Available for off-business hours implementation and support.
• Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS and Power BI).
• Hands-on experience in writing complex T-SQL and database performance tuning.
• Excellent knowledge of relational data modeling (ERD), SQL and data warehousing.
• Familiarity with XML and related technologies (XSD, XSLT, XQuery, XPath...).
• Financial work-related experience
• Microsoft Certification in Azure Data Solutions
• Design pattern knowledge/experience
• Agile developer experience
• Microservices, Web Services and related technologies (SOA, WSDL, SOAP, WCF...)
• Automated unit testing with frameworks such as xUnit, MSTest
• Web technologies (HTML, JavaScript, MVC, MVVM, jQuery) experience/comprehension

Why join First National?

• Bright open concept office environment
• Large kitchens with a coffee and latte maker to enjoy at no cost
• Supportive teamwork focused environment
• Collaborative entrepreneurial spirit
• Opportunities to give back to the communities and work through events focused on a variety of charities
• Ongoing social events throughout the year
• Extensive training programs to set our employees up for success

First National is proud to be an equal opportunity employer and is committed to diversity and inclusion regardless of race, color, religion, national origin, age, gender identity, physical or mental disability, sexual orientation or any other category protected by law.

First National supports requests for accommodation from applicants with disabilities; please contact Human Resources at .

We would like to thank all applications for their interest, but only candidates selected for an interview will be contacted.

#FNLOON

Other details

• Job Family IT (IT)
• Pay Type Salary
• Required Education Bachelor's Degree

• Toronto, ON, Canada