bi engineer

Job ID:

6a6d4c3

Location:

Montreal

Published:

1 day ago

Salary 115000 - 100000 CAD

Company

Q1 Technologies

Website

www.q1tech.com

Headquarters

CEO

Revenue

Type

Sector

Founded

Job Description

Job Requirement:

Experience with Power BI development, visualizations and deployment (8+ years).
· Experience with the Microsoft BI stack, including TSQL, PowerBI, Power Query, DAX, M, MDX and, SSAS, SSRS, SSIS (8+ years).
· Experience with configuration / management of Microsoft Power BI Service Experience extracting, manipulating and analyzing data via Dataflows, Datamarts, Dashboards and Apps to recommend and/or take action. (8+ years).
· Demonstrated SQL development experience by writing queries and procedures and also using functions to create curated data for use in reporting.
· Excellent written, verbal and presentation skills.
· AWS Cloud and/or Snowflake experience is a plus
· Understand glossaries and terminologies in end-to-end skills and financial industry
· Experience documenting business requirements, processes and workflows (5+ years)
· Advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming is preferred.
· Must be detail oriented, and able to work independently and self-prioritize tasks.
· Demonstrated experience in working with relational databases: SQL Server (8+ years).
· Bachelor's degree in Computer Science, Design, Statistics, or equivalent.
· Microsoft Power BI Certification is a plus
Responsibilities:
· Participate in discussions with business partners to define key business questions, translate them into necessary requirements documentation and develop visual data-driven solutions which answer those questions
· Develop reports, thoughtful visualizations , dashboards and KPI scorecards using Microsoft's Power BI and Azure stack employing leading visualization techniques
· Perform UX design activities and Power BI navigation features (e.g. bookmarks, drill-throughs) to guide end-users through a data-driven story
· Develop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasets
· MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX
· Work with our internal customers to manage User Acceptance Testing (UAT) processes and address their feedback
· Power Query and coding fundamentals (ability to use M language to build loops, pull APIs, etc.)
· Assist with governance and deployment of Power BI , including administration, content distribution/sharing, training and support
· Proficient Data Architecture and Modeling experience (Structuring Tables, Attributes, and Relationships [One-to-One, One-to-Many, Many-to-One, Many-to-Many])
· Champion the leading Power BI design methodology and best practices
· Extract data from various data sources ; perform exploratory data analysis, cleanse, reshape, and aggregate data
· Evangelize data analytics best practices among peers and stakeholders
· Proactively monitor and evaluate the impact of monthly Power BI releases.
· Conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and priorities