Senior Lead, Power BI Developer

• Builds various reporting dashboards using the most appropriate data extraction, data cleaning and data visualization techniques.
• Provides value through insights, reporting and data visualization techniques. Selects, configures and implements analytics solutions for consistency and repeatability.
• Researches and applies continuous improvement in data visualization by identifying trends and patterns to transform raw data into actionable business insights.
• Works with different teams, management and stakeholders to enhance the usability and aesthetic appeal of data analytics solutions deployed in the organization.
• Translates business needs to technical specifications and evaluates existing data visualization systems in order to improve them.
• Develops data visualizations of "large" amounts of data that facilitate the intuitive presentation of data to decision makers.
• Documents data flow, systems and processes to improve the design, implementation and management of business/group processes.
• Develops tools and delivers training programs for use of reporting tools and self-serve analytics by non-analytical end users; may include delivery of training to audiences.
• Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus.
• Exercises judgment to identify, diagnose, and solve problems within given rules.
• Works independently on a range of complex tasks, which may include unique situations.
• Broader work or accountabilities may be assigned as needed.

Qualifications:

Intermediate to Advanced level of proficiency In Power BI Data Sources:

• Minimum of 5 - 7 years experience in a professional capacity
• Creating, manage, and publish Power BI Data Sources
• Intermediate to advanced DAX skills such as creating
• Creating DAX Measures
• Leveraging variables in measures
• Managing / adding and removing filters in measures
• Creating calculated fields in tables
• Creating calculated tables
• Tuning data source design and measures for maximum performance

Intermediate to Advanced level of proficiency In Power BI Visualizations:

• Minimum of 5 - 7 years experience in a professional capacity
• Creating, manage, and publish Power BI dashboard files
• Intermediate to advanced visualization skills including
• Creating advanced charts
• Maximizing interactivity of the visualizations
• Creating large / complex easy to navigate dashboard
• Managing / adding and removing filters on both the page and visual levels
• Creating and leveraging parameters
• Creating and leveraging bookmarks
• Creating and leveraging templates

Intermediate to Advanced level of proficiency In SAS:

• Minimum of 5 - 7 years experience in a professional capacity
• Connect to databases and extract to SAS and or load data from SAS
• Perform full ETA steps including Data Transformations
• Ability to automate processes to be scheduled and run regularly

Foundational level of proficiency:

• Technical design optimization.
• Decision Making.
• Systems Thinking.
• Data visualization.
• Data storytelling.
• Data mining.
• Illustration.
• Creative thinking.
• Problem Solving.

Intermediate level of proficiency:

• Insights design.
• Insights development and reporting.
• Verbal & written communication skills.
• Collaboration & team skills.
• Analytical and problem solving skills.
• Data driven decision making.
• Typically between 4 - 6 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
• Technical proficiency gained through education and/or business experience.

Advanced level of proficiency:

• Insights design.
• Insights development and reporting.
• Typically between 5 - 7 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
• Deep knowledge and technical proficiency gained through extensive education and business experience.