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 will collaborate closely with cross functional teams to address issues, to deliver seamless support to clients. 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:

Exposure to working in client facing roles, collaborating with cross functional teams including internal audits, IT security and business stakeholders to assess control effectiveness and facilitate remediation activities.
Must have knowledge/understanding of experience in IT Controls, Risk and Compliance.

a) Design IT Risk Controls framework such as IT SOX.

b) Testing of internal controls such as IT general controls, IT application controls, IPE related controls, interface controls etc.

Knowledge on implementing solutions using the full capability of the Microsoft Power Platform (Power BI, Power Apps, Power Automate, and Power Virtual Agents).
Interacting with the Architects, Analysts, and other IT delivery teams to understand the functional requirements on Identifying, 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 Microsoft Visual Studio etc.
Knowledge on 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, work on 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.
Complex DAX calculations and measures to address advanced business logic within Power BI reports.

To qualify for the role, you must have.

Good to have knowledge of

At least One - IT General Controls, IT Automated Controls, and Service Organization Controls Reporting (SOCR - SSAE 16 / ISAE 3402) SOC 1, 2, & 3 Reporting

Able to perform independent security configuration review of common operating systems and databases - Windows, Unix, DB2, AS400, SAP R3ECC/HANA, Mainframe, SQL, Oracle.

At least 3 years of experience with Microsoft Power Platform.
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.
Knowledge of Python, SQL for data manipulation and scripting, and exposure towards R, SAS, Java/C# or Scala, Hive, Pig
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.
Knowledge on Row Level Security (RLS) and other security measures to ensure data privacy and compliance in Power BI, Power Apps.
Comprehensive knowledge of ETL, data modelling, data visualization, and performance optimization.
Knowledge on 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, or related disciplines.
IT audit knowledge for a financial audit - Control frameworks such as COSO, related regulations including SOX and J-SOX
Relevant certifications in the Power Platform (PL-300, PL-900) are considered a plus.
Provide high quality client services by directing daily progress of engagement work, informing engagement manager of engagement status, and managing staff performance.