Closing Date: August 31, 2020
Reporting to the Software Development Manager, the Business Intelligence Developer will be responsible for developing Power BI dashboard solutions for Operations personnel at mines in central and south-eastern BC that will empower mines to deliver significant cost reduction and productivity improvements. As a Developer, you will collaborate with Delivery Specialists to employ data from on-prem sources as well as from cloud providers (Google Cloud Platform, Azure) to build reporting solutions targeting Reporting Services On Prem as well as Power BI Service. The BI Developer will construct back-end SQL queries, shape queries with M-Query, build coherent tabular models, construct calculated data elements in DAX, and ultimately building elegant, efficient dashboards that solves real world problems. The Developer will work with Product Owners and operations personnel to refine visualizations based on in-field testing and may train end users on how to interact with the solutions. The analyst will work closely with Teck’s Agile-based advanced analytics development teams and source data system owners as part of a consolidated value delivery team. The successful candidate must be comfortable traveling to operations and being exposed to industrial settings.
Be a courageous safety leader, adhere to and enforce safety and environmental rules and procedures !
Be a contributing member to an Agile team passionate about delivering valuable reporting solutions to Teck mining sites
Participate in project planning sessions with project managers, business analysts, and team members to analyze business requirements and outline the proposed solution
Enhance, improve, and optimize existing Power BI reports
Develop technical specifications based on business requirements
Have an eye for design and be able to produce beautifully crafted reports attending to small design details (e.g. alignment, font selection, colour selection, readability, data design principles)
Perform data validation to ensure data correctness
Design and development using best-approaches for data management and visualization
Use source control (GitHub) for version control
Continuous learning to keep your skillset sharp in a rapidly evolving technical area
Minimum two years’ experience in building various BI solutions with a focus on Power BI reporting
Advanced SQL skills. Ability to construct complex SQL queries to collect and shape data from relational databases, including performance troubleshooting
Able to use DAX to construct calculations in Power BI including a knowledge of DAX functions for building measures, calculated columns, and tables and understanding of what kinds of problems are appropriate to each of these
Advanced Power Query and M-Code skills to craft datasets
Knowledge of Power BI ecosystem including reporting constraints with Power BI service, Licensing options, Data Gateways, Workspaces, Apps, Dataflows
Familiarity with Star Schema data models
Utilizes experience in database concepts, data modeling, data integration including design and architecture
Ability to develop and maintain Extract, Transform, and Loading (ETL) processes
Experience creating data analytical capabilities by using SQL Server OLAP, SSIS (SQL Integration Services), SSAS
Ability to comprehend business drivers and challenges faced by clients
Effective verbal communication skills including the ability to explain technical concepts to clients
Personable and interacts in a cordial manner. Effective results-focused team and cross-team player
Bachelor’s degree or diploma in Computer Science, or equivalent
Mining Industry experience an asset
A valid driver's licence might be required
Ability to travel to our sites in British Columbia 5-15% of the time
At Teck, we value diversity. Our teams work collaboratively and respect each person’s unique perspective and contribution.
Qualified applicants interested in joining a dynamic team are encouraged to submit a resume and cover letter electronically.
We wish to thank all applicants for their interest and effort in applying for the position; however, only candidates selected for interviews will be contacted.
Your application to this posting is deemed to be your consent to the collection, use and necessary disclosure of personal information for the purposes of recruitment. Teck respects the privacy of all applicants and the confidentiality of personal information.
Teck is a diversified resource company committed to responsible mining and mineral development with major business units focused on copper, steelmaking coal, zinc and energy. Headquartered in Vancouver, Canada, its shares are listed on the Toronto Stock Exchange under the symbols TECK.A and TECK.B and the New York Stock Exchange under the symbol TECK.
The pursuit of sustainability guides Teck’s approach to business. Teck is building partnerships and capacity to confront sustainability challenges within the regions in which it operates and at the global level. In 2019, Teck was named to the Dow Jones Sustainability World Index (DJSI) for the tenth straight year, indicating that Teck’s sustainability practices rank in the top 10 per cent of the world’s 2,500 largest public companies in the S&P Global Broad Market Index.