BDO USA
Senior Data Analytics Consultant – Public Sector, Federal Civilian
Job Description
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.
Individual salaries that are offered to a candidate are determined after consideration of numerous factors including but not limited to the candidate’s qualifications, experience, skills, and geography.
National Range: $105,000 – $125,000
Maryland Range: $105,000 – $125,000
NYC/Long Island/Westchester Range: $105,000 – $125,000
Join us at BDO, where you will find more than a career, you’ll find a place where your work is impactful, and you are valued for your individuality. We offer flexibility and opportunities for advancement. Our culture is centered around making meaningful connections, approaching interactions with curiosity, and being true to yourself, all while making a positive difference in the world.
At BDO, our purpose of helping people thrive every day is at the heart of everything we do. Together, we are focused on delivering exceptional and sustainable outcomes and value for our people, our clients, and our communities. BDO is proud to be an ESOP company, reflecting a culture that puts people first, by sharing financially in our growth in value with our U.S. team. BDO professionals provide assurance, tax and advisory services for a diverse range of clients across the U.S. and in over 160 countries through our global organization.
BDO is the first large accounting and advisory organization to implement an Employee Stock Ownership Plan (ESOP). A qualified retirement plan, the ESOP offers participants a stake in the firm’s success through beneficial ownership and a unique opportunity to enhance their financial well-being. The ESOP stands as a compelling addition to our comprehensive compensation and Total Rewards benefits* offerings. The annual allocation to the ESOP is fully funded by BDO through investments in company stock and grants employees the chance to grow their wealth over time as their shares vest and grow in value with the firm’s success, with no employee contributions.
We are committed to delivering exceptional experiences to middle market leaders by sharing insight-driven perspectives, helping companies take business as usual to better than usual. With industry knowledge and experience, a breadth and depth of resources, and unwavering commitment to quality, we pride ourselves on:
- Welcoming diverse perspectives and understanding the experience of our professionals and clients
- Empowering team members to explore their full potential
- Our talented team who brings varying skills, knowledge and experience to proactively help our clients navigate an expanding array of complex challenges and opportunities
- Celebrating ingenuity and innovation to transform our business and help our clients transform theirs
- Focus on resilience and sustainability to positively impact our people, clients, and communities
- BDO Total Rewards that encompass so much more than traditional “benefits.” Click here to find out more!
*Benefits may be subject to eligibility requirements.
Equal Opportunity Employer, including disability/vets