- In-person participation is required throughout the year
- Team and company-wide offsites are held multiple times annually to foster collaboration, connection, and alignment
- Attendance is expected and fully supported
- The Senior Data Analyst, Internal Audit IT will work within the IT Internal Audit team to pull, test, and analyze key systems and tools data
The ideal candidate will be capable of measuring system and model performance, conduct data analysis to test the design and operational effectiveness of key Information Technology (IT) and security controls, and perform comprehensive testing of system changes
- The ideal candidate will work highly independently, identifying creative solutions to test complex data sets and data flows, and generating accurate data extracts and reports that will support the internal audit team in their control testing
- Data Analysis for IT and Security Control Testing :
- Perform in-depth data analysis to assess the design and operational effectiveness of key IT and security controls via writing complex, yet efficient and reusable SQL code
- Identify potential areas of risk and provide recommendations for improvement
- System / Model Change Testing :
- Conduct detailed testing of system or model changes to validate their impact and ensure they meet compliance and performance requirements
- Document and communicate the results of testing to relevant stakeholders
- Proactively seek out and address challenges in data testing and analysis, ensuring robust and reliable results
- Complex Data Extracts and Reports :
- Produce data extracts and reports via SQL from a variety of sources that will support the internal audit team in their control testing
- Translate vague and complex data requests into clear and actionable requirements
- Ensure data exports are accurate, comprehensive, and aligned with audit requirements
- ETL Process Testing :
- Test data ETL (extraction, transformation and load) from upstream production systems into the data repository, and from the data repository into the Enterprise Tools
- Validate data completeness and accuracy during ETL process
- Develop and Improve Metrics and Dashboards :
- Design, develop, and enhance metrics and dashboards to measure the performance of various systems within the organization
Ensure that metrics and dashboards provide actionable insights for the Internal Audit team