Data Analyst (U.S.)

Apex Analytix, LLC
Greensboro, NC, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Data Analysis Big Data Cyber Security Data Cleansing Extract Transform Load (ETL) Data Profiling Database Queries Notepad (Software) Operational Databases SAP (Applications) SQL Databases
+5 more
Data Streaming Data Management SQL Server Management Studio (SSMS) Data Pipelines Database Tools and Utilities

Job description

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.

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

About the company

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, Over the years, we’ve discovered that the most effective and successful associates at apexanalytix are people who have a specific combination of values, skills, and behaviors that we call “The apex Way”. Read more about The apex Way - https://www.apexanalytix.com/careers/

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy ¡ LIVE

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella ¡ WWC 2023

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu ¡ WWC 2024

14:14 min

Addressing audience inquiries on analytical implementation and career growth

Julian Joseph ¡ LIVE

2:10 min

Why organizations combine big data and machine learning

Ayon Roy ¡ LIVE

3:52 min

Navigating data warehouse performance for application developers

Adnan Rahic ¡ JS Congress

Videos

See all

Related articles

See all