Logo of Huzzle

Home

Matches

Explore

Manage

Data Engineer

image

Oxford Properties Group

24d ago

  • Job
    Full-time
    Junior & Mid Level
  • Data
    Software Engineering
  • Toronto

AI generated summary

  • You need a degree in Computer Science or related field, 1-3 years in software dev (ETL, SQL), strong SQL skills, Power Apps proficiency, and familiarity with Git, CI/CD, and data visualization tools.
  • You will develop ETL processes, manage SQL databases, conduct code reviews, improve development processes, oversee releases, support data science, create dashboards, and document technical procedures.

Requirements

  • 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.

Responsibilities

  • ETL Processes: Develop robust ETL processes to extract, transform, and load data from various sources into our systems, ensuring data accuracy and integrity.
  • SQL Database Management: Maintain and optimize a SQL database containing a cost model, ensuring data availability, security, and performance.
  • Code Reviews: Conduct thorough code reviews to ensure coding standards, best practices, and quality are upheld across the development team.
  • 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.
  • Release Management: Oversee the release management process, coordinating with cross-functional teams to ensure smooth and timely deployment of software solutions.
  • 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.
  • Dashboard Development: Create visually appealing and insightful dashboards to enable data-driven decision-making within the organization.
  • Power Apps Development: Design, develop, and maintain Power Apps solutions that streamline business processes and enhance user experiences.
  • Technical Documentation: Document technical designs, procedures, and guidelines to facilitate knowledge sharing and onboarding.

FAQs

What is the role of a Data Engineer at OMERS?

The Data Engineer at OMERS is responsible for developing ETL processes, managing SQL databases, conducting code reviews, collaborating with data scientists, overseeing release management, and creating dashboards and Power Apps to enhance data-driven decision-making.

What are the key responsibilities of the Data Engineer?

Key responsibilities include developing ETL processes, maintaining a SQL database, conducting code reviews, improving development processes, overseeing release management, supporting data science initiatives, creating dashboards, developing Power Apps, and documenting technical designs.

What qualifications are required for the Data Engineer position?

Candidates should have a Bachelor's degree in Computer Science, Engineering, or a related field, 1-3 years of experience in software development focusing on ETL processes, SQL database management, and Power Apps, as well as strong SQL skills and familiarity with version control systems and CI/CD pipelines.

Is experience in dashboard development necessary?

While experience in dashboard development and data visualization tools is a plus, it is not a strict requirement for the position.

How does OMERS prioritize employee wellness?

OMERS encourages employee wellness by fostering a people-first culture, offering flexible hybrid work guidelines, and promoting a supportive environment for personal and professional growth.

What is the hybrid work model at OMERS?

The hybrid work model at OMERS requires teams to come into the office three days a week while also allowing for remote work.

Are there opportunities for professional development at OMERS?

Yes, OMERS emphasizes employee growth and development, providing opportunities to enhance skills and build connections within the organization.

How does OMERS embrace diversity?

OMERS is committed to a diverse workforce that reflects the communities they serve, supported by various Employee Resource Groups and an inclusive recruitment process.

What tools and technologies should a Data Engineer be familiar with?

A Data Engineer should be familiar with SQL, ETL tools, version control systems (like Git), CI/CD practices, Microsoft Power Apps, and ideally dashboard development and data visualization tools.

What kind of projects will a Data Engineer work on?

A Data Engineer will work on projects involving data extraction, transformation, and loading, database management, dashboard creation, Power Apps development, and support for data science initiatives.

image

Oxford Properties Group

Real Estate
Industry
1001-5000
Employees

Mission & Purpose

We are a global real estate investor, developer and manager. Established in 1960, Oxford and our platform companies manage nearly $87 billion of assets with a portfolio of 158 million square feet of commercial space. Our global portfolio includes workplace, life sciences, industrial, shopping, living, hotels & alternatives and credit assets on four continents. A thematic investor with a committed source of capital, we invest in properties, portfolios, development sites, debt, securities and platform companies across the risk-reward spectrum. Oxford is backed by OMERS, which has a diversified, global portfolio of public market, infrastructure, private equity, venture capital and real estate investments. OMERS ensures retirement security for over half a million public service and other employees from municipalities, school boards, transit systems, electrical utilities, emergency services and children’s aid societies across Ontario, Canada.