Senior Data Engineer

  • Company:
    Tricon Residential
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    21 hours ago
  • Category:
    IT & Software

We are a rental housing company dedicated to providing an exceptional rental experience to every resident who makes one of our houses or apartments their home. We believe that quality rental housing can unlock life’s potential, and this drives our thinking and our actions every day.Founded in 1988 and listed on the Toronto Stock Exchange (TSX: TCN), Tricon owns over 30,000 single-family and multi-family rental homes across the United States and Canada, which we manage using an integrated technology-enabled operating platform. We are headquartered in Toronto, Ontario and have significant operations in Orange County, California, as well as approximately 20 other markets with a primary focus in the U.S. Sun Belt.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 investors and shareholders.Job SummaryAs a Senior 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/Tableau and various AWS/Azure services.Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions with a flexible and adaptable data architectureCollaborate 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 organizationImplement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on itWrite unit/integration tests, contribute to engineering wiki, and document workPerform data analysis required to troubleshoot data related issues and assist in the resolution of data issuesDesign data integrations and data quality frameworkDesign and evaluate open source and vendor tools for data lineage and governanceWork closely with all business units and engineering teams to develop strategy for long-term data platform architectureAutomate cloud infrastructure, services, and observabilityDevelop CI/CD pipelines and testing automationDevelop, refine and educate the data community on coding standards and best practices5+ years of experience with demonstrated strength in ETL/ELT, data modeling, data warehouse technical architecture, infrastructure components and reporting/analytic tools5+ years of hands-on experience in writing complex, highly optimized SQL queries across large data sets3+ years of experience in scripting languages like Python etc.Experience building code-driven infrastructure on public cloud platforms, preferably AWSUnderstanding of SQL, dimensional modeling, and analytical data warehouses, like SnowflakeExperience with automation frameworks/tools like Git, Jenkins, Ansible, and TerraformA Bachelor”s degree in a quantitative/technical field (e.g. Computer Science, Statistics, Engineering) or equivalent industry experienceExperience with AWS services such as Redshift, Glue, S3, EMR, Kinesis and SNS/SQSExperience architecting data lake and cloud data warehousesA product-focused mindset with ability to understand business requirements and architect systems that will scale and extend to accommodate those needs