Note: The job is a remote job and is open to candidates in USA. apexanalytix is a longstanding company specializing in procure-to-pay solutions. They are seeking a Data Analyst responsible for acquiring and processing data for AP audits, managing the data process, and ensuring data quality and standards are met.
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
- Conduct the discovery, removal, and correction of errors in data records though 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
Skills
- 3+ years of data quality, data analysis, and data management experience
- 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
- 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
- 3+ years in AP Audit industry and working with financial data is preferred
- 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
Benefits
- Competitive benefits for the countries that we serve
- BeWell@apex initiative that encourages employees’ growth in six key wellness areas: Emotional, Physical, Community, Financial, Social, and Intelligence
- Strong Mentor Program
- Internal Training Portal
- Education, Tuition, and Certification Assistance
Company Overview
Our Why To positively impact the lives and careers of our associates, customers and partners. It was founded in 1988, and is headquartered in Greensboro, North Carolina, USA, with a workforce of 201-500 employees. Its website is https://www.apexanalytix.com.