This site uses cookies. To find out more, see our Cookies Policy

Business Intelligence ETL Developer in Waterloo at Procom

Date Posted: 7/20/2018

Job Snapshot

Job Description

Job ID: 255689

Business Intelligence ETL Developer  Procom KW is actively looking for a strong Business Intelligence ETL Developer to work with our multi-national financial services client based in Waterloo, ON., but remote work is an option with trips to the office as required.

Business Intelligence ETL Developer Job Details

Based in Waterloo, ON., the successful individual will be responsible for aggregating data from multiple sources and designing enterprise-level reporting solutions.

Business Intelligence ETL Developer Responsibilities

  • Ability to create an architectural roadmap for a legacy ETL / DW solution - i.e. identify architecture end state and create a plan to modify the components in a way that is not disruptive to the business;
  • Experience delivering BI solutions using SCRUM;
  • Designing and planning BI Reporting solutions;
  • Debugging, monitoring and troubleshooting BI solutions;
  • Creating and deploying reports;
  • Writing relational and multidimensional database queries;
  • Configuring, deploying and maintaining database servers.

Business Intelligence ETL Developer Mandatory Skills

  • Undergraduate or Graduate degree in Computer Science/Engineering, Math, Engineering, or similar;
  • 5+ years experience with ETL development and SQL Server including SSIS, SSRS, and SSAS (OLAP and Tabular);
  • Ability to write complex SQL, MDX and DAX queries;
  • Experienced developer using Tableau and/or Power BI (PowerPivot, Power View, Power Map);
  • Developing mobile reporting solutions in Tableau / PowerBI;
  • Applies best practices when joining and transforming data in Tableau / PowerBI to ensure optimal performance and user experience;
  • A knowledge of Javascript, HTML5, C#, Java, Python, and RESTful web services is beneficial for integrating reports into other applications;
  • Source control experience with Git, SVN or TFS;
  • Ability to Travel outside Canada;
  • Great communication skills both verbally and in writing. The bulk of the user base is located out of the country.  Communication skills are extremely important.

Our client's mantra is succeed or fail as a team!  We are looking for individuals who will make their team stronger and help ensure success:

  • You thrive while working inside a team;
  • You have directly experienced the benefit of using Scrum and are a champion of the process;
  • You are a vocal advocate for best practices, new technology and approaches; 
  • You feel strongly that constant face to face communication is the best way to express ideas and solve problems;
  • Ability to work under pressure alone and/or within a team;
  • Strong communication skills and willingness to take initiative;
  • You are not afraid to ask questions or challenge the status quo;
  • You actively keep your technology skills current by investing time examining new exciting technology, platforms and different approaches;
  • You embrace change;
  • You are constantly looking for ways to improve.

Business Intelligence ETL Developer Nice to Have Skills

  • Understanding of Re-insurance;
  • Astera Centerprise ETL Tool experience.

Business Intelligence ETL Developer Start Date


Business Intelligence ETL Developer Assignment Length

6 month contract, initially.