Data Analyst (U.S.)

About the role

The Data Analyst is responsible for acquiring and processing the data needed for our AP audits. This includes attending and/or leading meetings to discuss the data requirements and following up with the client until we have what is required. Managing the data process from the first meeting until the data is processed and ready for audit and answering any questions the audit team may have as the audit progresses.

Responsibilities

• Making sure that we collect all data elements needed for a successful audit.
• Mapping/joining data tables together to create our standard audit tables.
• Conducting the discovery, removal, and correction of errors in data records through data cleansing activities.
• Using tools to identify, analyze, and interpret patterns and trends in complex datasets that could be helpful for the diagnosis.
• Accountable for the assessment, delivery, quality, accuracy, and tracking of any production data fixes.
• Defining business rules and data standards and best practices for data analysis and enrichment.
• Understanding end-to-end data flows and identifying data dependencies in support of delivery, release, and change management.
• Partnering with the IT security team to ensure solutions adhere to the organization’s data principles and guidelines.
• Solving data related issues and communicating resolutions with R&D and other associates.

Requirements

• 3+ years of data quality, data analysis, and data management experience.
• 3+ years in AP Audit industry and working with financial data is preferred.
• Experience in managing large data sets and mapping them accordingly.
• Experience in SQL client tool like SSMS, Dbeaver, etc.
• Strong SQL skills.
• High level understanding of SAP AP tables and how they work together.
• Experience in building automated ETL/ELT pipelines.
• Understanding SQL databases and table relationships.
• Experience working in Excel and data viewing software such as Notepad and Ultra Edit.
• Strong mathematical skills to help collect, measure, organize and analyze data.
• Able to communicate at all levels with clarity, poise, maturity, and precision both written and verbal.
• Excellent problem-solving and critical-thinking skills.
• Technical expertise in data, its standardization and transformation.
• Must understand data flows, data profiling, and statistical analysis.

Qualifications

• Must have a bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field.
• Must be able to travel to our Greensboro location for first week of on-site training.

Skills

• SQL
• Data Analysis
• Data Management
• Financial Data
• SAP AP Tables
• ETL/ELT Pipelines
• Excel
• Notepad
• Ultra Edit
• Statistical Analysis

Benefits

At apexanalytix, we offer competitive benefits for the countries we serve, including:

• BeWell@apex initiative encouraging growth in six key wellness areas: Emotional, Physical, Community, Financial, Social, and Intelligence.
• Resources such as a strong Mentor Program, Internal Training Portal, plus Education, Tuition, and Certification Assistance.