This site uses cookies. To find out more, see our Cookies Policy

Principle Data Analyst, Internal Audit in Rockville, MD at Lucas Group

Date Posted: 4/21/2018

Job Snapshot

Job Description

Take the lead in working with IA Management on enhancing IA’s Data Analytics Program capabilities.  Design and develop more advanced risk analytics, predictive models, etc., utilizing data collected by IA from a wide range of systems. Working with minimal supervision, leverage data analytics to effectively evaluate THE CLIENT functions in coordination with Internal Audit management and staff.

Maintain and enhance Internal Audit management and workpaper systems (e.g., Audit Management Information System [AMIS], audit workpaper databases [AutoWPS], and Federal Laws and Regulations database).  Perform joint system analysis with auditors and Business Unit/Technology personnel to develop specifications for audit software to accomplish audit objectives; develop, document and test audit software based on agreed upon specifications; integrate developed software into the overall Computer Assisted Audit Tools & Techniques (CAATTS) structure; train and assist auditors in the execution of audit software.



Experience Requirements:

  • Bachelor’s degree in Computer Science, MIS, or related field (or equivalent work experience).
  • Application development and programming experience required, including database and SQL experience required.
  • Minimum of 7 to 10 years analysis and/or programming experience and/or application development or technical support experience related to various hardware platforms (e.g., Tandem, Unisys, Sun, Sequent, or Windows XP) and database applications (e.g., Oracle, Sequel, Dot-Net, Microsoft Office Suite and related tools).
  • Significant experience with a variety of data analytics tools (e.g., SAS, Access, Tableau, QlikView, and ACL).
  • Able to understand and interpret database objects and relationships.
  • Strong knowledge of advanced statistical methods and analytics tools.
  • Advanced knowledge of SQL or comparable language and ability to analyze large volumes of data quickly and efficiently.
  • Relevant experience with a proven track record of leveraging analytics and large amounts of data to drive significant business impact.
  • Must be comfortable working and communicating both orally and in writing with a variety of people with varying skill and knowledge levels.  Must be a self-starter and be able to handle multiple tasks independently and under tight deadlines.
  • Effective leadership and team skills.
  • Project management experience desirable.
  • Strong judgment, problem solving, analytical, and quantitative skills.
  • Excellent communication skills.
  • Ability to maintain focus and develop proficiency in new skills rapidly.
  • Professional certification (such as CISA, CPA, CIA, or CISSP) is highly desirable.

Working Conditions:

  • Regular office conditions; some travel may be required.


Responsibilities:

Position may be filled at various levels depending on experience and job skills of a successful candidate.

Essential Job Functions:

  • Work with Audit Management and Audit Technology Director on implementation of IA Data Analytics Initiatives, including:
    • Work with business unit leaders and audit teams to understand business data requirements and translate them into analytics usable to IA.
    • Develop software tools to collect, and analyze large volumes of structured and/or unstructured data.
    • Design and develop more advanced risk analytics, predictive models, etc., utilizing data collected by IA from a wide range of THE CLIENT systems.
  • Maintain and enhance IA’s Continuous Audit Process (CAP) programs that facilitate identification of exception situations based on pre-established parameters, allow for communication of potential exceptions to business and technology unit management, and confirm exception resolution by IA staff.  Examples include testing of Travel & Entertainment, Market Regulation patterns, Technology back-up and recovery procedures, Member Regulation examination status.
  • Work with the Audit Technology Director, to perform IA system support, including:
    • Maintain and enhance IA’s audit management system (AMIS) to help ensure acceptable availability standards.
    • Maintain and enhance IA’s automated workpapers (AutoWPS) functionality.
    • Perform maintenance, trouble shooting, and system fixes responsibilities.
    • Perform major system enhancements and modifications or other Internal Audit applications.
    • Provide leadership and initiative in IA systems innovation, including concept development, program design, coding, and implementation of enhancements to all IA systems.  Facilitate movement of process improvement concepts to implemented functionality.  Maintain systems, including security, reporting, and availability.
  • Develop computer assisted audit tools and techniques (CAATTs) that query multiple complex systems throughout  (e.g., PeopleSoft, CRD, STAR) in support of IA staff in conducting internal audits.  This will include use of advanced software tools to perform complex CAATTs to re-create, as appropriate, desired production system results.  Establish and maintain efficient means of obtaining access to audited systems via liaison relationships with application owners.  Ensure performance of duties without impact on production systems.
  • Support all technology-related aspects of internal audits, including assisting with various compliance-oriented audit work (e.g., Sarbanes-Oxley, RegSCI, Section 31 Fees).
  • Develop and provide CAATTs training to BA and IT auditors that will allow them to execute basic CAATTs programs on their own.  This involves providing on-the-job training, assisting auditors in the preparation and execution of their own audit software, and providing training sessions aimed at developing specific skills.  Assess individual IA staff member progress in developing ability to conceive, develop, and execute CAATTs.  [10%]
  • Stay abreast of new or emerging information technologies, products, and best practices.  Assist audit management in evaluating new products designed to enhance performance and efficiency within the audit process.


Experience Requirements:

  • Bachelor’s degree in Computer Science, MIS, or related field (or equivalent work experience).
  • Application development and programming experience required, including database and SQL experience required.
  • Minimum of 7 to 10 years analysis and/or programming experience and/or application development or technical support experience related to various hardware platforms (e.g., Tandem, Unisys, Sun, Sequent, or Windows XP) and database applications (e.g., Oracle, Sequel, Dot-Net, Microsoft Office Suite and related tools).
  • Significant experience with a variety of data analytics tools (e.g., SAS, Access, Tableau, QlikView, and ACL).
  • Able to understand and interpret database objects and relationships.
  • Strong knowledge of advanced statistical methods and analytics tools.
  • Advanced knowledge of SQL or comparable language and ability to analyze large volumes of data quickly and efficiently.
  • Relevant experience with a proven track record of leveraging analytics and large amounts of data to drive significant business impact.
  • Must be comfortable working and communicating both orally and in writing with a variety of people with varying skill and knowledge levels.  Must be a self-starter and be able to handle multiple tasks independently and under tight deadlines.
  • Effective leadership and team skills.
  • Project management experience desirable.
  • Strong judgment, problem solving, analytical, and quantitative skills.
  • Excellent communication skills.
  • Ability to maintain focus and develop proficiency in new skills rapidly.
  • Professional certification (such as CISA, CPA, CIA, or CISSP) is highly desirable.

Working Conditions:

  • Regular office conditions; some travel may be required.


Responsibilities:

Position may be filled at various levels depending on experience and job skills of a successful candidate.

Essential Job Functions:

  • Work with Audit Management and Audit Technology Director on implementation of IA Data Analytics Initiatives, including:
    • Work with business unit leaders and audit teams to understand business data requirements and translate them into analytics usable to IA.
    • Develop software tools to collect, and analyze large volumes of structured and/or unstructured data.
    • Design and develop more advanced risk analytics, predictive models, etc., utilizing data collected by IA from a wide range of THE CLIENT systems.
  • Maintain and enhance IA’s Continuous Audit Process (CAP) programs that facilitate identification of exception situations based on pre-established parameters, allow for communication of potential exceptions to business and technology unit management, and confirm exception resolution by IA staff.  Examples include testing of Travel & Entertainment, Market Regulation patterns, Technology back-up and recovery procedures, Member Regulation examination status.
  • Work with the Audit Technology Director, to perform IA system support, including:
    • Maintain and enhance IA’s audit management system (AMIS) to help ensure acceptable availability standards.
    • Maintain and enhance IA’s automated workpapers (AutoWPS) functionality.
    • Perform maintenance, trouble shooting, and system fixes responsibilities.
    • Perform major system enhancements and modifications or other Internal Audit applications.
    • Provide leadership and initiative in IA systems innovation, including concept development, program design, coding, and implementation of enhancements to all IA systems.  Facilitate movement of process improvement concepts to implemented functionality.  Maintain systems, including security, reporting, and availability.
  • Develop computer assisted audit tools and techniques (CAATTs) that query multiple complex systems throughout  (e.g., PeopleSoft, CRD, STAR) in support of IA staff in conducting internal audits.  This will include use of advanced software tools to perform complex CAATTs to re-create, as appropriate, desired production system results.  Establish and maintain efficient means of obtaining access to audited systems via liaison relationships with application owners.  Ensure performance of duties without impact on production systems.
  • Support all technology-related aspects of internal audits, including assisting with various compliance-oriented audit work (e.g., Sarbanes-Oxley, RegSCI, Section 31 Fees).
  • Develop and provide CAATTs training to BA and IT auditors that will allow them to execute basic CAATTs programs on their own.  This involves providing on-the-job training, assisting auditors in the preparation and execution of their own audit software, and providing training sessions aimed at developing specific skills.  Assess individual IA staff member progress in developing ability to conceive, develop, and execute CAATTs.  [10%]
  • Stay abreast of new or emerging information technologies, products, and best practices.  Assist audit management in evaluating new products designed to enhance performance and efficiency within the audit process.


Date Posted: April 5, 2018

Valid until May 4, 2018

1519862400 | 1522932816| 201804 | 201804#CB