Job Description

Overview

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.

This position will be 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.

Qualifications

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