About us.

Synergy One Consulting is more than just another agency; we're a dedicated partner in your journey toward success. Specializing in sourcing exceptional immigrant tech talent, we connect Canada's leading companies with top-tier professionals in the technology sector.

Contact us.

IT Business Analyst

Full Time 27 May - 2024 7:12 pm
PDF
Employment Information
Skills
Data Analysis Data Warehouse SQL Power Bi SSIS Construction AWS Microsoft SQL Server
Locations
Description

Job Summary

As a member of the Information Technology, Business Solutions team, the IT Business Analyst is responsible for the implementation and support of business information systems across multiple departments. This role acts as the bridge between the business problems and the technology solutions. The ideal candidate will be required to engage with business leaders and users to understand how data-driven changes to processes, services and software can improve efficiencies and add value. In addition, they develop and monitor data quality metrics and ensure business data and reporting needs are met.

Responsibilities

  • Develop and maintain Power BI dashboards and reports that provide actionable insights
  • Transform raw data into meaningful information through interactive and user-friendly visualizations
  • Understand business requirements and translate them into technical specifications to support data-driven decision-making
  • Ensure data accuracy and integrity in reports and dashboards
  • Collaborate with stakeholders to identify needs and opportunities for improved data management and delivery
  • Process improvement, documentation, auditing and reporting
  • Use various tools such as: SQL Server Integration Services, AWS, SQL Server, and Power BI.
  • Assist in the migration of new technology from trial phase to production rollout
  • Additional duties as assigned

Technical Requirements

  • Post-secondary education in the field or Business and/or Information Technology
  • Minimum 3 years’ experience in a similar business-focused role
  • Proficiency in Power BI and other Microsoft BI tools
  • Knowledge of data modeling, data warehousing, and SQL
  • Experience with DAX (Data Analysis Expressions) for creating measures and calculated columns in Power BI
  • Excellent communication skills to convey insights to both technical and non-technical audiences

Business Requirements

  • Data analysis skills, ability to produce reports easily from raw data; and an interest in identifying problems and solutions
  • Strong analytical skills to interpret complex data
  • Ability to write advanced queries and perform in-depth data analysis
  • Attention to detail and problem-solving abilities

Cultural Requirements

  • Strong team collaborator with exceptional communication and organizational skills

As a member of the OSCO Construction Group, we offer comprehensive compensation package including health and dental coverage, life insurance, RRSP and tax-free savings account options. Additionally, we offer educational scholarships to dependents of employees, health & wellness programming and team celebratory events.

About OSCO

The origins of the OSCO Construction Group go back to 1955 when Ocean Steel & Construction Ltd. was founded in Saint John, New Brunswick. Since that time, the OSCO Construction Group has grown to encompass four main operating sectors: Steel, Concrete, Construction and Corporate. Within these sectors lie an ever-expanding number of construction-related companies and divisions, serving a growing market area and employing over twelve hundred employees.