Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Studio Assistant Senior Product Manager Business Intelligence Developer Developer Product Owner Product Owner Data Platform Developer Reporting Lead Developer BI Developer Back Programmer Business Intelligence Studio Assistant IT Programmer Specialist Statistical Programmer Product Marketing Specialist Agile Coach Director Software Engineer Junior Programmer Database Programmer Project Application Programmer Product Owner Digital Product Owner Agile Product Owner - Open Location Product Owner II Product Owner Product Owner Product Owner - Digital Channels Product Owner Product Owner Junior Software Tools Developer AGILE PRODUCT OWNER Account Manager Junior Java Developer Junior Fullstack Developer Junior Application Developer Angular Jr Junior Product Developer Junior Web Developer Software Engineer Intern - Slalom Build SOFTWARE ENGINEER Software Engineer Front-end Developer Intermediate Front End Developer Front End Developer Angular Developer Front-End Developer Newest Jobs
Companies
Yelp Two Sigma Brightenvantage international Business Consulting Inc. Moscleancom Sterling-Turner CareGuide CCLINKS TRADING LowCostWebDesignFirm.com Aecom Clearbanc Exact Media AsteroidX Storyboard That Canadian Embassy WeWork M*A*C - Southcentre Mall I Want What It's Worth Shopify First Convenience Bank The Youth Connection jobox.ai mappedin Aerotek Clickworker AT&T Insight Global American Income Life TD Bank Recovhub Amazon Flex Paylocity Creative Circle Microsoft ATI Physical Therapy Desjardins Vector Marketing Scotiabank Algolia Top Hat Unbounce CUCU Covers SnapTravel Kourts Hootsuite UFD Consulting Inc Athletic Alliance GoParkr Hinge JUUL Labs Doordash 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