EY TR-Senior 

India, Karnataka, Bengaluru 

431815348

PowerApps + Power BI Developer – Technology Assurance

As Risk Assurance Senior, you’ll contribute technically to Risk Assurance client engagements and internal projects. An important part of your role will be to assist fellow Seniors & Managers while actively participating within the client engagement Similarly, you’ll anticipate and identify risks within engagements and share any issues with senior members of the team. In line with EY commitment to quality, you’ll confirm that work is of high quality and is reviewed by the next-level reviewer. As a member of the team, you’ll help to create a positive learning culture and assist fellow team members while delivering an assignment.

We’re looking for professional having at least 3 years or more of experience. You’ll be part of a cross-functional team that’s responsible for the full software development life cycle, from conception to deployment. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.

Skills and Summary of Accountabilities:

• Design, develop, and implement solutions using the full capability of the Microsoft Power Platform (Power BI, Power Apps, Power Automate, and Power Virtual Agents).
• Identify, design, and implement internal process improvements, automating manual processes wherever possible employing advanced data modelling techniques.
• Familiarity with Common Data Service (CDS), Connectors, Power Apps formulas and app development tools, such as Microsoft Visual Studio.
• Expert in automating refresh schedules, triggering workflows.
• Develop custom connectors and APIs to extend the functionality of Power Apps and Power Automate and integrate with third-party services.
• In Power Automate Workflow Automation, Design and implement automated workflows using Power Automate to automate repetitive tasks, notifications, approvals, data synchronization, and integration between various systems and services.
• Implement security measures and access controls to protect sensitive data within Power Apps and Power Automate workflows.
• Create dynamic and static reports using Power BI and provide insights, Utilize Python code to extract, clean, and manipulate large datasets.
• Develop complex DAX calculations and measures to address advanced business logic within Power BI reports.
• Exposure working in client facing roles, collaborate with cross functional teams including internal audits, IT security and business stakeholders to assess control effectiveness and facilitate remediation activities.
• Good to have experience in IT Controls, Risk and Compliance.
  • Testing of internal controls such as IT general controls, IT application controls, IPE related controls, interface controls etc.
  • Design IT Risk Controls framework such as IT SOX.

To qualify for the role, you must have.

• At least 3 years of experience with Microsoft Power Platform.
• Practical experience in process Automation with UiPath, Power BI, Power Apps, Power Automate, and Power Virtual Agent.
• Integrate Power Apps and Power Automate with other Microsoft 365 apps (such as SharePoint, Teams, Excel2, Alteryx), as well as external data sources (e.g., SQL databases, APIs, cloud services) to facilitate data flow and real-time data access.
• In-depth knowledge of Python, SQL for data manipulation and scripting, and exposure towards R, SAS, Java/C# or Scala, Hive, Pig
• In-depth understanding of Power BI Desktop, Power BI Service, and Power BI DAX.
• Utilize DAX to create calculated columns, tables, and measures that enhance the data model for more in-depth analysis. Advanced DAX concepts include the use of variables, table functions, and dynamic measures.
• Familiarity with Azure, Microsoft 365 Suite, and SQL Server.
• Implement Row Level Security (RLS) and other security measures to ensure data privacy and compliance in Power BI, Power Apps.
• Proven capability to develop robust, user-friendly data analytics solutions to optimize the extraction, transformation, and reporting of data from a wide variety of data sources.
• Comprehensive knowledge of ETL, data modelling, data visualization, and performance optimization.
• Proficiency in creating visual reports, dashboards and KPI scorecards in Power BI.

Ideally, you'll also have

• Bachelor's Degree or above in mathematics, information systems, statistics, computer science, Data Analytics, or related disciplines.
• Relevant certifications in the Power Platform (PL-300, PL-900) are considered a plus.
• Experience with AI/ML is a plus.
• Ability to communicate clearly and concisely and use strong writing and verbal skills to communicate facts, figures, and ideas to others.

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.