Power BI Developer

Title: Power BI Developer

Location: Mississauga, ON (Onsite)

Duration: Long Term Contract

Recent Financial / Banking domain experience is MUST. Final round of interview will be in person

Job Description:

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.