Bus Intelligence Analyst 1- Full-Time- Hybrid-Downsview
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Serco is seeking a Business Intelligence Analyst to join their team in Downsview, ON. The role involves analyzing service performance data, developing Power BI dashboards, and collaborating with operations to drive process improvements.
Key Skills for This Role
Responsibilities
- Analyze service performance data and provide management information on service delivery against contractual KPIs
- Design, develop and deploy interactive data visualizations using Power BI
- Write complex SQL queries and develop SSIS, SSAS solutions
- Collaborate with IT to design, develop, and maintain applications and data models for reporting and analytics
- Perform data profiling, data migration, extraction and transformation using ETL methodology
- Mentor junior staff members for career development
Requirements
- Bachelor's degree in computer science or related field
- At least 2 years of experience in enterprise data warehousing
- Minimum 2 years working with Power BI
- Experience with SQL, SSIS, SSAS
- Knowledge of ETL methodology
- Excellent analytical and problem solving skills
Full Job Posting
The Role
- We are looking for a motivated, analytical, customer focus, service oriented professional for the permanent position of Business Intelligence Analyst, Reporting and Analytics to interface with operations.
- Work closely and collaboratively with operational managers and support team leaders to identify problem areas, trends, root cause and opportunities for improvement supported by data.
Key Responsibilities
- Understand the overall business operations, developing innovative Control Centre solutions to help improve productivity and meet contractual KPIs.
- Provide guidance and support on procedures, reporting requirements and process improvement.
- Handle and resolve complex data requirements to determine service delivery and customer feedback volume, trends and develop long term strategies.
- Utilize database to perform updates to scheduling, forecasting and service level databases through basic programming.
- Collaborate with IT to design, develop, execute, testing and maintenance of applications, data models for reporting and analytical purposes.
- Develop, implement and document processes, systems and controls for compliance.
- Design, develop and deploy Enterprise BI solutions that leverage common data architecture and data optimization approaches.
- Design, develop and deploy interactive data visualizations using Power BI.
- Collect and analyse requirements from users across the driver examination services program.
- Incorporate User Feedback to promote analytics self service and drive adoption.
- Perform modelling of data and flows into Data Warehouse.
- Write complex SQL queries and develop Microsoft SSIS, SSAS, etc.
Job Requirements
- A bachelor’s degree in computer science or a related field is required, along with at least 2 years of experience in enterprise data warehousing and a minimum of 2 years working with Power BI.
- Business process transformation, using data mining/warehousing applications.
- Demonstrated competence working with large data sets within multiple systems environment.
- PMI, Six Sigma and Competency in Business Analyst (CCBA) certification is nice to have.
- Member, International Institute of Business Analyst (IIBA) is desirable but not required.
- Knowledge of Power BI, Data Warehouse, and other related technologies.
- Ability to work with other reports/dashboard developers and other IT teams.
- Excellent interpersonal, communication and presentation skills, and be a team player.
Skills/Competencies
- Business process transformation, using data mining/warehousing applications.
- Demonstrated competence working with large data sets within multiple systems environment.
- Knowledge of Power BI, Data Warehouse, and other related technologies.
- Excellent interpersonal, communication and presentation skills, and be a team player.
- Design, develop and deploy interactive data visualizations using Power BI.
- Create effective Power BI dashboards, reports, and applications utilizing best practices.
- Incorporate User Feedback to promote analytics self service and drive adoption.
- Collaborates and openly seeks and shares information across teams and departments.
- Takes initiative to complete critical tasks, and overcomes obstacles in a proactive manner.
- Works well in a growing, fast paced, entrepreneurial environment.
- Keeps informed on the latest technological approaches and trends in his/her technical field.
Pay Transparency
- Our Total Rewards package includes competitive pay, performance based incentives, and benefits that promote well being and work life balance.
- Salary range: CAD 90000 CAD 100000.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Serco
Tactical C2 Operations SME - Langley AFB, VA
Al Wakrah, QAT
Serco seeks a Tactical Command and Control (C2) Operations SME for Air Combat Command's CAF DTC at Langley AFB, VA. The role involves facilitating integration training by role-playing Air Battle Manager, AOC, and other C
JSE Fighter Pilot Operations SME - Langley AFB, VA
Al Wakrah, QAT
Serco seeks a Fighter Pilot or WSO/CSO/NFO Operations SME for Air Combat Command's CAF DTC at Langley AFB, VA. The role involves facilitating integration training for U.S. and allied military aircrew by role-playing figh
Fighter Pilot Operations SME - Langley AFB, VA
Al Wakrah, QAT
Serco seeks a former Fighter Pilot or WSO/CSO/NFO Operations SME to facilitate integration training for U.S. and allied military aircrew at Langley AFB, VA. The role involves role-playing fighter aircraft in Distributed
Customer Service Representative
Dubai, UAE
Serco is seeking a Customer Service Representative to deliver a safe, reliable, and world-class station environment and train service at Palm Jumeirah Monorail in Dubai. The role involves monitoring station operations, m
Air Traffic Control Assistant (ATCA) - Sharjah National
Sharjah Emirate, UAE
Serco is hiring an Air Traffic Control Assistant (ATCA) to support air traffic control operations in Sharjah. The role involves managing flight plans, NOTAMs, and assisting in the control tower. Requires strong IT skills
Business Development Manager - Sharjah Training Centre for Airports Science
Sharjah, UAE
Serco is seeking a Business Development Manager to drive strategic growth for the Sharjah Training Centre for Airports Science (STCAS) in Sharjah, UAE. The role involves identifying new business opportunities, building r
Environmental Services Manager
Sydney, UAE
Serco is seeking an Environmental Services Manager to provide strategic and operational leadership across cleaning, laundry, and waste services in the ASPAC region. The role involves driving consistency, quality, complia
Transition & Operational Readiness Manager
Abu Dhabi, UAE
Serco is seeking a Transition & Operational Readiness Manager to lead transition, migration, and operational readiness activities for an ATM modernization program in Abu Dhabi. The role requires 10-15 years of experience
Tactical C2 Operations SME - Langley AFB, VA
Al Wakrah, QAT
JSE Fighter Pilot Operations SME - Langley AFB, VA
Al Wakrah, QAT
Fighter Pilot Operations SME - Langley AFB, VA
Al Wakrah, QAT
Customer Service Representative
Dubai, UAE
Air Traffic Control Assistant (ATCA) - Sharjah National
Sharjah Emirate, UAE
Business Development Manager - Sharjah Training Centre for Airports Science
Sharjah, UAE
Environmental Services Manager
Sydney, UAE
Transition & Operational Readiness Manager
Abu Dhabi, UAE