BI/Reporting Developer - Contract role

at  Bonafide Info Systems Inc

JOB SUMMARY

This position is for a Business Intelligence / Reporting Engineer with a robust background in SQL and data warehousing for enterprise-level systems. The ideal candidate must possess strong Power BI skills, particularly in developing dashboards and canned reports. The role involves designing and developing reports, dashboards, and ad-hoc queries. The candidate should be comfortable collaborating with business users and exhibit business analyst expertise.

Responsibilities:

• Design and develop reports, dashboards, and ad-hoc queries.
• Collaborate with business users to understand and meet their requirements.
• Utilize data modeling techniques using Power Query/Power Pivot.
• Develop and optimize DAX queries.
• Use Power BI Report Builder and/or create Paginated Reports.
• Manage and query SQL Server or any other relational databases.

Must-Have Skills:

• Data modeling using Power Query/Power Pivot.
• Proficiency in DAX.
• Experience with Power BI Report Builder and/or Paginated Reports.
• Strong SQL skills, particularly with SQL Server or similar relational databases.

Nice-to-Have Skills:

• Working knowledge of Data Flows.
• Experience with PBRS (Power BI Report Server).
• Familiarity with Power On.
• Experience with Snowflake data warehouse.

Qualifications:

• Minimum of 7+ years of combined experience in data warehousing, business intelligence, analytics, and reporting systems.
• At least 3+ years of experience in relational and multi-dimensional (OLAP) data modeling.
• Proficiency in SQL, including relational and dimensional database structures and query optimization.
• Strong knowledge of Fixed Income, Equity, and Derivative businesses.
• Ability to analyze user requirements, make recommendations, and implement solutions.
• Self-driven with the ability to troubleshoot and provide quick resolutions to issues.
• Experience with full project management and development life cycle.
• Strong oral and written communication skills.
• Strong presentation and interpersonal skills.
• Ability to prioritize and manage tasks in a high-pressure environment.

Join us in creating innovative solutions that drive success for our clients!
Job Type: Full-time

Schedule:

• Monday to Friday

Work Location: Hybrid remote in Mississauga, ON L5R 3G

• Design and develop reports, dashboards, and ad-hoc queries.
• Collaborate with business users to understand and meet their requirements.
• Utilize data modeling techniques using Power Query/Power Pivot.
• Develop and optimize DAX queries.
• Use Power BI Report Builder and/or create Paginated Reports.
• Manage and query SQL Server or any other relational databases