<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=471401956921649&amp;ev=PageView&amp;noscript=1">
Careers Header.jpg

DATA SPECIALIST

data specialist

Job Description

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.

 

Summary of the role

The role of Data Specialist is to receive various data, validate, adjust, and process to support various marketing campaigns and 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.

 

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, SSIS
  • Set-up each job for data processing, trouble-shoot and enhance when required
  • Support the management of our SQL Server and Access databases

Knowledge and Experience

  • Diploma/degree in Computer Science, Information Technology, or sufficient experience in a related field
  • Experience building, using, and monitoring data integration (ETL) workflows from multiple sources including but not limited to databases (MSSQL, MYSQL, other), flat files, JSON/XML, APIs
  • Solid experience in writing and optimizing ANSI SQL to support analysis, report design, and other specialized data management functions
  • Excellent communication and collaboration skills, exercising sound judgement in client engagement with ability to act professionally with all levels across the organization
  • Works well with minimal supervision in a dynamic environment with shifting priorities
  •  

Experience in any of the following would be considered an asset:

  • Experience with Microsoft SSMS, SSIS
  • Experience with Visual Studio or similar
  • Advanced level Excel, including Pivot Tables, Charts, and advanced functions
  • Experience with Amazon Web Services (AWS) environment
  • Python programming experience designing & deploying ETL workflows, microservices, APIs, and web interfaces
  • Variable print composition or personalized digital campaigns
  • 1-3 years of experience, preferably in an agency or fundraising environment

 

Reporting Structure

To be determined


Are you the fit we’re looking for? Don’t wait - Apply today! Please email your resume to careers@bluenorth.ca