Serco

Bus Intelligence Developer-Full-Time- Term-Downsview

Serco • $80K — $95K *
North York, ON M3K 2E2In-Person
Enterprise Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Post-secondary education in Business, Information Technology, or related field.
  • 3-5 years' analytical experience, preferably in large organizations.
  • Proficient in Microsoft SQL and T-SQL development (SSIS, SSAS, SSRS, Power BI).
  • Experience in building reports and dashboards for business users.
  • Expertise with business intelligence solutions like Service Now.
  • High competence in MS Office with strong data analysis skills.
  • Experience developing workflow apps in Service Now.

Responsibilities

  • Access raw data sources for analysis and business improvement.
  • Format and design data for analysis and reporting tasks.
  • Interpret formatted data to identify trends and gather business insights.
  • Ensure timely generation of scheduled and ad-hoc reports.
  • Develop and maintain business intelligence tools and dashboards.
  • Apply objective disciplines to identify and set improvement targets.
  • Coordinate stakeholder communications and implementation plans for solutions.

Benefits

  • Opportunity for continuous professional development.
  • Work in a dynamic, collaborative team environment.
  • Engagement in innovative projects utilizing cutting-edge BI technologies.
Full Job Description
Position Description & Qualifications

Purpose of the Job:

This position exists to drive optimization of contract performance efficiency and profitability using data performance measurement systems, specifically...
  • Create business intelligence tools and reports, such as physical data models and dimensional analyses.
  • Design, code, test, and aggregate results from SQL queries to provide actionable information to users.
  • Create and modify enterprise resource planning (ERP) system of integrated applications in Service Now to manage the business and automate office functions. Drive continuous service delivery and productivity improvements.


Primary Duties and Responsibilities:
  • Data Mining: Accessing raw data sources (QMatic, Scheduler, CostPoint etc. to extract data required for analysis/ business improvement purposes.
  • Data Formatting & Design: Translation of raw data into an intelligible format to facilitate analysis or for direct reporting. Design, build and deploy BI solutions (Automation of NIs to DT website, extended hours invoicing, KPI monitoring systems, employee performance monitoring, etc.) in Service Now or other BI tools. Create event server, custom objects, reporting, data archive, schedule tasks, database tasks. Create tools to store data (e.g. SQL tables, OLAP cubes). Develop, implement, and optimize stored procedures, triggers and functions using T-SQL.
  • Data Analysis: Interpretation of formatted data to identify trends & areas requiring further investigation with a view to solutioning. Review and interpret ongoing business report requirements. Build appropriate and useful reporting deliverables. Analyze existing SQL queries for performance improvements.
  • General Reporting: Ensure problem-free generation of regularly scheduled reports (various KPI reports and other internal reports) and timely generation of ad-hoc reports. Oversight of all reports with standing objective to reduce report volumes & automate wherever possible.
  • Business Intelligence Development & Maintenance: Ongoing development of Power BI or other DES business intelligence tool i.e. development of screens/ dashboards/ reporting as required and routine maintenance tasks (access controls, account creation/ resets etc.).
  • Solution Development: Application of objective disciplines to determine possible improvement actions and set improvement targets/ timelines.
  • Solution Driving: Development of roll-out plans, stakeholder dialogue, communications and implementation plans for proposed solutions.
  • General:
    • Generate analyses and reports for both contractual compliance, identifications of business improvement opportunities and Serco Group obligations.
    • Assist with the provision of technical/ other support in the development of user specifications and design of programs to improve service delivery.
    • Participate in departmental, cross-functional and customer meetings and working groups as required.
    • Provide cover for, and assistance to the Business Improvement Analysts as directed.
    • Other related duties relevant to this position as may be required

Competencies:
  • Knowledge of BI technologies (e.g. Microsoft Visual Studio, Power BI including advanced excel, Service Now)
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
  • Background in data warehouse design (e.g. dimensional modeling) and data mining.
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
  • Effective communication skills and ability to work cross functionally within the organization.
  • Excellent collaborative and organizational skills.
  • Strong degree of integrity and judgment.
  • Willing to take ownership for the outcomes of tasks within scope of responsibility.
  • Strong planning, coordination, execution, and analytical skills.
  • Proven ability to meet deadlines and changing priorities.


Personal Attributes:
  • Innovative, creative, and agile.
  • Problem-solving aptitude.
  • Visibly demonstrates Serco Values and work practices.
  • Displays an eagerness to continually improve their skills and learn new technologies.
  • Comfortable with an environment where priorities change frequently.
  • Ability to work and deliver strong results in a dynamic team environment.


Qualifications:
  • Post-secondary education in Business, Information Technology, or another related field.
  • At least 3-5 years analytical experience, preferably within a large organization dealing with large data sets.
  • Proficient in Microsoft SQL platform with extensive knowledge of T-SQL development (SSIS, SSAS, SSRS and Power BI).
  • Experience working directly with business users to build reports, dashboards and solving business questions with data.
  • Expertise with front end business intelligence solutions, such as Service Now.
  • High degree of competence with MS Office - good data analysis abilities.
  • Has high level of knowledge of commonly used concepts, practices, and procedures within a particular field.
  • Possesses comprehensive knowledge of subject matter.
  • Experience developing workflow apps in Service Now
  • Primary job functions that require exercising independent judgment.
  • Certification and experience in Service Now development


Other:
  • Performs other tasks as assigned.


About Serco

Serco Group plc is a British company providing public services. It is listed on the London Stock Exchange and is a constituent of the FTSE 250 Index. The company has four divisions: Health, Justice and Immigration, Transport, and Defence, and operates across the UK and Europe, North America, Asia Pacific and the Middle East. Serco primarily provides public services to governments, including the operation of prisons and hospitals, defence and aerospace services, and transport services. The company also provides IT and consultancy services to the public sector. Serco has been involved in a number of controversies, including allegations of overcharging the UK government and mismanagement of contracts.
Learn more about Serco
Size
50,000 employees
Industry
Business Services
Founded
1988
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Serco

More Enterprise Technology Jobs

Find similar Bus Intelligence Developer-Full-Time- Term-Downsview jobs:

NationwideNorth York, ON