Extraction Solutions Senior Associate, BDOADVANTAGE

BDO USA, LLP
New York, NY, United States
6 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
1 year minimum
Compensation
$90,000.0 - $120,000.0
Working hours
Regular working hours

Tech stack

Microsoft Excel Accounting Information Systems Data Analysis Microsoft Azure Big Data Data Validation Data Cleansing Information Engineering Data Integration Extract Transform Load (ETL) Data Mining Microsoft SQL Server
+15 more
SQL Azure Netsuite Oracle (Applications) Power BI Sage Accounting SAP (Applications) SQL Databases Tableau (Software) Azure Data Factory Data Lakes Information Technology Data Analytics Tools for Reporting Alteryx Databricks

Job description

As a member of the BDOADVANTAGE team, the Extraction Solutions Senior Associate is responsible for leading complex data extraction and transformation efforts across multiple client ERP systems. This role supports the design, development, and implementation of standardized ETL workflows, tools, and methodologies used by audit professionals. The position requires a strong technical foundation, the ability to solve complex data challenges, and a focus on improving data quality, consistency, and scalability., * Works with engagement teams and clients to implement and support data extraction tools, workflows, and solutions across a variety of ERP systems

  • Manage the process of identifying and extracting client data based on analytic requirements using data analysis, research, and technical extraction skills.
  • Independently engage with client personnel and engagement teams to understand ERP-specific business rules and make extraction design decisions to apply those rules in the extraction.
  • Data preparation and routing into BDO analytics platforms
  • Identifies, triages, and resolves support requests
  • Establishes and maintains customer satisfaction methods and information

Requirements

The successful candidate will communicate effectively with a broad audience, demonstrate strong organizational and problem-solving skills, and contribute to continuous improvement of extraction processes and solutions., * Bachelor’s degree, required; focus in Accounting, Accounting Information Systems, Data Analytics, Computer Science, preferred, * Three (3) or more years of experience with data extraction, data engineering, ETL development, or analytic development, required

  • Audit, assurance, or accounting client service experience, preferred
  • Experience working with large-scale financial or transactional datasets, preferred
  • Experience partnering with cross-functional stakeholders (e.g., audit teams, clients, technical teams) to define data requirements and deliver solutions, preferred

Software:

  • One (1) or more years of experience with any of the following ETL resources, required
  • Power BI, Fabric, or Alteryx
  • Azure Data Factory or Databricks
  • Azure SQL Database
  • Azure Storage Accounts / Data Lakes
  • Experience integrating data from ERP systems such as SAP, Oracle, Sage Intacct, NetSuite, or QBO using analytics tools like Power BI, Alteryx, and Tableau, preferred
  • Working knowledge of various ERP systems and accounting packages, preferred
  • Alteryx, MS Excel and Power BI data cleansing techniques, preferred
  • Ability to write SQL queries and manage large data sets within SQL Server, preferred

Other Knowledge, Skills & Abilities:

  • Ability to adapt, self-motivate, and learn new tools
  • Ability to communicate effectively with a broad audience ranging from technical to non-technical
  • Strong analytical and problem-solving skills
  • Excellent interpersonal and customer relationship skills, required
  • Ability to manage multiple priorities and meet deadlines
  • High level of curiosity and eagerness to learn
  • Ability to document processes and demonstrate technical solutions to end users
  • Ability to perform data quality checks and identify anomalies in datasets
  • Ability to interact effectively with people at all organizational levels
  • Strong attention to detail and commitment to accuracy
  • Good understanding of testing and quality assurance for data extraction processes

Individual salaries that are offered to a candidate are determined after consideration of numerous factors including but not limited to the candidate’s qualifications, experience, skills, and geography.

About the company

At BDO, how we show up matters. We build strong relationships by supporting one another, our clients, and our communities with care, curiosity, and a commitment to helping one another grow and succeed. Here, you’ll find meaningful work, leaders invested in your success, and opportunities to build a career around what matters most to you.

Our purpose is to be the people our clients count on to grow with confidence and achieve what matters most. Our values guide how we bring that purpose to life each day. Together, they shape how we work with one another, serve our clients, and create meaningful impact.

BDO provides assurance, tax, and advisory services to clients across the U.S. and around the world. No matter your role, you’ll be part of a team helping clients navigate complexity and move forward with clarity.

We are proud to be an ESOP company, offering participants a stake in the firm’s success through beneficial ownership and a unique opportunity to enhance their financial well-being. As a qualified retirement plan, the ESOP is a meaningful addition to our comprehensive compensation and Total Rewards benefits* offerings. It also reinforces an ownership mindset that strengthens our connection to one another, our clients, and the future we’re building together.

Apply for this position

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

Apply on ebqb.fa.us2.oraclecloud.com

Good distractions

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

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:22 min

Creating dedicated AI assistants for advanced candidate sourcing

José Kadlec José Kadlec · WWC 2025

2:10 min

Why organizations combine big data and machine learning

Ayon Roy · LIVE

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

Videos

See all

Related articles

See all