Data & Automation Analyst - Internal Audit

About the role

This position develops and supports Internal Audit’s data and testing requirements through AI-driven solutions, advanced analytics, and intelligent automation. The role will design 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 is on-site at the Irving, TX office.

Responsibilities

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

Requirements

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

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 Qualifications

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