Share this job

Business Intelligence Developer

Date: Mar 19, 2019

Location: Mississauga, ON, CA

Company: Hatch

Requisition ID: 17644 

Job Category: Information Technology 

Location: Mississauga, ON, Canada  


With over six decades of business and technical experience in the mining, energy, and infrastructure sectors, we understand that challenges are changing rapidly in every industry. We respond quickly with solutions that are smarter, more efficient, and innovative. We draw upon our 9,000 staff with experience in over 150 countries to challenge the status quo and create positive change for our clients, our employees, and the communities we serve.


This is an excellent opportunity for a creative developer who is eager to work on business intelligence and reporting solutions by turning low level data into insightful reports and dashboards. A proven track record of designing and producing meaningful and effective data visualizations.  You have been exposed to multidimensional databases (cubes), dashboards, scoreboards, SharePoint Online and Agile Development methodologies.  You are passionate about business intelligence technology and designing BI solutions that provide outstanding user experience.

You are strong technical leader in cloud data services, analytics, business intelligence and on-premise data platforms. You have an unique blend of technical expertise and business knowledge, and extensive experiences of bridging the gap between technology and business-driven goals.

Exposure to Azure Data Lake Store and Analytics, Data Factory, Analysis Service and Power BI is preferred. 



We are looking for a Senior BI Solution developer to add to our dynamic team.  The responsibilities of the role include:

  • Design and develop BI dashboards and reports based on business requirements
  • Implement, maintain and support BI solutions in Microsoft and other BI platforms
  • Work within an agile development team of developers and analysts and business stakeholders.  Complete committed backlog and sprints within the agreed upon timeframe
  • Read data from multiple data sources and transform, enrich and aggregate data for an efficient presentation in an enterprise environment
  • Provide input into the architecture, design and implementation of Hatch’s business intelligence solution
  • Recommend improvements to streamline processes regarding data flow and data quality to improve data accuracy, usability and value
  • Remain abreast of technology developments within fields relevant to current and future BI and Reporting initiatives
  • Write report specs to document “As Built’ reports deployed to production
  • Perform system testing of developed reports. Help with regress testing of reports during upgrades.



  • Passionate about business intelligence technology and designing BI solutions that will provide outstanding user experience
  • Strong knowledge and experience in analyzing as well as designing data models that meet the reporting needs
  • Experience in writing SQL relational and multidimensional database queries and slicing and dicing data models
  • Experience with Microsoft BI Stack (SSRS, SSIS, SSAS) and other BI stack of technologies
  • Ability to prototype and conceptualize the solution through visualization of data based on business requirements, using tools such as Microsoft PowerBI, Excel Power view, or other
  • Internally motivated and adaptable, able to work proficiently both independently and in a team environment.
  • Excellent listening skills and attention to detail and accuracy with demonstrated strong logical and technical problem-solving skills
  • Able to troubleshoot BI reporting and analytic business needs and provide solutions for issue resolution
  • Demonstrated ability to learn and adapt to new technologies quickly
  • Experience writing technical documentation that articulates the architecture and design of the solution
  • Familiar with information design concepts (UI/UX)


Required Experience

  • 3-5 years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling & data mining, reporting, report conversion and data cleansing.
  • Experience designing and developing dashboards and KPIs (Key Performance Indicators) using Power BI, MS SSRS,
  • Experience with the principals of developing data warehousing applications
  • Experience in the following technologies required:
    • MS Power BI, SSRS, MS SQL Server, Excel Macros
    • Azure Data Lake Store and Analytics, Data Factory, Analysis Service


Other Requirements

  • Working knowledge and experience in the following technologies an asset:
    • MS SharePoint online
    • MS Office 365 (Excel Power View and Power Query)
    • Visual Studio Team Server (VSTS)
  • Exposure to SAP Project Systems and Commercial Project modules (CPM) desirable
  • Experience working the Cloud platforms such as Microsoft Azure and AWS
  • Experience with Big Data Technologies
  • Experience with Agile/Scrum Software Development methodology and working within an agile team preferred
  • Proven strong communication and interpersonal skills with both team members and business stakeholders at all levels
  • Willing to work outside of normal business hours as part of a global team and to travel as required
  • Bachelor’s degree or equivalent combination of education, training or work experience




We are committed to fostering a workforce in each of our locations that reflects the diversity of the communities in which we operate. Hatch is an Equal Opportunity Employer that considers employment applicants without regard to age, race, colour, national origin, citizenship, religion, creed, sex, sexual orientation, marital status, disability or any other protected status. If you have any special needs requirements, please let us know. We will do our utmost to accommodate, in accordance with applicable local legislation. 

Job Segment: Business Intelligence, Developer, ERP, SAP, Database, Technology