Data Analyst - Power Apps, Microsoft Dataverse, and Power BI

Job Description:

• Experience with Microsoft Power Apps, Microsoft Dataverse, and Power BI

Job Summary:

• The Identity and Access Management (IAM) Operations team is seeking a Data Analyst to join the ISAT Data & Automation team.
• This role will focus on analyzing identity data, delivering actionable insights, and building scalable automation and reporting solutions using low-code/no-code platforms.
• The ideal candidate is highly analytical, technically curious, and experienced in working with large datasets, developing dashboards, and automating workflows.
• This candidate will operate within an agile model, working a Jira-driven backlog to prioritize and deliver data, reporting, and automation capabilities that enhance IAM operational efficiency and risk visibility.

Key Responsibilities:
Data Analysis and Insights

• Analyze large, complex identity and access datasets to identify trends, anomalies, and risk indicators
• Transform raw data into meaningful insights to support IAM operational decision-making
• Perform data validation, cleansing, and reconciliation across multiple systems and sources

Dashboarding and Reporting

• Design and develop interactive dashboards and reports using Power BI
• Create user-friendly visualizations to communicate key IAM metrics, KPIs, and compliance data
• Maintain and enhance existing reporting solutions to improve accuracy and usability

Automation and Low-Code Solutions

• Build workflow automations using Power Automate and Power Apps
• Develop low-code applications to streamline IAM operational processes
• Identify opportunities to reduce manual effort and improve operational efficiency through automation

Data Engineering and Integration

• Connect to and extract data from various structured data sources (e.g., databases, APIs, enterprise systems)
• Utilize tools such as Alteryx to prepare, blend, and transform datasets
• Support development of scalable data pipelines and reusable data assets

Agile Delivery Execution

• Work from a Jira backlog, managing assigned stories and tasks in an agile framework
• Collaborate with team members and stakeholders to refine requirements and deliver incremental value
• Provide regular updates on progress, risks, and dependencies

Stakeholder Collaboration

• Partner with IAM operations, engineering, and risk teams to understand data needs
• Translate business requirements into technical data and automation solutions
• Deliver clear, concise communication of findings and solutions

Must Haves:

• Experience with large data sets
• Power Apps- Power Bi, Power Automate
• Good Communication (written & verbal)
• Experience writing business cases
• Large Financial Services Exp or Regulated Industry
• Experience with Data Analytics and Manipulation

Nice to have:

• Jira
• SQL

• IAM