Data & Automation Analyst (Advanced Specialist, Data Analytics)

The Data & Automation Analyst (Advanced Specialist, Data Analytics) is responsible to develop and support the Internal Audit Data and testing requirements through AI-driven solutions, advanced analytics, and intelligent automation. This role will develop and deploy scalable solutions that enhance SOX testing, continuous auditing, audit reporting, risk monitoring, and data-driven decision-making. The ideal candidate combines expertise in Microsoft Copilot, Power BI, SQL, Snowflake, Alteryx, and ETL/ELT technologies with a strong understanding of Risk and controls. This role will design repeatable analytics, automate audit activities, and enable auditors with actionable insights that improve efficiency, coverage, and audit quality., * Build and enhance Microsoft Copilot-enabled solutions that support audit testing, SOX control procedures, evidence summarization, issue tracking, and reporting activities.

• Develop automated and semi-automated testing routines for SOX, operational audits and continuous auditing.
• Create reusable analytics workflows, data models, dashboards, and audit testing templates.
• Identify opportunities to reduce manual audit effort through automation, workflow standardization, process mining, and data-enabled testing.
• Support modernization of audit analytics platforms, including migration of existing Microsoft SQL Server assets to Snowflake.
• Partner with auditors and business stakeholders to translate audit requirements into practical analytical and automation solutions.
• Provide technical guidance and working support to auditors using analytical procedures, dashboards, automated testing, and Microsoft Copilot-enabled tools.
• Stay current with trends in Microsoft Copilot, generative AI, audit analytics, data visualization, cloud data platforms, and automation technologies.

• Build and enhance Microsoft Copilot-enabled solutions that support audit testing, SOX control procedures, evidence summarization, issue tracking, and reporting activities.
• 4+ years of experience in data analytics, audit analytics, automation or related disciplines.
• Demonstrated ability to translate business and audit requirements into reliable analytics, dashboards, automated tests, and repeatable workflows.
• Experience working with large datasets, enterprise applications, and governed data environments.
• Strong analytical thinking, attention to detail, written communication, and stakeholder collaboration skills

Technical Skills

• AI & Automation: Microsoft Copilot, Copilot Studio, AI agents, Power Automate.
• ERP Knowledge: SAP S/4HANA, ERP table structures, Salesforce.
• Data Platforms: Snowflake, Microsoft SQL Server, Advanced SQL, Alteryx, Python, R, ETL/ELT design, data transformation, data validation, and automated analytics workflows.
• BI & Reporting: Power BI, DAX, data modeling.

Preferred Certification

• Power BI Data Analyst Associate, SnowPro, Alteryx Designer, Microsoft AI/Copilot/Power Platform certifications, CIA, or CISA.