Extraction Solutions Experienced Associate, BDOADVANTAGE

Job Summary:

As a member of the BDOADVANTAGE team, the Extraction Solutions Experienced Associate is responsible for supporting moderately complex data extraction and transformation efforts across multiple 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.

We believe in a collaborative, flexible, inclusive, curious, and growth-oriented culture with accountability to each other and to our goal of modernizing the way our professionals work.

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.

Job Duties:

• Independently performs data extraction activities across various ERP systems (e.g., NetSuite, SAP, Oracle, Sage)
• Builds, executes, and supports ETL workflows using tools such as Excel, Alteryx, SQL, or Power BI
• Performs data preparation tasks, including cleansing, formatting, and validating datasets
• Applies defined extraction procedures and follows established workflows and methodologies, adapting to address non-standard or ambiguous data challenges
• Identifies data inconsistencies, troubleshoots routine issues, and escalates complex issues to senior team members
• Documents extraction processes and maintains workflow documentation to support consistency and repeatability
• Contributes to process improvements that enhance data quality, efficiency, and scalability of extraction solutions
• Documents extraction processes and maintains workflow documentation
• Other duties as required

Qualifications, Knowledge, Skills, and Abilities:

Education:

• Bachelor’s degree, required; focus in Accounting, Accounting Information Systems, Data Analytics, Computer Science, preferred

Experience:

• One (1) year of experience in data extraction, ETL development, required
• Exposure to financial data environments or ERP systems, required
• Experience working with ETL tools such as Alteryx, Power BI, or SQL, required

License/Certification:

• N/A

Software:

• Familiarity with data transformation and data preparation techniques, required
• Experience with one (1) or more of the following ETL resources, preferred
  • Power BI, Fabric, or Alteryx
  • Azure Data Factory or Databricks
  • SQL Database
  • MS Excel and Power Query
• Working knowledge of various ERP systems and accounting packages, preferred

Language:

• N/A

Other Knowledge, Skills & Abilities:

• Ability to adapt and work effectively in a fast-paced environment
• Ability to communicate effectively with both technical and non-technical audiences
• Strong analytical and problem-solving skills, with growing independence
• Ability to manage multiple tasks and priorities to meet deadlines
• High level of curiosity and eagerness to learn new tools and technologies
• Ability to document processes clearly for team and engagement use
• Collaborative mindset with developing mentorship capabilities
• Strong attention to detail and commitment to data accuracy
• Ability to identify data anomalies and escalate issues appropriately
• Demonstrated ability to troubleshoot and resolve moderately complex data challenges
• Exposure to accounting, audit, or finance concepts

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.

National Range: $80,000 - $90,000
Maryland Range: $80,000 - $90,000
NYC/Long Island/Westchester Range: $80,000 - $90,000

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.

Learn more about our benefits: BDO Total Rewards encompass more than traditional benefits. Click here to find out more!

*Benefits may be subject to eligibility requirements.

Equal Opportunity Employer, including disability/vets
Click here to find out more!