Note: The job is a remote job and is open to candidates in USA. Apexanalytix is a long-established company providing procure-to-pay solutions. The Data Analyst role involves acquiring and processing data for AP audits, managing the data process, and ensuring data quality while collaborating with clients and internal teams.
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
- 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
- 3+ years in AP Audit industry and working with financial data is preferred
- Experience in building automated ETL/ELT pipelines
Benefits
- 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
Company H1B Sponsorship