Share this job

Power BI Report Developer

Apply now »

Date: Jan 24, 2021

Location: Mississauga, ON, CA

Company: Hatch

Requisition ID: 32263 

Job Category: Information Technology 

 

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.


We are looking for a Senior BI Solution developer to add to our dynamic team. The Business Intelligence developer is responsible for designing and producing meaningful and effective data visualizations. As a Business Intelligence developer, you will work with other team members, including System Architects, system developers and business representatives. Primary direction will come from business representatives relative project and client.  


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
  • Complete committed backlog and sprints within the agreed upon timeframe 
  • Curate data from multiple data sources for an efficient presentation in an enterprise environment
  • 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
  • Document “As Built’ reports and all data transformations deployed to production
  • Take ownership of end-to-end development of each dashboard and report being developed
  • Perform system testing of developed reports. Help with regression testing of reports during upgrades


Qualifications and Experience 

  • 4 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. 
  • Exposure to multidimensional databases (cubes), dashboards, scoreboards, SharePoint Online and Agile Development methodologies.  
  • 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
  • Advance knowledge of writing complex SQL queries
  • Strong Power BI experience (Power Query, DAX, Power Bi Services)
  • Experience with Microsoft BI Stack (SSRS, SSIS, SSAS) and other BI stack of technologies
  • Experience with Microsoft Azure data analytics tools, such as, Azure Data Factories, Azure Databricks, Azure Synapse
  • Ability to prototype and conceptualize the solution through visualization of data based on business requirements, using tools such as Microsoft Power Bi, 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
  • Experience designing and developing dashboards and KPIs (Key Performance Indicators) using Power BI, MS SSRS.

 

Experience in the following technologies required:
o    MS Power BI, SSRS, MS SQL Server, Excel Macros
o    Azure Data Factories, Azure Data Lake, Azure Databricks, Azure Synapse, Azure DevOps

 

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, Database, SQL, Programmer, Technology