Manager, Data Engineering
Yoush Consulting • Toronto, Ontario, Canada
30+ days ago
Job type
- Full-time
Job description
Welcome to Yoush Consulting. Yoush Consulting provides project management and information technology expertise to help our clients deliver their projects. Our client is looking to hire a Manager in data Engineering and we are helping them find an excellent one.
Azure DevOps Engineer with D365 and F&O experience - As a Data Engineer, you will be responsible for building and maintaining the systems and processes that allow for the extraction, transformation, and loading (ETL) of data from various sources into our Azure-based data ecosystem.
Responsibilities: Manage, guide, and assist a team of data engineers to provide:
- Provide adetailedreviewandassessmentoftheenterprisedatawarehouseenvironmentand proposed changes and implementation plan to improve scalability and performance
- DesignanddevelopSSISETLprocessusingtablepartitioningwithafocusonperformance improvement of large tables
- DesignanddevelopPowerBIreportstoshowSSISpackagerundurationandtrendovertime
- Perform dataanalysisandprovidedsuggestionsandfeedbacktotheteamtodesignand develop optimized SQL Queries andStored Procedures (SCD Type1, SCD Type2 using Hash bytes) to improve performance
- Designandimplementanoperationalprocesstoprovideahigh-levelsummaryofSQL Server and database environment to assist in the upgrade and migration of SQL Server databases to newer versions