Power Platform -Senior

Job Description of Power Platform Engineer

Job description

At EY, you ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you. And we re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

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.

The opportunity

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, youll also have

Bachelors 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.