This job board retrieves part of its jobs from: Human Resources Jobs | Toronto Jobs | Work From Home

The top job offers in Canada!

To post a job, login or create an account |  Post a Job   

A simple jobs board with daily updated offers from Canada

previous arrow
next arrow

Blue North Strategies: Data Specialist

Blue North Strategies

This is a Full-time position in Guelph, ON posted January 18, 2021.

The role of Data Specialist is to receive various data, validate, adjust, and process to support various non-profit marketing campaigns and various departments.

You will work with project managers to ensure their data processing needs are met, provide answers to client questions, be a detective in understanding problems and find solutions.

Think: somewhere between designing databases and data entry.To be successful, the employee must be competent and confident with data manipulation, on the fly; and excellent communication skills.About Blue North:We are a leading Canadian agency, who helps our non-profit clients in the international development, healthcare, environmental sectors – effectively raise funds, to make our world a better place.

We are unique in that there is no one like us who can bring together, direct marketing, donor-centric fundraising, production, data and strategy.We are passionate about our clients’ work and the good they want to achieve.

We are always thinking of new ways to help them achieve their goals.Responsibilities:Provide support and programming to all aspects of data from: reporting, analytics, troubleshooting, updating, importing/exporting and transforming data Complete documentation, transmission, and validation of client data Understand and perform required data transformations within an SQL Server environment using SSMS, SSISSet-up each job for data processing, trouble-shoot and enhance when requiredSupport the management of our SQL Server and Access databases Knowledge and ExperienceDiploma/degree in Computer Science, Information Technology, or sufficient experience in a related fieldExperience building, using, and monitoring data integration (ETL) workflows from multiple sources including but not limited to databases (MSSQL, MYSQL, other), flat files, JSON/XML, APIsSolid experience in writing and optimizing ANSI SQL to support analysis, report design, and other specialized data management functionsExcellent communication and collaboration skills, exercising sound judgement in client engagement with ability to act professionally with all levels across the organizationWorks well with minimal supervision in a dynamic environment with shifting prioritiesExperience in any of the following would be considered an asset:Experience with Microsoft SSMS, SSISExperience with Visual Studio or similarAdvanced level Excel, including Pivot Tables, Charts, and advanced functionsExperience with Amazon Web Services (AWS) environmentPython programming experience designing & deploying ETL workflows, microservices, APIs, and web interfacesVariable print composition or personalized digital campaigns1-3 years of experience, preferably in an agency or fundraising environmentReporting Structure:To be determined