Senior BI Analyst/Data Analyst

The Senior BI Analyst / Data Analyst will contribute to

the design, development and maintenance of strategic, high-profile

executive-level dashboards / reports and will play a key role in

developing database objects, metrics, dashboards / reports using

Microsoft BI technologies (SQL Server 2016 Enterprise, Power BI,

SSIS, Excel, etc). They will also assist business in developing

business cases and forecasting / planning using data from data

warehouses. • Design, develop and maintain data warehouses to

integrate data from the most appropriate data sources to ensure

accurate and timely reporting. • Design, develop and maintain Power

BI dashboards / reports. • Develop data models and schemas to

accurately represent structured and unstructured raw data in

databases • Transform raw data into preprocessed data to be used in

generating actionable insights • Proactively seek to understand

end-user requirements in order to implement effective data

visualizations in dashboards / reports. • Proactively seek

opportunities to automate the most time and resource intensive

processes related to data collection validation, transformation,

etc. to optimize the production and delivery of dashboards / reports.

• Contribute to the design and implementation of branding (i.e.,

standardized “look and feel”) for all dashboards / reports. • Assist

in the development of a future state BI architecture and roadmap. •

Help investigate and diagnose issues and ensure problems and

defects are resolved in a timely manner. • Analyze data for trends

and building analytical models to determine revenue opportunities,

minimize risk and assist business in financial modelling for

business cases, compensation plans, sales targets, etc. • Manage

the Planning and forecasting process • Play lead role in analytics

requirements of business. Qualifications • 5 years hands-on

technical Business Intelligence experience with advanced knowledge

in Microsoft BI technologies (SQL Server, Power BI, Power Pivot,

Visual Basic). • Advanced knowledge of Excel and reporting tools,

VB, relational database tools such as Access. • Designing ETL

processes, including development of relational data model • Strong

SQL skills, including common table expressions, window functions,

joins, complex data types, stored procedures and update scripts •

Experience in building and updating SSIS ETL workflows • Ability to

analyze large data sets • Developed financial models and analyses

relating to Plan and Forecasting, business cases • Excellent

interpersonal, communication and negotiation skills. • Ability to

work effectively in a self-directed manner and also as part of a

project team. • Ability to effectively handle ambiguous, ad hoc

tasks and changes in direction and priorities in response to

unexpected events and circumstances. • Experience with other BI

tools such as Tableau, MicroStrategy, etc. is an asset • Experience

with Cloud technologies (e.g., Microsoft Azure, AWS) is an asset

This is permanent position located in Toronto. Hybrid position work

from home 3-4

days / week.

J-18808-Ljbffr