Business Intelligence Developer

Client: Tech Consulting

Role: BI Developer

Job Type: Contract (6 months), possible extension

Location: Hybrid in Toronto

Your New Company

Our client, a very well-known global company, hired a Business Intelligence Developer for a 6-month contract.

Your New Role:

This position exists to drive optimization of contract performance efficiency and profitability using data performance measurement systems, specifically…

• Create business intelligence tools and reports, such as physical data models and dimensional analyses.

• Design, code, test, and aggregate results from SQL queries to provide actionable information to users.

• Create and modify an enterprise resource planning (ERP) system of integrated applications in ServiceNow to manage the business and automate office functions. Drive continuous service delivery and productivity improvements.

Responsibilities:

· Data Mining: Accessing raw data sources (QMatic, Scheduler, CostPoint etc. to extract data required for analysis/ business improvement purposes.

· Data Formatting & Design: Translation of raw data into an intelligible format to facilitate analysis or for direct reporting. Design, build and deploy BI solutions (automation of NIs to DT websites, extended hours invoicing, KPI monitoring systems, employee performance monitoring, etc.) using ServiceNow or other BI tools. Create event server, custom objects, reporting, data archive, schedule tasks, database tasks. Create tools to store data (e.g. SQL tables, OLAP cubes). Develop, implement, and optimize stored procedures, triggers and functions using T-SQL.

· Data Analysis: Interpretation of formatted data to identify trends & areas requiring further investigation with a view to solutioning. Review and interpret ongoing business report requirements. Build appropriate and useful reporting deliverables. Analyze existing SQL queries for performance improvements.

· General Reporting: Ensure problem-free generation of regularly scheduled reports (various KPI reports and other internal reports) and timely generation of ad-hoc reports. Oversight of all reports with a standing objective of reducing report volumes and automating them wherever possible.

· Business Intelligence Development & Maintenance: Ongoing development of Power BI or other DES business intelligence tools i.e. development of screens/ dashboards/ reporting as required and routine maintenance tasks (access controls, account creation/ resets etc.).

· Solution Development: Application of objective disciplines to determine possible improvement actions and set improvement targets/ timelines.

· Solution Driving: Development of roll-out plans, stakeholder dialogue, communications and implementation plans for proposed solutions.

· General:

o Generate analyses and reports for both contractual compliance, identification of business improvement opportunities and Group obligations.

o Assist with the provision of technical/ other support in the development of user specifications and design of programs to improve service delivery.

o Participate in departmental, cross-functional and customer meetings and working groups as required.

o Provide cover for, and assistance to, the Business Improvement Analysts as directed.

o Other related duties relevant to this position as may be required.

What You’ll Need to Succeed:

· Knowledge of BI technologies (e.g. Microsoft Visual Studio, Power BI including advanced Excel, ServiceNow)

· Proficient in the Microsoft SQL platform with extensive knowledge of SQL, T-SQL development (SSIS, SSAS, SSRS and Power BI).

· Background in data warehouse design (e.g. dimensional modelling) and data mining.

· Experience developing workflow apps in ServiceNow

· In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.

· At least 3–5 years of analytical experience, preferably within a large organization, dealing with large data sets.

· Experience working directly with business users to build reports, dashboards and solving business questions with data.

What You’ll get in Return

The client is offering a 6-month contract assignment.

Interested? If you’re available and interested in this role, please reply to Shivangi.gupta@hays.com as soon as you can attach your updated resume.