Data Engineer

Tricon Residential is an owner, operator and developer of single-family rental homes in the U.S. and multi-family apartments in Canada. Our commitment to enriching the lives of our employees, residents and local communities underpins Tricon’s culture and business philosophy. We provide high-quality rental housing options for families across the United States and Canada through our technology-enabled operating platform and dedicated on-the-ground operating teams. Our development programs are also delivering thousands of new rental homes and apartments as part of our commitment to help solve the housing supply shortage. At Tricon, we imagine a world where housing unlocks life’s potential.

We strive to be North America’s premier rental housing company. Our business philosophy involves taking care of our team first – empowering them to provide our residents with exceptional service and to positively impact the local communities where we operate. By providing an enhanced living experience, our residents rent for longer periods of time, treat our properties like their own, and share their experience with friends and family. This is how we continue to grow, and it is an approach that has proven to generate positive returns for our stakeholders.

For more information, visit Tricon Residential. 

Job Description

As a Data Engineer, you will be responsible for developing best practices and making architectural decisions to rapidly improve critical data processing & analytics pipelines. You will tackle hard problems to improve the platform's reliability, resiliency, and scalability. You will provide technical leadership, lead data engineering initiatives and build end-to-end analytical solutions that are highly available, scalable, stable, secure, and cost-effective. You strive for simplicity, demonstrate creativity and sound judgement. You deliver data solutions that are customer focused, easy to consume and create business impact. We are looking for someone who thrives on autonomy and has experience driving long-term projects to completion. You are detail and quality oriented, and excited about the prospects of having a big impact with data at Tricon Residential. Our tech stack includes Informatica, Matillion/Altryx, Snowflake, Power BI and various AWS services

• Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions with a flexible and adaptable data architecture
• Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization
• Implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it
• Write unit/integration tests, contribute to engineering wiki, and document work
• Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues
• Design data integrations and data quality framework
• Work closely with all business units and engineering teams to develop strategy for long-term data platform architecture
• Develop CI/CD pipelines and testing automation
• Develop, refine and educate the data community on coding standards and best practices

Qualifications:

• 3+ years of experience with demonstrated strength in ETL/ELT, data modeling, data warehouse technical architecture, infrastructure components and reporting/analytic tools
• 3+ years of hands-on experience in writing complex, highly optimized SQL queries across large data sets
• 3+ years of experience in scripting languages like Python etc.
• Experience building code-driven infrastructure on public cloud platforms, preferably AWS
• Understanding of SQL, dimensional modeling, and analytical data warehouses, like Snowflake
• Experience with automation frameworks/tools like Git, Jenkins, Ansible, and Terraform
• A Bachelor's degree in a quantitative/technical field (e.g. Computer Science, Statistics, Engineering) or equivalent industry experience
• Experience architecting data lake and cloud data warehouses
• A product-focused mindset with ability to understand business requirements and architect systems that will scale and extend to accommodate those needs

At Tricon, we are committed to creating a workplace where every individual is valued for their unique contributions, experiences, voices, and backgrounds. By embracing these principles, we aim to positively impact our business and the communities we serve, creating a lasting legacy where everyone can thrive.

Salary Range

Placement within this compensation range will be determined by the candidate's knowledge, experience and skills.

$69,250.00 - $138,500.00