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.
- 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.
Skills Required
- 4+ years of experience in data analytics, audit analytics, automation or related disciplines
- Expertise building Microsoft Copilot and Copilot Studio enabled solutions
- Experience with Power BI and DAX for BI and reporting
- Advanced SQL skills and experience with Microsoft SQL Server
- Experience with Snowflake and cloud data platform migrations
- Experience using Alteryx for data preparation and analytics
- Experience designing ETL/ELT, data transformation, validation, and automated analytics workflows
- Experience with Power Automate and automation/workflow technologies
- Familiarity with ERP systems including SAP S/4HANA and Salesforce
- Experience working with large datasets, enterprise applications, and governed data environments
- Proficiency in Python or R for analytics/automation
- Ability to translate audit/business requirements into reliable analytics, dashboards, automated tests, and workflows
- Strong analytical thinking, attention to detail, written communication, and stakeholder collaboration skills
- Experience developing automated and semi-automated testing routines for SOX and continuous auditing
- Preferred certifications: Power BI Data Analyst Associate, SnowPro, Alteryx Designer, Microsoft AI/Copilot/Power Platform, CIA, or CISA
What We Do
Celanese is a global leader in chemistry, producing specialty material solutions used across most major industries and consumer applications. Our businesses use our chemistry, technology and commercial expertise to create value for our customers, employees and shareholders. We are committed to sustainability by responsibly managing the materials we create for their entire lifecycle and are growing our portfolio of sustainable products to meet increasing customer and societal demand. We strive to make a positive impact in our communities and to foster inclusivity across our teams. Celanese is a Fortune 500 company that employs approximately 12,400 employees worldwide with 2023 net sales of $10.9 billion. For more information, visit www.celanese.com. For Celanese product news about our Engineered Materials offerings, follow @CelaneseEngineeredMaterials on LinkedIn.
