Developer/ Systems Analyst

at  Trez Capital

Why Join Trez Capital?
Founded in 1997, Trez Capital is a non-bank leading provider of private commercial real estate debt and equity financing solutions in Canada and the United States. For over 25 years, we have consistently provided developers and owners with flexible short-to-mid-term financing. Trez Capital also offers private and institutional investors strategies to invest in a variety of opportunistic, fully secured mortgage investment funds and investment assets. We have built our reputation on doing what we say, with a results-oriented approach to everything we do. We are building a better future as we proudly build better places for people to live, work and play. We are committed to our values – Trust, Respect, Excellence, and Zest - in all that we do.
We pride ourselves on our relationships and are passionate about providing exemplary client service, creating loyal and satisfied investors and borrowers and fostering a collaborative environment in which our employees can excel. We believe in hiring the best people who are as committed to creating incredible experiences for our clients and our team members. We set bold goals and deliver results.

PRIMARY ACCOUNTABILITIES:

• Develops, implements, and maintains ETL processes to support data integration and reporting solutions using SQL, Power BI or other data management software
• Works with various departments and personnel to create business cases and facilitate implementing new business processes, process redesign and technology deployment with well thought out requirements, functional and technical blueprints, and project plans to achieve the desired business goals
• Assist with maintaining the Enterprise Segment Architecture including the Data Dictionary
• Designs, develops and deploys reports to provide new insights into the business
• Develop, Maintain, Troubleshoot & Upgrade
• M/S SQL Databases & Code (ETL Processes)
• M/S Power Apps (Applications)
• M/S Power Automate (Flows/Jobs)
• M/S Power BI (Dashboards, Visualization & Reporting)
• Integration with CoPilot, ML/AI platforms
• Build, Manage & Monitor Automated Routines
• Reconcile data and work with users to sanitize data where necessary

(includes identifying and remediating data Inconsistencies)

• Other projects and duties as assigned

Additional Accountabilities:Embraces the Trez core values:

• We build Trust through the integrity of our people and our actions. We have built our reputation on transparency and doing what we say, with a rigorous, results-oriented, risk-managed approach to everything we do.​
• We pride ourselves on the Respect we create inside and outside the firm. We are passionate about providing exemplary client experiences creating loyal and satisfied investors, partners and borrowers and fostering a collaborative environment in which our employees can excel.​
• We pursue Excellence for our employees, investors, partners and borrowers. Everyone who works with us is accountable for our clients’ success. ​
• Our bold goals and winning outcomes are the results of our ability to create unique offerings based on our unwavering Zest, discipline and innovative entrepreneurialism.​
• Complies with all policies and procedures, work rules, and standard operating procedures
• Safeguards the interests of the business, our people and our clients
• Completes other related duties as required

QUALIFICATIONS AND EXPERIENCE:

• Undergraduate or other advanced degree in a quantitative discipline with applicable work experience in data management
• Experience working with relation databases and normalized data
• A minimum of 2 years using Microsoft SQL and one or more scripting languages in a data science / warehouse / management, financial analysis, or business intelligence role
• A minimum of 2 years experience implementing solutions with PowerBI, PowerApps and PowerAutomate
• Experience integrating financial and operational data from multiple systems
• Practical experience with self-auditing solutions before delivery and development of solutions without technical requirements or project plans
• Prior experience with SalesForce, nCino, Great Plains or Loan Servicing software is preferred but not mandatory
• Proven track record of implementing leading edge performance indicators for businesses

CORE COMPETENCIES (KNOWLEDGE, SKILLS & ABILITIES):

• Able to clearly communicate with technical resources and business users, to develop business cases and solutions.
• Ability to understand and explain each discipline of analytics, data management, data architecture and programming.
• High attention to detail, accuracy and good documentation habits.
• Sound judgment and problem-solving skills to analyze information, with the ability to interpret general procedures to formulate recommendations to problems, utilizing appropriate technology.
• Proficient in self-planning skills with the ability to schedule, organize and manage multiple activities of varying complexity according to established plans and adjust work schedules according to changing priorities and time constraints.
• Structured, disciplined and organized, with the ability to design and successfully implement effective and efficient business processes and systems.
• Ethical and credible with a high degree of personal and professional integrity.
• Superior interpersonal and relationship management skills.

The Developer / Systems Analyst works with the Director, Data Analytics to develop, implement and maintain the data integration and reporting solutions within Trez to improve the analytical reporting, digitization, and process efficiencies.