Data Engineer

at  Oxford Properties

Choose a workplace that empowers your impact.
Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and passion. A place where you can personalize your employee journey to be — and deliver — your best.
We are a leading global real estate investor, developer and manager. We combine our capital with our capabilities to create real estate that strengthens economies and communities. By prioritizing people, partnerships and places, we generate meaningful returns for OMERS members, enhance value for our capital partners and create a brighter world for our customers.
Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.
Don’t just work anywhere — come build tomorrow together with us.
Know someone at OMERS or Oxford Properties? Great! If you’re referred, have them submit your name through Workday first. Then, watch for a unique link in your email to apply.
We are seeking a highly skilled and motivated Data Engineer to join our team. The ideal candidate will have a strong background in developing ETL processes, managing a cost model in a SQL database, conducting code reviews, overseeing development processes, and building and maintaining Power Apps. This role will collaborate closely with our data scientist to enhance development practices, set up unit testing procedures, and manage release management. Additionally, the candidate will be responsible for dashboard development to enable effective data visualization and reporting.

QUALIFICATIONS AND SKILLS:

• Bachelor’s degree in Computer Science, Engineering, or related field.
• 1 - 3 years of experience in software development, with a focus on ETL processes, SQL database management, and Power Apps.
• Strong SQL skills and experience in database design, optimization, and maintenance.
• Solid understanding of ETL principles and practices.
• Experience with version control systems (e.g. Git) and CI/CD pipelines.
• Familiarity with software development methodologies and best practices.
• Proficiency in Microsoft Power Apps development.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.
• Attention to detail and a commitment to producing high-quality work.
• Experience in dashboard development and data visualization tools is a plus.
• Previous exposure to supporting data science initiatives is an advantage.
  We believe that time together in the office is important for OMERS and Oxford, the strength of our employees, and the work we do for our pension members. In delivering on our pension promise, keeping us connected to our work and each other, our flexible hybrid work guideline requires teams to come in to the office 3 days per week.
  Oxford’s purpose is to strengthen economies and communities through real estate.
  Our people-first culture is at its best when our workforce reflects the communities we live and work — and the customers we proudly serve.
  From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience. This sense of belonging and connection is cultivated up, down and across our global organization thanks to our vast network of Employee Resource Groups with executive leader sponsorship, our Purpose@Work committee and employee recognition programs

1. ETL Processes: Develop robust ETL processes to extract, transform, and load data from various sources into our systems, ensuring data accuracy and integrity.
2. SQL Database Management: Maintain and optimize a SQL database containing a cost model, ensuring data availability, security, and performance.
3. Code Reviews: Conduct thorough code reviews to ensure coding standards, best practices, and quality are upheld across the development team.
4. Development Process Improvement: Collaborate with the data scientist and development team to establish and enhance development processes, including version control, unit testing, and continuous integration/delivery.
5. Release Management: Oversee the release management process, coordinating with cross-functional teams to ensure smooth and timely deployment of software solutions.
6. Data Science Support: Collaborate with the data scientist to implement development best practices, set up unit testing frameworks, and provide technical support for data science initiatives.
7. Dashboard Development: Create visually appealing and insightful dashboards to enable data-driven decision-making within the organization.
8. Power Apps Development: Design, develop, and maintain Power Apps solutions that streamline business processes and enhance user experiences.
9. Technical Documentation: Document technical designs, procedures, and guidelines to facilitate knowledge sharing and onboarding.