Business Intelligence (BI) Consultant
Ideaca Knowledge Services - Calgary, AB

This job posting is no longer available on Indeed. Find similar jobs:Business Intelligence Consultant jobs - Ideaca Knowledge Services jobs

About Us:

Ideaca is a Canadian based consulting firm with locations in Toronto, Edmonton, Calgary, Vancouver and Kitchener. We help customers from strategy to solution through a portfolio of management consulting, advisory, implementation and support services. We have 10 years of experience doing business and in that time, have accumulated a growing list of over 350 satisfied, repeat customers. Our family of over 170 employees across the country work on delivering innovative solutions around Enterprise Resource Planning (ERP), Business Intelligence, Portals and Collaboration, Cloud Computing, Custom Application Development, Customer Relationship Management (CRM), Application Infrastructure, Support Services

Our people are creative and can get the job done. Ideaca has experienced phenomenal growth and has maintained a relaxed and open culture, with an emphasis on diversity and the development of our people. We aim to be the best IT consulting company in Canada and will do so by continuing to invest in talented and motivated people, building long term relationships with our customers and by focusing nationally.


As an Ideaca Business Intelligence Consultant you will be responsible for participating at all phases of the project life cycle, including: analyzing, designing, modeling, testing and deploying suitable and appropriate solutions.
Required Qualifications:

Business Intelligence skills (Primary focus)

  • Have experience with Microsoft Reporting Services (SSRS) and/or Microsoft Analysis Services (SSAS) or Integrated Services (SSIS)
  • Defining data standards and data models for warehouse architectures
  • Business analytics focusing on the effective use of data and information to drive positive business actions. This area includes both business and technical topics, including concepts of performance management, definition and delivery of business metrics, data visualization, and deployment and use of technology solutions such as OLAP, dashboards, scorecards and analytic applications
  • Data analysis concentrating on the understanding of business requirements with respect to data and information
  • Data design focusing on translating business information into data structures with core skills to include information needs analysis, specification of business metrics, and data modeling
  • Solid understanding of data warehousing concepts, architectures, and processes
  • Data integration to deliver business intelligence solutions. Integration includes all of the activities necessary to acquire data from sources, and to transform and cleanse the data. Data integration includes concepts and skills for source data analysis and source qualification, data profiling, source/target mapping, data cleansing and transformation, and ETL development
  • Managing the infrastructure and ensuring continuous operation of data warehousing and business intelligence solutions

Database skills (Secondary focus)

  • In-depth knowledge in the administration of Oracle and SQL Server databases including installation, configuration and support
  • Experience in applying database methodologies and best-practices in a client environment
  • Experience in the development of SQL and PL/SQL code objects including stored procedures, functions, triggers and views
  • Planning, design, and implementation of database related architecture and services
  • Performing data migrations including testing fixes and upgrades
  • Experience with space planning
  • Database backup and recovery
  • Performance tuning and problem diagnosis and resolution; working with Application developers
  • Strong understanding of application development processes
  • Database security administration
  • Release management and documentation

Ideal Candidate:

  • Experienced with database configuration and administration of ERP packages (including but not limited to SAP, JD Edwards, PeopleSoft, Oracle, Baan, MS/Navision Attain, MS/Navision Axapta)
  • Successful completion of a post-secondary degree/diploma in Business Computer Science or a related discipline
  • Understanding of how to build and maintain positive client and peer relationships
  • Experience working on ASP.NET enterprise applications, working with ADO.NET against a SQL server or Oracle databases
  • Demonstrated capabilities in evaluating new techniques and utilizing the appropriate elements
  • Established confidence in your ability to manage tasks, issues, their priorities and interdependencies
  • Prepared for some domestic and international travel as required

We thank you for your interest in Ideaca; however, only applicants being considered will be contacted.