Sr. Enterprise Information Management Analyst
Samuel, Son & Co.
Mississauga, Ontario, Canada
2 months ago

Job Description :

The individual will be designing and implementing enhancements to the Samuel One EDW, cubes as well as developing Business intelligence reports using BI tools.

As a Senior EIM analyst you will report to the Manager Enterprise Information Management.

Responsibilities : Operational Management

Operational Management

Design and develop cubes (i.e. Tabular and multi-dimensional)

Develop and maintain Business Intelligence reporting and Samuel One Enterprise Data Warehouse.

Scope, plan a variety of reports, analytics, dashboards, and metrics using Microsoft Power BI and SSRS.

Extensive experience with developing and implementing complex ETLs using SSIS.

Actively validate data being retrieved from source systems.

Design and configure Samuel corporate reporting portal.

Gather business requirements and determine business needs and scope for projects.

Liaise with technical and non-technical departments to create an effective end user experience.

Monitor report usage and speed to attain the highest level of achievable performance.

Maintain and troubleshoot Samuel enterprise data warehouse.

Actively participate in any corporate reporting portal upgrades.

Team Development

Provide training to EIM team on developing BI dashboard / reports

Provide training to end users on performing self-serve reporting / analytics

Time Management

Reacts to time sensitive issues when problems occur

Complete assigned tasks / projects within due dates

Increasing BI / Sigma Effectiveness

Have an active relationship with key business leaders to determine pain points" and actively develop reporting solutions.

Stay current with industry trends, advise and educate management on their relative importance and impact

Identify data patterns and data insights that could help with metrics and reporting

Project Management

  • Assist with project management activities
  • Qualifications :

    Bachelors in Computer Science (or equivalent combination of education and experience)

    Extensive experience and passion for business intelligence and data warehousing.

    Experience in the metal manufacturing and / or distribution space would be considered a definite asset.

    Knowledge and understanding of ERP systems is required, however Microsoft D365FO would be preferred.

    Excellent oral and written communication skills are a must to succeed in this position.

    Ability to learn quickly inside of a team environment.

    Must have at least 7 years' experience working with SQL language and SQL Server 2012 / 2016 BI stack :

    SSIS (Developing ETLs)

    SSAS (Tabular models and Multi-dimensional OLAP cubes, DAX and MDX scripting)

    and SSRS.

    Must have experience with tabular cube builds in SSAS.

    Must be able to gather business requirements from end users

    Must have experience with Microsoft Power BI or similar BI tool, i.e. Microstrategy.

    Ability to program in XML, CSS, .NET and web based languages would be an asset.

    Flare for presenting information to a variety of users.

    Ability to work in a fast-paced environment.

    Highly motivated self-starter with the ability to interact effectively with team members and business users.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form