Senior Data Analytics Consultant - Public Sector, Federal Civilian

Job Summary:

BDO is seeking an experienced consultant to support Data Analytics and Process Automation at a level in line with federal financial audit and accounting professional standards. The ideal candidate for this role must know how to operate and maintain existing data analytic scripts designed in Audit Command Language (ACL).

Job Duties:

• Uses data analytics tools to enhance IT testing methodologies and processes
• Leads, develops, and executes data driven control tests to identify patterns, anomalies, key variables, and relationships
• Develops data analytics in a software platform to implement the design
• Designs, develops, and implements data analytics to improve and remediate internal controls and data quality across business processes.
• Verifies data sets and documentation of identified limitations or risks to the data sets, methods for reconciling missing or inconsistent information, follow-up on procedures employed, and methods to update data analytic scripts or reports
• Operates and maintains existing data analytic scripts designed in Audit Command Language (ACL):
  
  
  
  • Revises the logic and data analytic reports to identify potential instances of data anomalies
  
  
• Designs new data analytic scripts and reports in ACL, to to collect, classify, analyze, and interpret data to reveal patterns, anomalies, key variables and relationships
• Develops automation scripts in UiPath Studio, Microsoft Power Automate, or similar software applications, that can ultimately transition to the end-user and run independently
• Develops transition scripts to end-users via an orderly process, to include training, and provide ongoing user support and maintenance for automation scripts
• Develops dashboards that, at minimum, visually communicate if analytics and RPA designed and deployed are working and achieving the goals of risk reduction, workload reduction, and increased passing test results
• Provides professional project management services to enable the government to plan, prioritize, implement timely, monitor, and report accurately on the status of data analytics development and operations and robotic process automation development and maintenance
• Manages and oversees daily development, operation, and maintenance of automated solutions and assist process owners with identifying effective solutions and developing those solutions into appropriate level project milestones, tracking action items from remediation meetings, and provides status information and reports to proactively identify remediation challenges and status reports to executive leadership
• Identifies appropriate information systems test of operating effectiveness testing and provides insight into potential information systems risks while testing information system security
• Leads and/or participates in walkthrough meetings while taking detailed notes and identifying and documenting controls
• Leads and/or participates in the performance of audit work for specific information systems
• Delivers a full range of services that uses their educational background, experience, and organizational skills while serving BDO's dynamic public sector client base
• Adapts to a changing client environment while meeting client expectations
• Manages priorities and works effectively to initiate correspondence and task completion and supports multiple efforts through flexible multi-task coordination
• Provides summary recommendations to team leadership regarding assigned work stream
• Applies fundamental industry knowledge and standards to support client reviews, improvements, and/or implementations
• Communicates and maintains relationships with key client personnel to ensure shared understanding of processes, operations, and functions
• Prepares presentations, briefings, and actively participates in client meetings and day-to-day interactions
• Communicates with team management through effective status reporting and demonstrates ownership and accountability for assigned task areas and work products
• Establishes professional rapport with clients and other organizations
• Reviews work products for technical accuracy, deliverable quality, and overall value to the client
• Attends relevant training, seminars, and/or conferences to stay current with technical skills that align with client's needs and changes in the industry
• Supports recruiting efforts by identifying potential candidates and participating in interviews
• Other duties as required

Qualifications, Knowledge, Skills, and Abilities:

Education:

• Bachelor's degree, required; focus in Information Technology, Data Analytics, Process Automation, Accounting, or Finance, preferred

Experience:

• Five (5) or more years of data analytics and process automation experience in federal financial audit and accounting professional standards and information technology, required
• Experience maintaining existing data analytic scripts designed in Audit Command Language (ACL), required
• Experience using data analytics, required
• Experience performing IT audits and/or assessments of internal controls over financial reporting, IT, grants, insurance, or IT Security in the Federal Government, preferred
• Experience in one (1) or more of the following areas: federal accounting standards and the US Standard General Ledger (USSGL), FISCAM, Federal Information Security Modernization Act (FISMA), NIST, and OMB Circular A-123, preferred

License(s)/Certification(s):

• Ability to obtain and maintain government agency suitability or security clearance, required
• Relevant industry certification, such as CPA, PMP, CGFM, CDFM, CIA, or CISA, preferred

Software:

• Proficiency in the use of Audit Command Language (ACL) or similar data analytics tools, required
• Proficiency in Microsoft Office Suites (Excel, PowerPoint, and Word), required
• Proficiency in the use of automation scripts in UiPath Studio, Microsoft Power Automate, Visual Basic, SQL, Python, Power BI, or similar software applications, required
• Advanced proficiency in the use of Microsoft Office Suites, specifically Excel, PowerPoint, and Word, preferred

Other Knowledge, Skills, & Abilities:

• Well-developed and professional interpersonal skills
• Ability to interact effectively with people at all organizational levels within the client organization and in the firm
• Excellent verbal and written communication skills
• Ability to work independently and collaborate within a team environment and with a customer service focus
• Ability to follow instructions as directed
• Superior organizational skills required with ability to multi-task in a fast-paced, deadline-driven environment
• Detail oriented with in-depth knowledge and application of English grammar and ability to proofread all written materials including proposals, pitches, presentations, etc.