Job Title: Junior Data EngineerLocation: Winnipeg, MB/Toronto, ON (Hybrid - 3x Onsite a Week)Employment Type:
Contract OpportunityJob DescriptionThe Data Engineer is responsible for supporting the design and development of ETL/ELT code that extracts and manipulates data from a variety of complex sources and populates the Enterprise Data Warehouse including new and legacy sources transitioning from legacy reporting environmentsInterface with BSAs, solution designers, data architects, and other business stakeholders to understand the business requirementsAssist with analysis and profiling of various source data and understand high level relationships between data sourcesParse unstructured and semi-structured data such as JSON, XML…etc.
,Design & develop efficient mapping and workflows to load data onto Data MartsDesign and develop ETL/ELT pipeline for CI/CDDevelop, test and document ETL/ELT solutions in a complex data warehouse environment with numerous desperate source systemsUse MS SQL Server 2012, Snowflake and SSIS/ADF/DBT for data integration, Control-M for package scheduling and TFS or Azure GIT repository for version control and task managementPerform DB modifications in accordance with team processes and standards
Customize your resume to highlight skills and experiences relevant to this specific position.
Learn about the company's mission, values, products, and recent news before your interview.
Ensure your LinkedIn profile is complete, professional, and matches your resume information.
Prepare thoughtful questions to ask about team dynamics, growth opportunities, and company culture.
