Junior Business Intelligence Specialist

· Experience working with data warehouse systems and understanding the design and concepts of it.
· Demonstrates experience creating complex SQL scripting for data analysis and profiling
· Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI
· Experience with analyzing data in source systems to identify data cleanliness issues (E.g., missing values, duplicate meanings, and invalid data)
· Demonstrates strong MS Excel skills, including working knowledge of Power Query, Pivot Tables
· Demonstrated experience advising on existing data sets, models, and transformations to enhance business intelligence reporting
· 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.
Nice to Haves:

• Public Sector

Advantages
Pay Every Week
Working in Public Sector
2-3 days working from home.
Office is close to College Station.


Responsibilities
Supports Client’s wide-ranging 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 drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alerts.
Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
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.

Qualifications
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.

· Demonstrates experience creating complex SQL scripting for data analysis and profiling

· 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 Re-engineering 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 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 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.

· Defect investigation, resolution and assignment to team members using defect/issue management tools, e. g. Microfocus ALM.

· 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

· Ability to communicate analysis results and making recommendations to senior management

· 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.).

Summary
3+ years


Must Haves:

· 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.
· Demonstrates experience creating complex SQL scripting for data analysis and profiling
· Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI
· Experience with analyzing data in source systems to identify data cleanliness issues (E.g., missing values, duplicate meanings, and invalid data)
· Demonstrates strong MS Excel skills, including working knowledge of Power Query, Pivot Tables
· Demonstrated experience advising on existing data sets, models, and transformations to enhance business intelligence reporting
· 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.
Nice to Haves:

• Public Sector

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.