Peersight
Log In Employers
Explore
Jobs
Jobs
Customer Success Manager Key Account Manager Digital Marketer - Generalist - Contract Human Resources Assistant Retial Sales Associate Director Train Control Engineer Account Development Executive Ingenieur qualite Ethics Commissioner Site Inspector Entry Level Sales Sales Vice President - Transit and Light Rail Android Developer Associate Brand Manager Senior Software Developer AX Customer Service Representative Senior Consultant - Monitoring Tools Senior Sales Executive Developer Geospatial Metadata Coordinator Festival Marketing Intern - Winter Term Product Director Health and Dental Assistant Manager Independent Scientist NEW Junior Product Manager Communications Coordinator Market Development Manager - Hamilton Equity Research Analyst - Global Vice President JavaScript Developer B2B Sales Representative Senior Developer - Sr Data Engineer SoC Design Engineer Software Engineer Business Development Associate UX Account Executive-Sales and Business Senior QA Engineer Senior Database Engineer Recruiter Marketing and Events Specialist Sales associate - Downtown Toronto Account Manager Senior Machine Learning Engineer Senior Static Equipment Engineer All Jobs
Companies
0x 10% Happier 101 Commerce 1010data 10x Genomics 11 Honore 128 Technology 1366 Technologies 15Five 17 Media 17zuoye 1C Company 1Crowd 1HUDDLE 1QBit 1World Online 1mg 1stdibs 21viaNet 23andMe 2C2P 2RedBeans 2U Inc. 2lemetry 2nd Address 360 Mobile Security 36Kr 3D Robotics 3D Systems 3Pillar Global 3Scan 3T Biosciences 3VR 3YOURMIND 4:33 Creative Lab 4INFO 500 Startups 500px 51 Credit Card Manager 51talk 55ip 58 Daojia 58.com 5miles 6 River Systems 6sense 7Park Data 7k7k.com 7shifts 8 Securities 82 Labs Inc. 8btc.com 8i 8th Wall 8tracks Radio 8x8 Inc 90 Seconds 908 Devices 91springboard 99 9F Fintech Holdings Group 9stacks A Million Ads A10 Networks AB Tasty ABBYY ABEJA ABSENTIA ACL Services ACORN OakNorth Holdings Ltd. ACV Auctions ADC Therapeutics ADENTS HTI ADOR ADP ADVANO ADYOULIKE AEVI International AEye, Inc. AGNC Investment AID:Tech AISense Inc. AISpeech ALPHA AND CO AOptix Technologies APDM Wearable Technologies APUS Group AQMETRICS ARMO BioSciences ASR Microelectronics AT&T AT&T ATI Physical Therapy AUTO1 Group AV Homes AVG Technologies AWAL AYLIEN AYR Aahaa stores All Companies
Navigation
My Profile Log Out

Senior SQL Developer At Arobas Personnel inc.

Location

Montréal, Qc

Job Description

Arobas Personnel is looking for a senior SQL developer for a full-time position at one of its clients in Montreal.

Position purpose
Reporting into the Senior Director, Analytics and Reporting (Reach and Response), the Senior SQL Developer will be primarily focused on the automation of manual reporting tasks in SQL Server Reporting Services.
Using stored procedures based on existing data queries in data warehouses, the Senior Developer will be tasked with creating automated and/or self-service reports for the Business Units of the business.
In addition the role will support the Reach and Response team with any data requirements they may need from the data warehouse.

What you will do:
  • Automate manual reporting tasks using data warehouse tables by creating stored procedures to deploy reports on SQL Server Reporting Services and/or Tableau.
  • Ensure the delivery of pre-scheduled Business Unit data analysis and its ongoing development.
  • Ensure the delivery of client data analyses and program data, according to predetermined schedule and client specifications.
  • Lead the development and implementation of new analytic methodologies and solutions, focusing on report automation.
  • Proactively identify opportunities to apply business intelligence to improve business performance.
  • Proactively identify opportunities to improve underlying data structures.
  • Effectively communicate results and recommendations to senior management.
  • Create stored procedures to produce reporting metrics from data warehouse tables.
  • Assist in maintaining the data warehouse environment.
  • Supporting Project Manager and Program Co-ordinators with creating queries to help them pull ad-hoc data requests.
Who you are:
  • Advanced knowledge of SQL specifically MS-SQL Server, MySQL and Amazon Redshift.
  • Advanced knowledge of deploying reports on SQL Server Reporting Services.
  • Advanced knowledge of creating Stored Procedures.
  • Analytical/logical mindset.
  • Solid team player – able to work efficiently with multiple groups within the team.
  • Advanced proficiency in Excel – able to synthesize and analyze large data sets to yield actionable findings (e.g. Lookup formulae, pivot tables and Macro creation).
  • Relevant Bachelor’s degree
  • 3-4 years minimum in a similar role
  • Strong communication and time management skills
  • Data warehouse/modeling experience
  • Experience with Tableau Reporting is an asset

Get hired at Arobas Personnel inc.

You're one short application away from your dream job