Apptad - Business Intelligence Specialist - Junior
Apptad - Business Intelligence Specialist - Junior
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Location: Toronto (Hybrid)
Job Duration: LongTerm Contract
Job Description
Required Knowledge / Skills:
Key deliverables to be performed by the Business Intelligence Specialist role include but are not limited to the following:
- Supports Clients wideranging business information requirements implementing and supporting business intelligence software solutions
- Develops and supports customized query applications which analyze key business data
- Develops and supports guided analysis and drilldown functionality routine scheduling and notification of report generation and effective implementation of opportunity and keytrend alerts.
- Provides Clients with approach options and tools for managing businessrelated data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
- Familiarity with Oracle database structures SQL Server and their respective features. Understanding of Oracle SQL and PL/SQL
- Develop presentations for various audiences as required.
- Work with the business and IT areas to complete any activities required to accomplish above and other deliverables as required during the assignment.
- Transfer skills and knowledge to selected OPS staff.
Required Knowledge / Skills:
Key deliverables to be performed by the Business Intelligence Specialist role include but are not limited to the following:
- Supports Clients wideranging business information requirements implementing and supporting business intelligence software solutions
- Develops and supports customized query applications which analyze key business data
- Develops and supports guided analysis and drilldown functionality routine scheduling and notification of report generation and effective implementation of opportunity and keytrend alerts.
- Provides Clients with approach options and tools for managing businessrelated data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
- Familiarity with Oracle database structures SQL Server and their respective features. Understanding of Oracle SQL and PL/SQL
- Develop presentations for various audiences as required.
- Work with the business and IT areas to complete any activities required to accomplish above and other deliverables as required during the assignment.
- Transfer skills and knowledge to selected OPS staff.
Required Knowledge / Skills:
Key deliverables to be performed by the Business Intelligence Specialist role include but are not limited to the following:
- Supports Clients wideranging business information requirements implementing and supporting business intelligence software solutions
- Develops and supports customized query applications which analyze key business data
- Develops and supports guided analysis and drilldown functionality routine scheduling and notification of report generation and effective implementation of opportunity and keytrend alerts.
- Provides Clients with approach options and tools for managing businessrelated data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
- Familiarity with Oracle database structures SQL Server and their respective features. Understanding of Oracle SQL and PL/SQL
- Develop presentations for various audiences as required.
- Work with the business and IT areas to complete any activities required to accomplish above and other deliverables as required during the assignment.
- Transfer skills and knowledge to selected OPS staff.
MUST HAVE:
* Demonstrates experience designing and developing BI Reports Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI
* Demonstrated experience advising on existing data sets models and transformations to enhance business intelligence reporting
Experience in ETL processes particularly as it relates to migrating data into Power BIcompatible formats. Familiarity with ETL tools (e.g. SSIS Informatica)
Technical Skills 40%
Demonstrates business analysis experience in an environment where Oracle Informatica and Cognos are used together for data warehousing and business intelligence.
Experience working with data warehouse systems and understanding the design and concepts of it.
Experience in ETL processes particularly as it relates to migrating data into Power BIcompatible formats. Familiarity with ETL tools (e.g. SSIS Informatica)
Demonstrates experience designing and developing BI Reports Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI
Working knowledge of the entire Data Dictionary and data mapping
Working knowledge of the Business Process Design Reengineering for applications.
Experience with analyzing data in source systems to identify data cleanliness issues (E.g. missing values duplicate meanings and invalid data)
Experience with developing automation extraction cleansing and load scripts
Experience generating research models and reports (scheduled and adhoc)
Demonstrated experience advising on existing data sets models and transformations to enhance business intelligence reporting
Experience working with Oracle Databases (version 10.x or higher) DB2 Database.
Demonstrates strong MS Excel skills including working knowledge of Power Query Pivot Tables
Core Skills 30%
Experience gathering and eliciting requirements for BI application (Cognos and Power BI)
Experience with systems design and development and related methods techniques practices and standards.
Experience performing the design of data warehouse and related components.
Working Knowledge of technology data databases applications and networking techniques tools and practices enable you to lead the design and development of infrastructure support projects.
Experience Documenting applications designs and specifications and draft policies and procedures.
Working Knowledge of aggregate reporting.
Troubleshooting of production issues and creating fixes for any unplanned deployments.
Prior experience with BI migration projects particularly involving Power BI or from another reporting tool like Tableau Cognos.
Proven troubleshooting and analytical experience
Experience in process decomposition/mapping and business process reengineering and complex data models using UML.
Experience in the use of development tools and business reengineering software
Experience Designing and developing enterprisewide data analysis and reporting solutions
Experience reviewing and analyzing data from multiple internal and external sources
Familiarity with the source system(s) being migrated from (e.g. Cognos SSRS Qlik) can be a significant advantage as it allows for smoother data mapping and validation
Ability to use BI tools and data models effectively to help visualize or monitor data
Proven experience using a variety of methodologies to carryout the software development lifecycle (e.g. Agile waterfall etc.).
Communication Skills 20%
Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.
Analytical and problemsolving skills to assess clients business priorities and needs; to evaluate business and technical design alternatives.
Exceptional organization and presentation skills
Good written verbal and interpersonal skills
Project Management Skills 10%
Experience in the development of various deliverables of various roles including but not limited to project coordinator release management requirements analyst system designer system tester trainer etc. throughout SDLC.
Employment Type
Full Time
