Data Analyst (U.S.)

apexanalytix-careers; United States; Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Competitive benefits

Education and training assistance

Mentor program

Job summary

apexanalytix-careers is seeking a Data Analyst responsible for acquiring and processing data for AP audits. This role supports remote work, but requires onsite training during the first week in Greensboro.

The ideal candidate will have over 3 years of experience in data quality and analysis, particularly in the AP audit industry, alongside strong SQL skills and the ability to solve complex data issues.

Competitive benefits, including a strong mentor program and assistance for education and training, are offered to support personal and professional growth.

Qualifications

• 3+ years of experience in data quality, data analysis, and data management.
• 3+ years in AP Audit industry preferred.
• Experience managing large data sets and building automated ETL/ELT pipelines.

Responsibilities

• Collect all data elements needed for a successful audit.
• Map and join data tables to create standard audit tables.
• Address data quality issues and communicate solutions.

Skills

Data quality

Data analysis

Data management

SQL skills

Mathematical skills

Problem-solving

Tools

SQL client tools (SSMS, Dbeaver)

Excel

Data viewing software (Notepad, Ultra Edit)

Job description

Quick Take

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. This role can be done remotely from the U.S. (EST). First week onsite training will be required, so you must be comfortable traveling to our Greensboro location.

The Work

• Making sure that we collect all data elements needed for a successful audit.
• Mapping/joining data tables together to create our standard audit tables.
• Conduct 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.
• Responsible for defining business rules and data standards and best practices for data analysis and enrichment.
• Responsible for understanding end-to-end data flows and identifying data dependencies in support of delivery, release, and change management.
• Partners with the IT security team to ensure solutions adhere to the organization’s data principles and guidelines.
• Responsible for solving data related issues and communicating resolutions with R&D and other associates.

The Must-Haves

• 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.
• Ability 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.

Benefits

At apexanalytix we know that our associates are the reason behind our successes. We truly value you as an associate and part of our professional family. Our goal is to offer the very best benefits possible to you and your loved ones. When it comes to benefits, whether for yourself or your family the most important aspect is choice. And we get that. apexanalytix offers competitive benefits for the countries that we serve, in addition to our BeWell@apex initiative that encourages employees’ growth in six key wellness areas: Emotional, Physical, Community, Financial, Social, and Intelligence.

With resources such as a strong Mentor Program, Internal Training Portal, plus Education, Tuition, and Certification Assistance, we provide tools for our associates to grow and develop.