Ascension LLC is seeking a detail-oriented and analytically driven Audit Data Analyst to support a federal client’s OMB Circular A-123 Internal Controls Testing Program. This role is critical in ensuring that internal control testing is statistically valid, data-driven, and compliant with federal financial management standards.

The ideal candidate will bring a blend of audit domain expertise and advanced data analytics capability, enabling them to design and execute sampling methodologies, analyze financial and operational datasets, and support control testing activities across key business processes and IT systems.

This position plays a vital role in helping the client achieve audit readiness, maintain compliance with federal statutes, and strengthen internal control environments.

Position Summary

The Audit Data Analyst will support internal control testing (Test of Design and Test of Operating Effectiveness) by developing statistical samples, performing data analysis, and validating control effectiveness across financial processes and systems.

This role requires a professional who is:

• Highly analytical and methodical
• Skilled in translating audit requirements into data-driven testing approaches
• Comfortable working with large datasets and financial systems
• Able to operate independently in a structured yet evolving federal environment

The candidate will support testing activities aligned with:

• OMB Circular A-123
• FMFIA and ATDA requirements
• Federal financial reporting standards

The role will leverage tools such as:

• Microsoft Excel (advanced analytics)
• Power BI or Tableau
• Oracle Federal Financials / OBI (preferred)
• Statistical sampling techniques and audit tools

Day-to-Day / Expected Activities

• Develop statistically valid sampling methodologies for internal control testing
• Perform data extraction, cleansing, and validation from financial systems
• Analyze datasets to support control testing and audit assertions
• Execute test procedures (inquiry, inspection, reperformance, analytics)
• Support Test of Design (TOD) and Test of Operating Effectiveness (TOE) activities
• Create data-driven audit workpapers and supporting documentation
• Identify anomalies, trends, and control deficiencies within datasets
• Prepare reports, dashboards, and visualizations to communicate findings
• Collaborate with auditors and SMEs to interpret results and refine testing approaches
• Support development of risk-based testing strategies and audit plans
• Ensure all analysis aligns with federal audit and internal control standards
• Participate in status reporting and stakeholder briefings