Jobs In Calgary | Jobs In Vancouver | Jobs In Montreal Oil Rig Jobs

job title, keywords or company                    
city, state or zip                  jobs by job search
what where
job title, keywords or company
city, state or zip jobs by job search


full time Intermediate DWBI Consultant

at XBASE Technologies in Toronto

Data Warehouse and Business Intelligence Consultant works with other consultants to support the solutions XBASE provides to our clients: Data Warehousing, Business Intelligence, Master Data Management, Data Quality, and Data Integration. Each project is unique and requires support in areas such as management, development, reporting, analysis, and quality assurance.

You will be responsible for:

  • Develop organic and functional deliverables;
  • Develop reports, dashboards, and analysis;
  • Ensure that BI best practices are used;
  • Develop multidimensional cubes or dimensional models;
  • Create and perform scenarios for unit testing, functional testing, and integration testing;
  • Optimize the performance of queries needed for the deliverables;
  • Ensure that technical documentation is produced for products;
  • Work in close collaboration with the customer team in order to strengthen the business partnership
  • Identifying client issues where Business Intelligence can deliver tangible benefits, shaping solutions and using them to deliver rapid improvements in performance to meet business needs
  • Business analysis – engaging with client stakeholders at all levels, in both business and IT to drive out and prioritize requirements
  • Designing and delivering Business Intelligence solutions for clients, utilizing the full Microsoft Business Intelligence stack; including ETL, data warehousing, OLAP and reporting/analytics tools, and associated infrastructure considerations
  • Data management design, including the description of data models, processes, and high-level architectures including enterprise data management and governance

Required Skills:

  • Excellent verbal and written communication skills
  • Ability to present complex subjects and alternatives in a clear and concise manner to both technical and non-technical audiences at various levels within an organization
  • Experience with databases (Oracle, MS SQL Server)
  • Experience with database development, programming languages and data query languages such as SQL, PL/SQL, MDX, DAX
  • At least 2 years’ experience with Data Warehousing and Business Intelligence
  • Experience with methodology based project work
  • Knowledge of SQL Server 2008/2012/2014, Integration Services (SSIS), * Analysis Services(SSAS), Reporting Services(SSRS) and Visual Studio(SSDT)
  • Knowledge of or experience with Panorama Necto would be an asset
  • Knowledge of or experience with Big Data tools and solutions would be an asset
  • Knowledge of or experience with Jaspersoft would be an asset

Educational Requirements:

  • Must have current MCSE or MCITP certification
  • Post secondary diploma, degree or equivalent work experience.

More Jobs
« go back to homepage
Is this job ad fake? Report it!   
Recommend to a friend
Published at 12-02-2015
Viewed: 2574 times