Business Intelligence Engineer

ALLTECH CONSULTING SVC INC; Mississauga; On-site; CAD 80,000 - 110,000; Full time

Job summary

A consulting firm in Peel Region, Mississauga is looking for a Business Intelligence / Reporting engineer. The ideal candidate will have strong Power BI experience, with 6+ years in data warehousing and analytics. Responsibilities include the design and development of reports and dashboards. Strong SQL skills and a bachelor's degree are required for this position.

Qualifications

• 6+ years of experience in data warehousing/business intelligence/analytics.
• 3+ years of relational and multi-dimensional data modeling.
• Strong knowledge of Fixed Income, Equity, and Derivative businesses.

Responsibilities

• Design and develop reports and dashboards using Power BI.
• Analyze user requirements and implement solutions.
• Provide quick resolutions to issues and manage full project lifecycle.

Skills

SQL

Power BI

Data modelling

DAX

Report building

Data warehousing

Education

University bachelor's degree in Computer Science or related field

Tools

SQL Server

Power Query

Paginated Reports

Snowflake

Job description

Important Skills:

This position is for a Business Intelligence / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. Strong Power BI experience is a must especially in developing dashboards and canned reports.

The candidate will be responsible for the design and development of reports, dashboards and ad-hoc queries. The position calls for someone that is comfortable working with business users along with business analyst expertise. Experience with the following technologies will be required:

• Must Haves
  • Data modelling using (Power query/power Pivot)
  • DAX
  • Power BI report builder and/or Paginated Reports
  • SQL Server or any other relational database

• Nice to Have
  • Working knowledge of Data flows
  • PBRS
  • Power On
  • Snowflake datwarehouse is a plus

Qualifications:

• Minimum 6+ years of combined experience in data warehousing/business intelligence/analytics and reporting systems.
• Minimum 3+ years of relational and multi-dimensional (OLAP) data modeling Proficiency in the use of SQL, including relational and dimensional database structures, query optimization, specifically with SQL Server
• Strong knowledge of Fixed Income, Equity and Derivative businesses
• Strong ability to analyze user requirements, make recommendations and implement solutions
• Self-driven and should be able to troubleshoot and provide quick resolutions to issues.
• Full project management and development life cycle experience
• Strong oral and written communication skills
• Strong presentation and interpersonal skills
• Ability to prioritize and execute in a high-pressured environment
• University bachelor degree (Computer Science, Information Systems or Computer Engineering)