Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Truck Driver Position Occupational Therapist 0 0 PR Digital Marketing Intern Delivery Driver Paid Healthy Trial Participant Paid Clinical Trial Participant Paid Research Participant BairesWash Incorpora Personal Para Software Developer Bread Baker Dental Receptionist-Full Time Driller Delivery Driver Carpenter Bud Tender Hiring Mortgage Agents and Brokers Marketing Assistant Amazon Picker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Immediate Amazon Order Packer Seasonal Full-Time Warehouse Team Member Amazon Picker Amazon Warehouse Associate Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Picker Amazon Warehouse Associate - Immediate Amazon Picker Full-Time Warehouse Team Member Amazon Picker Amazon Picker Amazon Warehouse Worker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Free Amazon Warehouse Worker Amazon Warehouse Worker Amazon Warehouse Associate Amazon Order Packer Amazon Warehouse Associate - Free Seasonal Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Warehouse Worker Full-Time Warehouse Team Member Amazon Warehouse Worker Newest Jobs
Companies
Yelp ContactMonkey CareGuide Clearbanc Sterling-Turner Exact Media Aerotek Two Sigma Aecom Peel Regional Police AsteroidX Akira Jane Street Borrowell Insight Global WeWork Shopify First Convenience Bank American Income Life Doordash Amazon Flex Square Microsoft AT&T Instacart Clickworker Vector Marketing Scotiabank Creative Circle Hatchways Walgreens UnitedHealth Group Recovhub LowCostWebDesignFirm.com Desjardins CI&T mappedin 51talk Top Hat Checkout 51 Paylocity Mobeewave TD Bank The Youth Connection Hootsuite SnapTravel ScribbleLive autoTRADER.ca GoParkr Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Senior SQL Developer At Arobas Personnel inc.

Location: Montréal, Quebec

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