What are the responsibilities and job description for the Data Analyst (U.S.) position at apexanalytix?
About Us
At apexanalytix, we’re lifelong innovators! Since the date of our founding nearly four decades ago we’ve been consistently growing, profitable, and delivering the best procure-to-pay solutions to the world. We’re the perfect balance of established company and start-up. You will find a unique home here.
And you’ll recognize the names of our clients. Most of them are on The Global 2000. They trust us to give them the latest in controls, audit and analytics software every day. Industry analysts consistently rank us as a top supplier management solution, and you’ll be helping build that reputation.
Read more about apexanalytix - https://www.apexanalytix.com/about/
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
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.
At apexanalytix, we’re lifelong innovators! Since the date of our founding nearly four decades ago we’ve been consistently growing, profitable, and delivering the best procure-to-pay solutions to the world. We’re the perfect balance of established company and start-up. You will find a unique home here.
And you’ll recognize the names of our clients. Most of them are on The Global 2000. They trust us to give them the latest in controls, audit and analytics software every day. Industry analysts consistently rank us as a top supplier management solution, and you’ll be helping build that reputation.
Read more about apexanalytix - https://www.apexanalytix.com/about/
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 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.
- 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.