Our Client in the Ontario Public Sector is looking for a Business Intellgence Solutions Designer -Senior on a 12 month Contract .
Must Haves:
Microsoft BI stack including Power BI for analytic reporting solution experience including ETL experience and experience migrating solutions from Oracle/Cognos/Informatica BI
...
Leading technical team including BI dashboard developers, and assisting architects with documentation
Advantages
Pay Every week
Long Term Contract
Working from home 2-3 days a week
Office is close to College Subway Station
Responsibilities
Knowledge of related best practices, OPS directory/messaging standards, standard infrastructure/architecture management, service delivery processes, infrastructures policies, procedures and direction, cost models and procurement processes,
Ability to gather client business requirements; corporate I&IT information mandates, client information technology strategic plans, environment and standards
Ability to participate in the development of solutions and provide advice on short/long term solution service development activities.
Knowledge of leading edge technologies design criteria, security and recovery procedures, preparation of technical specifications for installation, testing and performance of integrated, multi-services systems; assess performance and capacity of existing system making recommendations for improving performance and develop technical documentation.
Experience planning, migrating, implementing and sustaining large complex system development projects
Knowledge of technology developments, trends and new products to evaluated application to client short and long term technology requirements.
Basic knowledge of project management methodology (e.g. PMBOK), analytical tools and processes.
Conceptual and analytical skills to assess and evaluate client needs and conduct cost/benefit analyses for new technology requirements in planning and designing solutions.
Experience designing and developing large, complex, highly available, mission critical applications
Experience with systems evaluation to assess conditions, technical performance and capacity of existing systems and determine need and feasibility of expansion, renovation or replacement
Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and negotiation skills, team work skills
A team player with a track record for meeting deadlines
Qualifications
Technical Experience - 35%
Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions
Experience leading projects that involve technology upgrade/migration to Microsoft BI Suite; determine which part of existing solution needs to be migrated or rebuilt
10+ years of hands on experience ETL development experience using SSIS / ADF in a data warehousing environment or large data migration; Working experience in debugging mappings, transformations and source qualifier files and Unit testing the newly developed ETL components
Experience with role-based access control implementation, such as with AzureAD
Experience working with Oracle and MSSQL databases
Extensive experience with source control and environment management
Experience with creating documentations such as data dictionary and data source to target mapping; provide feedback/direction to team on how existing documentations can be improved
Experience using PowerDesigner to review data models, as well as make changes and generate DDL's
Experience in developing the Application Code package using tools such as Azure DevOps. Build automation experience is an asset
Core Skills - 35%
Long term vision: be able to work with stakeholders to define technical roadmap for current applications, and provide recommendation
Working knowledge of systems design and development, and related methods, techniques, practices and standards enable you to analyze and define clients' business and information technology requirements pertaining to data flow and data integration; provide recommendation to business
Demonstrates Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives
Working knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure related projects.
Summary
Undertakes the design of BI technology solutions based on the client’s service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement and project/initiative deliverables.
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.
show more
Our Client in the Ontario Public Sector is looking for a Business Intellgence Solutions Designer -Senior on a 12 month Contract .
Must Haves:
Microsoft BI stack including Power BI for analytic reporting solution experience including ETL experience and experience migrating solutions from Oracle/Cognos/Informatica BI
Leading technical team including BI dashboard developers, and assisting architects with documentation
Advantages
Pay Every week
Long Term Contract
Working from home 2-3 days a week
Office is close to College Subway Station
Responsibilities
Knowledge of related best practices, OPS directory/messaging standards, standard infrastructure/architecture management, service delivery processes, infrastructures policies, procedures and direction, cost models and procurement processes,
Ability to gather client business requirements; corporate I&IT information mandates, client information technology strategic plans, environment and standards
Ability to participate in the development of solutions and provide advice on short/long term solution service development activities.
...
Knowledge of leading edge technologies design criteria, security and recovery procedures, preparation of technical specifications for installation, testing and performance of integrated, multi-services systems; assess performance and capacity of existing system making recommendations for improving performance and develop technical documentation.
Experience planning, migrating, implementing and sustaining large complex system development projects
Knowledge of technology developments, trends and new products to evaluated application to client short and long term technology requirements.
Basic knowledge of project management methodology (e.g. PMBOK), analytical tools and processes.
Conceptual and analytical skills to assess and evaluate client needs and conduct cost/benefit analyses for new technology requirements in planning and designing solutions.
Experience designing and developing large, complex, highly available, mission critical applications
Experience with systems evaluation to assess conditions, technical performance and capacity of existing systems and determine need and feasibility of expansion, renovation or replacement
Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and negotiation skills, team work skills
A team player with a track record for meeting deadlines
Qualifications
Technical Experience - 35%
Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions
Experience leading projects that involve technology upgrade/migration to Microsoft BI Suite; determine which part of existing solution needs to be migrated or rebuilt
10+ years of hands on experience ETL development experience using SSIS / ADF in a data warehousing environment or large data migration; Working experience in debugging mappings, transformations and source qualifier files and Unit testing the newly developed ETL components
Experience with role-based access control implementation, such as with AzureAD
Experience working with Oracle and MSSQL databases
Extensive experience with source control and environment management
Experience with creating documentations such as data dictionary and data source to target mapping; provide feedback/direction to team on how existing documentations can be improved
Experience using PowerDesigner to review data models, as well as make changes and generate DDL's
Experience in developing the Application Code package using tools such as Azure DevOps. Build automation experience is an asset
Core Skills - 35%
Long term vision: be able to work with stakeholders to define technical roadmap for current applications, and provide recommendation
Working knowledge of systems design and development, and related methods, techniques, practices and standards enable you to analyze and define clients' business and information technology requirements pertaining to data flow and data integration; provide recommendation to business
Demonstrates Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives
Working knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure related projects.
Summary
Undertakes the design of BI technology solutions based on the client’s service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement and project/initiative deliverables.
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.
show more
