Job Title

Number of Positions: 1 Duration: 5 months initial contract, possible extension Location: North York, ON, CA Must be eligible to work in Canada. Hybrid position 2-3 days per week onsite, no exceptions. In-person interview required. Roles and Responsibilities The Data Engineer is responsible for the development of highly scalable ETL and data flow applications adhering to software development best practices. This position requires advanced SQL scripting and data visualization skills. The person will design data warehouses in modern columnoriented database systems and develop data reporting solutions. The position will be part of the IT Canada Analytics team and will work closely with architects, Scrum Master, and other members of the team and business partners in a highly collaborative environment. Develop ETL processes delivering highquality code, following coding best practices. Create and implement complex analytical data models that support reporting and analytics business requirements. Prepare test scripts and perform functional unit, integration, and regression testing. Coordinate and drive user acceptance testing. Support and troubleshoot issues/bugs in data pipeline and SQL for analytics. Analyze the use of data, design and create data marts based on requirements. Design and build reporting solutions. Experiment with new/emerging technologies in the space and conduct POCs. Work with functional/business resources to understand business requirements and processes. Work with Technical Lead/Architects to identify solutions/designs based on business requirements. Provide status reports to Manager/Leads during task execution. Follow the client's IT standards to deploy code to production environments. Must Have Skills / Experience / Qualifications 58 years of Data Engineering development experience and best practices. Experience in data completeness and accuracy checks and setup. Accomplished expert SQL skills, including data management, mining, and modeling. Advanced SQL knowledge, database and data modeling expertise. Strong business acumen, understanding of data and information. Experience in Google Cloud Platform, especially BigQuery, Airflow, Pub/Sub, and Dataflow (preferred). Excellent communication skills. Demonstrated ability to write technical documents. Ability to communicate issues and recommend solutions in a timely manner to Management. Retail experience will be considered an asset. Ability to adapt quickly to new technologies and development practices. Experience with a variety of database platforms and technologies. Seniority Level MidSenior level Employment Type Contract Job Function Information Technology Industries IT Services and IT Consulting, Retail, Transportation, Logistics, Supply Chain and Storage #J-18808-Ljbffr