Match score not available

IT - Business Intelligence Developer IV

Remote:

Full Remote

Contract:

Fixed term

Experience:

Senior (5-10 years)

Work from:

Canada

Offer summary

Qualifications:

Microsoft PL-300 certification preferred, Bachelor's degree in technology, finance, business or equivalent, 8+ years of experience with PowerBI and Power Automate, Working knowledge of DAX, SQL, XML, XLSX, CSV, Data warehouse experience.

Key responsabilities:

Design and support PowerBI dashboards/apps for user interaction.
Build data models for analysis from various formats.
Ensure data security in dashboard functionality.
Provide actionable insights based on KRIs and KPIs.
Maintain documentation and automate communication using Power Automate.

ICONMA Human Resources, Staffing & Recruiting Large https://www.iconma.com/

1001 - 5000 Employees

See more ICONMA offers

Job description

IT - Business Intelligence Developer IV

Location: Remote
Duration: 12 months with Possible Extension/ Possible Contract to hire

Description:
Candidate Profile Details:
Degree/Certifications Required: Microsoft PL-300 certification preferred
Bachelors degree in technology, finance, business or equivalent
Years of experience: 8yrs
% Interaction with Stakeholders: 30%
Project Scope: BI reporting
Team Size: 2ppl
Selling Points of Position: Working within a leading FI organization
Background : implementation, administration, configuration and support of PowerBI dashboards/apps and Power Automate scripts

Responsibilities :
Design, engineer, deploy, and support actionable PowerBI dashboards/apps that are part of the Workforce Identity and Access Management organization. Design must be visually friendly, easy to navigation and inspire action by the user(s).
Design multi-dimension data models leveraging data in many formats (sql, xml, xlsx, csv, sharepoint directories, websites, etc.) that allow in-depth analysis
Due to sensitivity of the data, work with business partners to secure dashboards/apps data in a secure manner via AD groups and row level security based on data and role
Work with our business partners and internal teams to ensure insights provided are actionable and meaningful based on key risk indicators (KRIs) and key performance indicators (KPIs)
Build out a data management structure to allow re-use of data across multiple dashboards
Automate the communication of PowerBI dashboards/apps to a dynamic targeted audience through e-mail and Teams via the Power Automate including dynamic tables for user consumption
Understand business, application, and security requirements provided by customers and translate these into technical specifications. Produce enterprise-level reporting to meet these requirements.
Be our Subject Matter Expert on PowerBI and Power Automate.
Provide consultation to business partners on best practices and standardization when building out dashboards/apps.
Conduct unit testing and troubleshooting to ensure quality audit-proof data is provided
Ensure successful deployment of our business intelligence strategy in collaboration with people leader, Power Platform team and business partners
Create and maintain documentation (where required) on logic and processed followed to build out the dashboard and communicate with the target audience(s)
Research and put forward new recommendations to create, automate and improve processes

Must Have :
8+ years of experience in implementation, administration, configuration and support of PowerBI dashboards/apps and Power Automate scripts
PowerBI design including dashboards and apps
Power Automate
Working knowledge of DAX and Power Query
Working knowledge of SQL data manipulation
XML, XLSX, CSV and other data source experience
Working knowledge of data warehouse

Education & Experience
Strong coordination and interpersonal skills as this role require significant interaction with different stakeholders across the Workforce IAM organization.
Strong oral and written communication skills and ability to simplify and explain technical issues into understandable business language.

Power Query Yes

Skills
Advanced experience in creating reports/dashboards in Power App, Power BI and related applications 8 years
Advanced knowledge of SQL 8 years
Datawarehouse experience 8 years
Experience building Power BI reports and Power Automate flows to support reports 8 years
Experience in querying data from various source (CSV, XLS) SQLquery skills prferred 5 years
Visualization tools/PowerBI 5 years
XML 5 years

As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.