Language: English only (French is an asset) Job location: Remote for now until things change; potentially back in the Toronto office Must have skills: SSIS .Net, C# Application development Experience with Git, GitHub What you’ll do - Design and develop innovative solutions for managing data integration between various data systems, platforms and file types - Design, build, deploy and maintain small to medium sized applications with focus on automation and efficiency - Load target databases using complex transformations that come from multiple systems - Lead data warehouse architecture design and build robust analytical data models for downstream reporting and analytics - Monitor and optimize ETL processes and data performance to ensure the stability of NBIN’s BI environment - Perform data analysis and data modelling to create functional design documents and source to target mappings - Be involved in discussing and collecting business requirements from stakeholders and translate to design and development specifications - Build reusable code and libraries What you bring to the team - University degree in Computer Science or any equivalent work experience - Minimum 7 years experience in a BI / ETL role or similar position - Minimum 5 years experience developing ETL solutions using SSIS - Extensive experience in SQL programming - Experience with .Net, C#, JavaScript, PowerShell programming languages - Experience with Microsoft Access DBs and VBA programming - Experience with application development (i.e. middleware, application design and backend development) - Experience using code repositories (Git, Github, CVS) - Extensive experience in the design of structures and data models - Experience in optimizing SQL queries - Experience working with cloud technologies such as AWS, Azure is preferred - Experience with big data technologies is an asset (i.e. Hadoop, Spark, Kafka) - A desire to learn new technologies, innovate and be creative in achieving goals
|