Business Intelligence Specialist

Arthur Grand Technologies is currently seeking a highly motivated of **Business Intelligence Specialist - Junior** with one of our clients.

**Position**:Business Intelligence Specialist - Junior**

**Location: 777 Bay St, 4th floor, Toronto, Ontario (Hybrid)**

**Hybrid - 3 days on site and 2 remote**

**Duration: Long Term Contract**

**Must Haves**:

- Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions

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 BI-compatible formats. Familiarity with ETL tools (e.g., SSIS, Informatica)

**Experience and Skill Set Requirements**

**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 BI-compatible 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
- 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 ad-hoc)
- 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 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 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 re-engineering and complex data models using UML.
- Experience in the use of development tools and business re-engineering software
- Experience Designing and developing enterprise-wide 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 carry-out 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 problem-solving 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.

**About Arthur Grand Technologies**:
Arthur Grand Technologies is a leading provider of staffing and technology consulting services. Our company is managed by a team of professionals who have worked for big 5 consulting firms for 20+ years. We are a minority-owned staff augmentation and technology consulting company.

Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon.

Thanks,

**Regena Rose**

Arthur Grand Technologies Inc

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

**Job Type**: Fixed term contract

Schedule:

- 8 hour shift