Join us in improving lives

Data Engineer

Subscribe to RSS Feed
Printer friendly interface
Job Number:
Job Title:
Data Engineer
Job Type:
Perm F/T
City, Province, Country:
Guelph, Ontario, Canada
Job Category:
Information Technology
Open Positions:

Make a difference in a growing, innovative mental health organization and centre of excellence in people-centered care. Work with supportive colleagues who are passionate about improving lives and champions for quality and continuous learning.

Position Summary

As a Data Engineer, you will be an integral part of a collaborative team focused on delivering seamless services and programs to our clients and customers. If you are looking for a company that is constantly moving forward in pursuit of successful outcomes, get ready to love it here!

What you'll be doing

• Work closely with Data Analysts to develop a reporting inventory, document ETL processes and creating reports with a high level of accuracy and quality
• Demonstrate expert knowledge in SSRS, Power BI and database programming
• Participate in the design and enhancement of data marts and data warehouse
• Maintain and administer SQL Server Reporting services and Microsoft SQL Server 2016 data warehouse server
• Participate in requirement gathering sessions, document user requirements and translate them into useful solutions
• Tune and maintain BI software and database components
• Monitor, tune and enhance existing SQL Server ETLs and scheduled jobs
• Develop ETLs to support reporting, analytics, dashboards and KPIs
• Document data flows, stored procedures, ETLs and reporting solutions
• Create, support and enhance OLAP and Tabular cubes
• Write complex MDX/DAX to be used in reports

What we're looking for

• Bachelors or Diploma in Information Technology or computer science
• Expert in Microsoft SQL Server and the Microsoft BI suite
• Expertise in data retrieval and manipulation from relational or multi-dimensional databases
• Minimum 2 years of proven experience in a similar role with SQL Server
• Microsoft BI certification is considered an asset
• Advanced Knowledge of SQL programming and stored procedures
• Knowledge of SQL Server security and administration
• Experience creating, publishing, Troubleshooting SSRS reports
• Experience troubleshooting and performance tuning SQL scripts, stored procedures
• Experience with Visual studio and TFS
• Advanced Knowledge of MDX, DAX and OLAP (including tabular)
• Experience in SSAS, ETL using SSIS and a thorough understanding of Dimensional modelling
• Experience using, designing and developing cubes
• Experience with Microsoft Power BI is considered an asset
• Mobile BI development in SSRS/Power BI (KPIs, mobile reports, etc)
• Experience with data platform cloud technologies for creating data pipelines – preference GCP Cloud is considered an asset

Why work with us

Homewood Health is Canada’s largest and leading service provider for medically focused, evidence-based treatment of mental health and addiction disorders. Our organizational culture values service excellence, integrity, collaboration and innovation. Our people make a difference!

Homewood Health Inc. is committed to ensuring that its teams reflect the diversity of our community and welcomes applications from all qualified individuals. In accordance with the various provincial legislations that we operate under, Homewood Health is committed to working in collaboration with any team member who may require workplace accommodation in order to successfully perform any or all aspects of their role. Join us at Homewood Health™ and be part of a diverse team helping Canadians live healthier, more productive and fulfilling lives.

What Our Team Has To Say

I work in a team-oriented atmosphere. Its the type of environment that makes you enjoy coming to work every day.

- Allison,Return to Work Services

Every day I feel well supported and I know that my work is appreciated at every level of the organization.

- Tamaura,Homewood Health Centre

Its gratifying to know that the services we provide through this vital work truly make a difference.

- Gabor,Stay at Work Services