Analytics & BI Intermediate Analyst

2 weeks ago

Hamilton, Canada McMaster University Full time

**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**:
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 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 del

  • BI Reporting Specialist

    4 weeks ago

    Hamilton, Canada Hamilton Health Sciences Full time

    The BI Reporting Specialist helps design, develop and maintain reports and dashboards that integrate data from multiple sources and bring out the most useful results for end users. This role is responsible for the complete range of BI capabilities: reporting, analysis, scorecarding, and dashboards.Qualifications1. University degree or college diploma...

  • BI Reporting Specialist

    3 weeks ago

    Hamilton, Canada Hamilton Health Sciences Full time

    The BI Reporting Specialist helps design, develop and maintain reports and dashboards that integrate data from multiple sources and bring out the most useful results for end users. This role is responsible for the complete range of BI capabilities: reporting, analysis, scorecarding, and dashboards.Qualifications1.University degree or college diploma in...

  • Data Analytics and Reporting Analyst

    6 days ago

    Hamilton, Canada City of Hamilton Full time

    **About the City of Hamilton** **Contribute to the City of Hamilton, one of Canada’s largest cities - home to a diverse and strong economy, an active and inclusive community, a robust cultural and dining scene, hundreds of kilometres of hiking trails and natural beauty just minutes from the downtown core, and so much more. Join our diverse team of...

  • Senior Business Systems Analyst

    4 days ago

    Hamilton, Ontario, Canada McMaster University Full time

    Job DescriptionThe Senior Business Systems Analyst plays a pivotal role in our organization, exhibiting exceptional analytical and problem-solving skills. This individual should possess a collaborative spirit, a positive attitude, and excellent communication and organizational skills.We are seeking an experienced professional with substantial expertise in...

  • Analytical Chemist

    4 days ago

    Hamilton, Ontario, Canada AtomVie Global Radiopharma Inc. Full time

    **Job Description**The QC Analyst will work in accordance with company policies and GMPs while contributing technical expertise to support current products and develop future drugs within the AtomVie portfolio. They will be responsible for quality control testing of materials and finished drug products, specifically radiopharmaceuticals.This position...

  • Marketing Analyst

    3 weeks ago

    Hamilton, Canada ServiceTitan Software Canada ULC Full time

    **Ready to Be a Titan?** If you’re passionate about data analysis, building intuitive dashboards, and working with cutting-edge tools in a collaborative, fast-paced environment, we’d love to hear from you! **What You’ll Do**: You’ll be at the forefront of delivering actionable insights to drive web optimization and support marketing initiatives....

  • Data Management Analyst

    2 weeks ago

    Hamilton, Canada GM BluePlan Engineering Full time

    **Data Management Analyst** **(full-time permanent position)** **Location: Hamilton, Ontario** **GM Blue**Plan** Engineering **is a dynamic engineering, management and technology consulting company that provides full service and full asset life cycle offerings to our clients across Canada. With over 50 years of experience, we provide expert guidance to...

  • Financial Analyst

    1 week ago

    Hamilton, Canada L3Harris Technologies Full time

    Financial Analyst L3HARRIS ELECTRO OPTICAL (EO) Sector About the Role Develops, interprets, and implements financial concepts for financial planning and analysis. Performs technical analysis to determine present and future financial performance. Gathers, analyzes, prepares and summarizes recommendations for financial plans, trended future requirements,...

  • Intermediate Accounting Analyst Re-post

    2 weeks ago

    Hamilton, Canada City of Hamilton Full time

    **About the City of Hamilton** **Contribute to the City of Hamilton, one of Canada’s largest cities - home to a diverse and strong economy, an active and inclusive community, a robust cultural and dining scene, hundreds of kilometres of hiking trails and natural beauty just minutes from the downtown core, and so much more. Join our diverse team of talented...

  • Analytical Chemist

    4 days ago

    Hamilton, Canada Centre For Probe Development And Commercialization Full time

    The Centre for Probe Development and Commercialization **(CPDC) **is a global leader of next-generation radiopharmaceuticals. At CPDC we are working with our partners to discover, develop and distribute the next generation of imaging agents and targeted radiotherapeutics for the detection and treatment of human diseases such as cancer. Our Centre has the...

  • Manager, Data Analytics

    4 weeks ago

    Hamilton, Ontario, Canada Stryker Group Full time

    As Manager, Data Analytics, you will lead and develop a local analytics team while providing technical and project leadership in the team's day-to-day project portfolios. As part of Stryker's Sales Enablement team, you will support collaboration with Stryker enterprise across functions to leverage domain expertise and capabilities while managing expectations...

  • Analyst, People

    2 weeks ago

    Hamilton, Ontario, Canada YMCA of HamiltonBurlingtonBrantford Full time

    Job Category: People, Leadership & CultureRequisition Number: SPECI001146Posted: March 7, 2025Employment Type: Full-TimeWork Arrangement: HybridLocationsHamilton Downtown Family YMCA79 James Street SouthHamilton, ON L8P 2Z1, CANDescriptionStarting Salary Range: $50,000 - $55,000 commensurate with experienceDepartment: Association ServicesEmployment Type:...

  • Business Analyst

    2 weeks ago

    Hamilton, Canada YMCA HamiltonBurlingtonBrantford Full time

    **Business Analyst** Hamilton Downtown Family YMCA - Business Administration & Customer Care 79 James Street South, Hamilton, Ontario, L8P 2Z1 **Salary**:$50,000.00 annually. **Position Status**: Full Time Permanent, with benefits and a complimentary YMCA membership and a hybrid work model **Placement**: Immediate **Why work at the Y?** Our work...

  • Performance Analyst

    5 days ago

    Hamilton, Canada Ontario Health Full time

    Want to make a difference in your career? Consider this opportunity! The Performance Analyst is responsible for evaluation of health and service provider performance (financial, service activity and local performance outcomes) in accordance with performance/accountability agreements for both Performance and Ministry defined goals. Here is what you will be...

  • Analyst, People

    3 weeks ago

    Hamilton, Canada YMCA of HamiltonBurlingtonBrantford Full time

    Starting Salary Range: $50,000 - $55,000 commensurate with experience Department: Association Services Location: Hamilton Downtown Family YMCA with hybrid work options available Work Hours: 40 Hours per week Employment Type: Regular Full-Time Salaried with benefits and a complimentary YMCA Membership Number of Vacancies: 1 Anticipated Start Date: April...

  • Business Intelligence Analyst

    2 days ago

    Hamilton, Ontario, Canada Local Health Integration Networks Full time

    The successful candidate for this Senior Financial Analyst position will have excellent analytical and communication skills, with the ability to work independently and collaboratively as part of a team. As a Senior Financial Analyst, you will be responsible for providing financial guidance and support to senior management, and developing recommendations to...

  • Statistical Analyst

    1 week ago

    Hamilton, Canada McMaster University Full time

    **Schedule** 37.5 Hours per week Monday - Friday 8:30am to 4:30pm **Education Level** Masters Degree in statistics or related field of study **Career Level** 2 years of relevant experience Should the successful applicant be a Unifor Unit 1 bargaining unit member, who meets the eligibility conditions of Article 19.02 of the Unifor Unit 1 Collective...

  • Materials Analyst

    3 days ago

    Hamilton, Ontario, Canada Honda Canada Inc. Full time

    Job DescriptionHonda Canada Inc. is seeking a talented Materials Analyst to join our team. The successful candidate will be responsible for analyzing and interpreting data to inform business decisions, identifying areas for cost reduction and process improvement, and developing strategies to optimize material usage.Key qualifications include a degree in...

  • Credit Analyst

    2 weeks ago

    Hamilton, Canada GFL Environmental Full time

    GFL Environmental is looking for a **Credit Analyst **to join our team based out of the Hamilton area! This individual will be responsible for the credit adjudication of incoming new accounts, plus the review of existing accounts, and work order releases. **Key Responsibilities**: - Maintain relationships with the business to ensure mitigated risk on...

  • Customer & Logistics Services Specialist

    1 week ago

    Hamilton, Canada Everest Toys Full time

    **The Company**: Everest has been in business since 1992 and is the leading toy, game, and gift manufacturer and distributor in North America, with our head office located in Ancaster, ON. We are looking for an enthusiastic, motivated, detail-oriented, and passionate individual to join our team as a **Customer & Logistics Services Specialist.** **The...