Python -Senior

1mo ago

Job
Full-time
Mid & Senior Level
Data
IT & Cybersecurity

AI generated summary

You need client-facing experience, IT controls knowledge, Power Platform skills, Python proficiency, and at least 3 years in process automation. Certifications and data privacy understanding are a plus.
You will support Risk Assurance engagements, design IT controls, collaborate across teams, automate processes using Power Platform, test internal controls, and create insightful reports with Python and Power BI.

Requirements

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.
Design IT Risk Controls framework such as IT SOX.
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.
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.
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.

Responsibilities

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.
You will collaborate closely with cross functional teams to address issues, to deliver seamless support to clients.
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.
Design IT Risk Controls framework such as IT SOX.
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.

FAQs

What is the required experience for this position?

Candidates are expected to have at least 3 years of experience in relevant fields, particularly with the Microsoft Power Platform.

Is knowledge of Python necessary for this role?

Yes, knowledge of Python is required for data manipulation and scripting.

Will I be working with Power BI in this role?

Yes, experience with Power BI is crucial, including creating reports, using DAX calculations, and implementing data visualization techniques.

What kind of projects will I be involved in?

You will contribute to Risk Assurance client engagements, internal projects, and assist in identifying and mitigating engagement risks.

Are there opportunities for professional development?

Yes, EY promotes a positive learning culture and encourages employees to assist fellow team members while delivering assignments.

Do I need specific certifications for this position?

Relevant certifications in the Power Platform, such as PL-300 or PL-900, are considered a plus.

Will I be expected to collaborate with other teams?

Yes, collaboration with cross-functional teams, including internal audits, IT security, and business stakeholders, is essential to address control effectiveness and remediation activities.

Is experience in IT Controls or Risk and Compliance necessary?

Yes, candidates must have knowledge and experience in IT Controls and Risk and Compliance frameworks.

What educational background is preferred for this role?

A Bachelor's Degree or above in mathematics, information systems, statistics, computer science, or related disciplines is preferred.

Are there security measures that need to be implemented in Power Apps and Power Automate?

Yes, implementing security measures and access controls to protect sensitive data within Power Apps and Power Automate workflows is required.

EY

Accounting

Industry

1-10

Employees

Mission & Purpose

EY exists to build a better working world, helping create long-term value for clients, people and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today. Find out more about the EY global network http://ey.com/en_gl/legal-statement