You're using an older version of Internet Explorer that is no longer supported. Please update your browser.

Business Intelligence Developer

Edmonton, AB
Full Time
7 days ago
Company: Finning International Inc.

Posting End Date: Sep 03, 2019

Number of Openings: 2

Worker Type: Permanent

Position Overview: You will play a key role in developing and maintaining Business Intelligence-related data integrations, Data Marts and Data Warehouses.

You will have the opportunity to work on all phases of development independently or in teams. This includes participating in the requirements definition, analysis, planning, selection, blueprint, design, development, implementation, and maintenance of data integration and data model solutions.

Job Description: Major Job Functions:
  • Partners with the business, including business analysts to create, review, or implement business requirements
  • Creates and maintains BI/DW ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows)
  • Design, develop, test, and deliver data warehouse solutions
  • Analyzing, troubleshooting and resolving of issues relating to data warehousing services including data movement, data quality, data cleansing and other ETL/ELT-related services
  • Providing 2nd and 3rd level technical support
  • Perform Conceptual, Logical, Physical, Multidimensional, & Hierarchical data modeling
  • Develop and maintain Extract, Transform, and Load processes across multiple data sources
  • Identify data discrepancies and data quality issues and work to ensure data consistency and integrity
  • Monitor system details within the data warehouse including stored procedures and execution time and implements efficiency improvements
  • Contribute to the continuous improvement/refinement of processes, tools, quality metrics, methodologies and standards
  • Performs other duties as required
  • Ensure reporting of progress and escalation of issues, based on guidelines established for workgroup or project and presentation of information is professional, timely and accurate
  • Ensures that work completed within scope satisfies the business and /or functional requirements provided and fits appropriately within Finning's preferred solutions architecture
  • Ensures that systems and changes implemented within scope do not expose Finning to unknown corporate risk
  • Create and maintain BI/DW ETL specifications and process documentation
  • Produces specification documentation that is of excellent quality, which is easily understood by the reviewers, approvers, and users of the material
  • Responsible for compliance with Finning's change-control processes related to the systems development life cycle

Specific Skills & Knowledge:
  • Customer-centric, collaborative mindset
  • Excellent verbal and written English communication skills and the ability to interact professionally with a broad group of technical and business subject matter experts
  • Proficiency in analytic and problem-solving skills, detail-oriented mind set and ability to manage multiple projects and priorities
  • Experience working in the Microsoft BI stack (SQL Server, SSIS, SSRS and SSAS)
  • Knowledge of Data Replication, CDC toolsets and methodologies
  • Database/data warehouse design and development skills
  • Experience with data manipulation and interrogation using SQL
  • Experience in designing ETL architectures and developing ETL processes
  • Good report and dashboard development skills (SSRS, Crystal Reports, PowerPivot, Excel)
  • Strong team support skills that promote cooperation and collaboration
  • Excellent time management, planning, and prioritization skills
  • Solid organizational, interpersonal and customer service skills
  • Ability to work with ambiguity
  • Strong work ethic and self-driven
  • Enjoy problem solving, creativity and challenging conventional solutions
  • Knowledge of data warehouse, data mart and database technologies, standards, and methodologies
  • Good understanding of database and data warehouse design theory (logical and physical)
  • Good understanding of DW processes and OLAP concepts, with star schema data models
  • Good understanding of ETL and ELT design and theory
  • Knowledge of Application Lifecycle Management Tools (ALM) used in tracking and monitoring the development lifecycle, such as TFS
  • Knowledge of integrating BI with Microsoft SharePoint 2010/2013
  • Knowledge of agile practices and methodologies
  • Knowledge of data lifecycle and industry standards
  • Experience with development for BI & analytic tools such as Tableau, SAP BusinessObjects, Cognos
  • Infor (Lawson) Business Performance Warehouse (BPW) experience an asset
  • Knowledge of Azure Data Factory, Azure SQL Database, Azure SQL Data Warehouse, Azure Platform and its IaaS/PaaS/SaaS offerings are assets
  • Understands and adheres to Finning policies and procedures, including safety

Education & Experience:
  • CBIP certificate/TDWI education; degree/diploma in computer science or a technology-related field, or equivalent proven work- or education-related experience
  • Strong requirements gathering, decision making, project management, problem solving, and investigative skills
  • Full life cycle experience (requirements gathering through production deployment) in all aspects of BI/DW (ETL, data modeling, analytics and reporting)
  • 4 - 6+ years of experience designing and developing complex database solutions using Microsoft BI stack
  • 4+ years of experience with the Microsoft Business Intelligence stack including Analysis Services, Integration Services, and Reporting Services
  • Expertise in working closely with business and IT stakeholders to define problems and design large-scale, enterprise class solutions in a leadership role
  • This role can be based in either Edmonton, Calgary or Vancouver.

W e are committed to diversity at Finning, to building and sustaining a diverse and inclusive workforce and as an equal opportunity employer we encourage applications from all qualified individuals. Finning does not discriminate against applicants based on genders, races, national and ethnic origins, religions, ages, sexual orientation, marital and family status, and/or mental or physical disabilities.
Information Technology