Job Title: IT – Business Intelligence Developer V
Location: Toronto or Mississauga, ON (Hybrid)
Estimated Duration: 12 Months
Responsibilities
The Workforce Identity and Access Management (IAM) team has an enterprise-wide focus on identity, authentication, authorization, and IAM governance. This ensures users have the right access at the right time for the right reasons. This position is for a Senior Business Intelligence Analyst reporting to the Senior Manager, Information Security. This role is to act as a functional team member for the Governance and Analytics team the provide outcome driven actionable insights across the various information security principles and related software. This primary focus is on reducing risk and improving the banks Workforce IAM security posture.
Below are the responsibilities for this candidate:
- 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.
- Leverage artificial intelligence tools such as CoPilot, VSCode, etc. to reduce development build time and improve quality
- Create workflow management scripts through PowerApps to improve engagement of data gathering from business partners and internal customers.
- Design, engineer, deploy, and support outcome driven 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.
- Assist in developing solutions to ingesting and managing extremely large datasets (100M+ records) to provide an optimal user experience for the Power Platform users
- 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.
- 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, Power Automate and PowerApps. 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 on logic and processes 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 Hard Skills:
- 10+ years of experience in implementation, administration, configuration and support of PowerBI dashboards/apps, Power Automate scripts and PowerApps
- 2+ years of experience with AI tools such as CoPilot and VSCode
- Extensive experience in:
- Power Automate
- Power Apps
- PowerBI design including dashboards and apps
- Building complex DAX and Power Query
- SQL data manipulation
- Strong experience managing large data sets (100 million+)
- SON, XML, XLSX, CSV and other data source experience
- Working knowledge of data warehouse including data management optimization
SOFT SKILLS:
- Strong communication skills (written and verbal)
- Strong time management, proactive and takes initiative
- Attention to detail and someone who is a self-starter and adaptable
- Strong documentation skills
- Strong problem-solving and analytical thinking skills
NICE-TO-HAVE
- Preferred information security knowledge (lifecycle management, privileged access and authN/authZ)
- Banking or financial institution experience
- Microsoft PL-300 certification
The pay range that the employer reasonably expects to pay for this position is between CA$72.00 and CA$80.00
Our voluntary benefits offering includes medical, dental, vision and retirement benefits.
This posting is for an existing vacancy.If you believe this post to be fraudulent, please report by clicking here
Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.
We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!