ERP Data - Pittsburgh, United States - RSM US LLP

Description

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You'll find an environment that inspires and empowers you to thrive both personally and professionally. There's no one like you and that's why there's nowhere like RSM.

The ERP Risk & Automation Services (ERAS) assists with various consulting, internal, and external audit clients by bringing in-depth ERP, data analytics (DA), and automation skills where needed. As part of the RSM's Risk Consulting practice, the specialty service provides complex data analysis and automation services for both external and internal clients, assists in data governance assessments, implements continuous auditing and monitoring programs, performs controls designs/assessments, segregation of duties assessments, key report testing and validation, and data conversion validation.

The ERAS - Data Analytics Manager is responsible for managing a team that scopes, designs, develops and deploys systems and processes for independently validating the integrity of data and supporting governance processes, including: a) assessing the completeness/accuracy of key reports, b) validating the integrity of data conversion activities as part of an ERP system implementation, and c) evaluating the maturity and viability of an organizations overall data governance strategy and processes.

Responsibilities:

• Manage and provide quality assurance for team members supporting projects as described above
• Clarify and communicate analytic design and automation requirements to team members who will be developing solutions, and step in as needed to code and develop these solutions (this is a hands-on manager role, and you may need to step in cases where other resources are not available)
• Manage communication with IT and/or business resources to locate internal and external data for analysis, understand data, and make data requests or direct connections to databases
• Champion sustainable analytic design concepts
• Perform QA over developer practices for data mapping, data transformations, data joining/blending, data quality, data cleansing, and other data movement related activities
• Troubleshoot dashboards, analytics, and scripts, as necessary
• Provide guidance to both internal and external stakeholders on interpreting analytic results
• Provide analytic and automation subject matter expertise during business development pursuits
• Scope DA-related projects and determine whether local or national resources provide the best solution, and liaise with national practice resources, as needed
• Present analytics and automation thought leadership at professional association meetings and conferences
• Coordinate data analytic services with off-shore resources in RSM USI
• Coach/mentor and manage staff on data analytic techniques and client deliverables

Position Requirements:

• Experience managing a team that develops analytic and automation routines for audit and compliance professionals, with a particular emphasis on data quality and governance
• Ability to identify the solution the client needs (vs. what they have asked for), and create the business case for the best solution within stated resource constraints
• Experience communicating the value proposition of analytics and automation (for audit and compliance professionals)
• Experience with SOX, COSO, COBIT and other related controls methodology and frameworks
• Understanding basic accounting, operations and auditing concepts and reporting skills
• Strong analytical mindset and communication skills
• Proactive, inquisitive and creative in approach to work
• Ability to travel 10-20%

Minimum Qualifications:

• Undergraduate degree in MIS, Computer Science, Statistics, Data Analytics or Accounting, or equivalent level of education
• Minimum of 6 years of experience, ideally within the compliance or audit space
• Minimum of 2 years experience leading or managing a team of developers
• Experience using other industry standard data analysis technologies such as SAS, Alteryx, SQL, and/or Python
• Experience developing and/or managing dashboard solutions created using PowerBI, Tableau, Qlik, or similar technologies

Preferred Qualifications:

• Experience with data analytics of large ERP applications such as SAP, Oracle, PeopleSoft, or JD Edwards
• Experience working with data from cloud-based applications like Workday, NetSuite, Salesforce, Concur is a plus
• Business development experience is a plus
• CISA, CIA, CFE, and/or CPA
• Certifications in one or more data analysis technologies such as Alteryx, SAS, and/or Tableau

Standards of Performance:

• Data stewardship - Maintain confidentiality, integrity and availability of information with your custody
• A self-starter with a process improvement mentality who is hands on, results-oriented, and leads by example
• A strong entrepreneurial spirit with the highest levels of professional and personal honestly, integrity and ethics
• Excellent organizational skills and the ability to prioritize multiple tasks, projects and assignments
• Ability to interact with all levels of client staff, including executives and senior managers
• Possess strong business ethics and willingness to adhere to stringent professional standards
• Ability to put forth additional effort to meet deadlines when necessary

At RSM, we offer a competitive benefits and compensation package for all our people. We support and inspire you to prioritize your wellbeing by delivering personalized, holistic programming for your physical, emotional, financial and community wellbeing. RSM has a generous time off policy with at least 14 paid holidays, wellbeing days and associate and above access to self-managed time off. We offer flexibility in your schedule, empowering you to balance life's demands, while also maintaining your ability to serve clients. Learn more about our total rewards at

RSM is proud to be an Affirmative Action and Equal Employment Opportunity employer. We are proud to provide our employees with tools to assist them in being successful in achieving both personal and professional goals. We welcome and support all our employees to thrive in an environment free of discrimination and harassment. As an Affirmative Action and Equal Opportunity Employer all applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the US uniformed service; pre-disposing genetic characteristics or any other characteristic protected under applicable federal, state or local law.

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please call us at or send us an email at

RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying, excluding internships, you may be eligible for hire as an experienced associate.

Individuals selected for this role will be eligible for a discretionary bonus based on firm and individual performance.