Job Description

Business Intelligence Developer/Architect

Join a thriving and growing international firm, leader in their field. Excellent benefits, work environment, sophisticated tech department as a Business Intelligence/Analytics Architect. This is an ETL focused back-end Solutions Architect role. We currently have an exciting opportunity available for an experienced Business Intelligence Developer who is passionate about the work they do. Come work with a team of experts in the field.

The ideal candidate will need to be able to work within a small team and produce high results. The candidate will be involved in new development along with maintaining existing reporting systems.

Responsibilities:

  • Design, implement, and maintain data warehouses using SQL Server Replication, SSIS, SSAS, and T-SQL scripting
  • Work with business stakeholders to create and maintain reports in SSRS using relational and SSAS data sources
  • Create ad hoc reports, including the extraction of client demographics and retention statistics based on various client and service usage attributes
  • Provide database administration support during deployments and migrations
  • Mentor others on a wide range of database and analytic techniques
  • Gathers requirements, analyzes, creates design documents, and performs impact analysis
  • Develops Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources
  • Evaluate data systems, operations, and organizational aspects of various departments, and make recommendations
  • Build database models, dashboards, reports, interfaces for BI packages
  • Identify data security issues and recommend solutions

Job Requirements:

  • 5+ years of experience using Microsoft SQL Server BI Suite
  • SQL Server 2016 –T-SQL, SSAS, SSRS, SSIS
  • 5+ years of experience with data warehouses, data marts, dimensional modelling and OLAP technologies
  • Experience building Reports, Scorecards and Dashboards
  • Experience in Power BI a plus
  • Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly
  • Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem-solving skills

Experience:

  • T-Sql: 3 years (Preferred)
  • SSIS: 2 years (Preferred)
  • Data warehouses: 5 years (Required)
  • SQL: 4 years (Preferred)
  • SSAS: 2 years (Preferred)

 

Job Type: Full-time

 

 

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online