This job board retrieves part of its jobs from: Emploi Restauration | Emploi Directeur | Work From Home

Job opportunities for the local people in Sarnia

To post a job, login or create an account |  Post a Job

   sarnia jobs   

Job opportunities exclusive for the people of Sarnia!

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

Analytics & BI Intermediate Analyst

McMaster University

This is a Full-time position in Sarnia, ON posted September 16, 2022.

Schedule M-F, 35 hours/week, 8:30-4:30.

Education Level As a minimum, a university degree (preferably related to computing science, engineering, mathematics, statistics or information systems) Career Level At least five years working experience with ELT or ETL design and development/ or working with data warehousing.

Direct work experience in post-secondary education data analysis would be an asset.

The Office of Institutional Research and Analysis provides leadership, advice and support for planning, policy formation and informed decision-making activities at McMaster University.

To fulfill its mission and support the strategic goals of McMaster University, the office provides accurate, timely and high-quality information, data analysis and analytics to the university’s various academic and administrative offices and responds to data requests from external agencies.

It supports, advises, and enables senior administration planning and decision making through the provision of performance metrics, benchmarks, projections, simulations, modelling, and effective analyses and insights based on a thorough understanding of McMaster and its external environment.

Employees within Institutional Research and Analysis serve as the liaison with government, the U15 Data Exchange, Council of Ontario Universities, and other external agencies on institutional data and research activities.

Job Description JOB DESCRIPTION: The Analytics and BI Intermediate Analyst, reporting to the Senior Manager, Analytics and BI, is responsible for working with the BI team and other IRA staff, and with stakeholders and other support units to develop analytics and business intelligence reports, dashboards and metrics for all functional areas to meet business requirements and to support evidence-based decision making at McMaster University.

The incumbent is a key member of the BI team and works with other IRA team members to analyze and mine data, and translate data analysis and information for business needs into BI deliverables.

A primary responsibility of the Intermediate Analyst is to design, develop and implement moderate to complex data transformation processes using the ETL or ELT tools that will migrate data from the central data warehouse, and other enterprise data sources.

Author technical documents (ETL Architecture, ETL standards, ETL design specifications, ETL workflow, system architecture) and work with systems architects or PS Admins to develop solutions to technical issues and design issues.

As one of the BI administrators, the Intermediate Analyst administers and responds to security and access issues related to BI deliverables.

PRIMARY ACCOUNTABILITIES: Analyze and synthesize data analysis and information to support planning, policy changes and decision making as well as to understand issues and identify options to resolve issues.

Design, develop and implement moderate to complex data transformation processes using the ETL tools to migrate data from the central data warehouse, and other enterprise data sources.

Author technical documents (ETL Architecture, ETL standards, ETL design specifications, ETL workflow, system architecture) and work with systems architects or PS Admins to develop solutions to technical issues and design issues.

Develop technical or programming scripts and stored procedures to augment the ETL process.

Work closely with UTS in the design of ETL workflows processes and the preparation and scheduling of ETL workflows, using scripting where necessary.

Conduct performance tuning of ETL mapping and load processes, as required.

Ensure ETL best practices are incorporated into the design and development of the data warehouse and BI solution by establishing design standards and templates.

Successfully navigate complex organizational relationships and structures, to achieve acceptance and adoption of the BI solutions.

Work with subject matter experts and business systems analysts to uncover the appropriate sources of data to target data mappings for a proposed BI project or data warehousing extension.

Develop understanding of which business processes use which data and what the data means in the context of specific processes.

Work with business areas (student, finance, research and human resources) to understand requirements for modelling, metrics, dashboards, etc.

and then generate required modelling, including modelling for enrolment, staffing, bargaining or financial purposes Conduct user interviews to validate the transformation rules.

Evaluate data quality and provide written feedback as required.

Conduct fit-gap analyses prior to and during BI projects in order to assess what business requires against what can and cannot be delivered by out-of-the-box data marts and what extensions are necessary to meet business needs.

Develop the data mapping document and lead the ETL code development to meet business requirements.

Compare data in system functionalities against data in the data warehouse and identify, recommend and implement opportunities to bring required data into the data marts or OBIEE.

Troubleshoot ETL code issues and provide timely resolution.

Identify, recommend, and implement opportunities to improve service delivery standards, models and solutions to enhance service delivery and effectiveness.

Maintain a current and comprehensive issues and resolution log and effectively preventing avoidable recurrences.

Analyze and synthesize information required to understand issues, identify options, and facilitate the prioritization of projects and requirements among competing business interests Assist with developing the process for capturing and maintaining metadata record keeping and BI technology and business processes.

Coordinate the development and use of business metadata.

Assist in designing logical and physical dimensional data mart models.

Assist in complex sizing, resource estimates, scope and requirements for a variety of projects.

Develop and execute implementation plan and adhere to project timeline requirements.

Assist the Senior Manager to plan, organize, and control processes and resources and evaluate results and risks required to achieve the project’s goals and objectives.

Partner with end users to define business requirements and systems goals, and identify and resolve systems issues and limitations.

Deal effectively with project-related ambiguity and create clarity with sponsors and stakeholders with diverse views and opinions.

Work collaboratively with diverse sets of stakeholders and colleagues to effect a common outcome.

Analyze and synthesize information required to understand issues, identify options, and support sound decision making.

Assist in quality assurance testing of all BI deliverables.

Perform the role of backup BI administrator.

Ensure compliance with best practices as appropriate in all areas of BI application delivery (requirements gathering, analyses, define, development, test, deployment, maintenance and support).

Assist in the development of BI analytics, dashboards and reports and deployment as required.

Keep current on BI and Analytics technology, data governance and industry best practices; recommend and action specific adoption for McMaster as appropriate.

Responsible for backup and recovery, use case development for effective testing, regular performance and capacity planning audits related to the BI solution, as required.

Responsible for measuring results and impact of BI while keeping the objectives and benefits visible to McMaster stakeholders and users.

EDUCATION AND EXPERIENCE: As a minimum, a university degree (preferably related to computing science, engineering, mathematics, statistics or information systems) and at least five years working experience with ELT or ETL design and development/ or working with data warehousing.

Direct work experience in post-secondary education data analysis would be an asset.

KNOWLEDGE/ SKILLS: Demonstrated high and sustained motivation to understand and interpret data, its business use and deliver appropriate solutions.

Extensive experience with DataStage, Oracle ODI or a similar ETL tool.

Some working knowledge of data analysis, data mining, data modeling, data governance, data warehousing/business intelligence and analytics.

Excellent interpersonal, facilitation, negotiation, issue or conflict identification and resolution skills with strong skills in building strong, collaborative partnerships with stakeholders.

Excellent communication and interpersonal skills with the ability to communicate complex information and issues to and interface with all levels of the organization.

Strong understanding and experience of Oracle OBIA or PeopleSoft EPM/OBIEE with deep understanding of data model and data architectures.

Design and development experience of the overall OBIEE RPD, logical and physical data warehouse/data mart and data model to support business requirements.

Extensive knowledge of ETL and ETL approach, design and implementation.

Strong knowledge of relational and dimensional modeling techniques.

Highly analytical and understand the basic principles of working with large and complex data sets.

A proactive attitude and demonstrated discipline of resolving issues with solutions that prevent recurrence.

Ability to work with minimal direction and supervision.

Proven project management/project lead skills an asset.

Attention to detail as an innate personal trait.

Excellent organizational skills.

Demonstrated good team playing.

Demonstrated track record of building business solutions rather than technical solutions.

Ability to work within and achieve assigned deadlines.

Hands-on experience with BI and data warehouse technologies.

Strong working knowledge about best practices on metadata development, retention and storage.

In depth knowledge of Oracle Cloud infrastructure Migration experience of Oracle OBIA from on-premises to cloud How To Apply To apply for this job, please submit your application online.

Employment Equity Statement McMaster University is located on the traditional territories of the Haudenosaunee and Mississauga Nations and within the lands protected by the “Dish With One Spoon” wampum agreement.

The diversity of our workforce is at the core of our innovation and creativity and strengthens our research and teaching excellence.

In keeping with its Statement on Building an Inclusive Community with a Shared Purpose, McMaster University strives to embody the values of respect, collaboration and diversity, and has a strong commitment to employment equity.

The University seeks qualified candidates who share our commitment to equity and inclusion, who will contribute to the diversification of ideas and perspectives, and especially welcomes applications from indigenous (First Nations, Métis or Inuit) peoples, members of racialized communities, persons with disabilities, women, and persons who identify as 2SLGBTQ.

As part of McMaster’s commitment, all applicants are invited to complete a confidential Applicant Diversity Survey through the online application submission process.

The Survey questionnaire requests voluntary self-identification in relation to equity-seeking groups that have historically faced and continue to face barriers in employment.

Please refer to the Applicant Diversity Survey
– Statement of Collection for additional information.

Job applicants requiring accommodation to participate in the hiring process should contact: Human Resources Service Centre at 905-525-9140 ext.

222-HR (22247), or Faculty of Health Sciences HR Office at ext.

22207, or School of Graduate Studies at ext.

23679 to communicate accommodation needs.

Vaccination Policy Statement The University is committed to providing and maintaining healthy and safe working and learning environments for all employees, students, volunteers and visitors.

The University’s Vaccination Policy-COVID-19 Requirements for Employees and Students (the “Vaccination Policy”), requires all McMaster community members, including employees, accessing a McMaster campus or facility in person to be fully vaccinated or to have received an exemption from the University for a valid human rights ground.

While the Policy will be currently paused, this Policy may resume quickly and on short notice, as informed by public health advice and direction.

As a result, failure to achieve and maintain fully vaccinated status or an approved human rights-based exemption may result in termination of employment.

This is a term and condition of employment.

The University will continue to follow the guidance of public health organizations to define fully vaccinated status.