Assurance Data Analytics & Emerging Methods - Extractions Senior Associate

Job Summary:

BDO is a place for energetic self-starters who can think of creative and imaginative solutions for the challenges and opportunities facing an Assurance practice built for the 21st century.  We focus exclusively on the design and delivery of tools that help us collaborate with each other and with our clients; that direct our attention on things that matter most; and that integrate with increasingly automated workflows.  Our innovation portfolio is designed people-first to support our professionals in performing effective, efficient and technology enabled work that is evaluative, insightful, and impactful. 

As a member of the BDO Advantage Audit Data Analytics & Emerging Methods team, the Data Extraction professional works with our most important resources – our people and our clients - to facilitate data extraction using defined tools, services, methodologies, and workflows for consumption by the BDO analytics platforms.   The Data Extraction professional also participates in the design and development of our solutions.

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

The successful candidate is able to communicate effectively with a broad audience and possesses excellent organizational skills and the ability to prioritize multiple tasks, projects and assignments, as well strong business ethics and willingness to adhere to and design stringent process standards.

Job Duties:

Typical responsibilities will include:

• Works with our most valuable resources – our people and our clients - to implement and support data extraction tools and workflows and application of recommended solutions for a variety of general ledger and subledger 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 the BDO analytics platforms
• Identifies, triages, and resolves support requests
• Establishes and maintains customer satisfaction methods and information

Qualifications, Knowledge, Skills and Abilities:

Education:

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

Experience:

• Three (3) or more years of experience with data extraction and transformations, SQL queries, database systems, required
• One (1) or more years of experience with the following Azure data analytics resources, preferred
• Azure Data Factory or Databricks 
• Azure SQL Database 
• Azure Storage Accounts / Data Lakes
• Power BI or Azure Analysis Services or Azure Synapse Analytics
• Two (2) or more years of accounting, audit, finance, or equivalent experience, preferred

License/Certifications:

• Certified Information Systems Analyst certification, preferred

Software:

• Previous experience integrating data from ERP systems such as SAP, Oracle, Sage Intacct, NetSuite, or QBO using analytics tools like Power BI and Tableau, preferred
• Working knowledge of various ERP systems and accounting packages, preferred
• MS Excel and Power BI data cleansing techniques, preferred
• Ability to write SQL queries and manage large data sets within SQL Server, preferred

Language:

• N/A

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
• Passionate about data and solving client problems
• Excellent interpersonal and customer relationship skills, required
• Presentation and meeting facilitation skills
• Ability to work in a deadline-driven environment 
• Ability to work well under pressure while dealing with unexpected problems in a professional manner
• High level of curiosity and eagerness to learn
• Ability to write and produce technical documents with experience in demonstrating technical solutions to end-users
• Ability to perform data quality checks and identify and analyze data anomalies
• Ability to interact effectively with people at all organizational levels of the Firm
• Good knowledge of testing and quality assurance for new development of data extraction procedures
   

Join us at BDO, where you will find more than a career, you’ll find a place where your work is impactful, and you are valued for your individuality. We offer flexibility and opportunities for advancement. Our culture is centered around making meaningful connections, approaching interactions with curiosity, and being true to yourself, all while making a positive difference in the world. 

At BDO, our purpose of helping people thrive every day is at the heart of everything we do. Together, we are focused on delivering exceptional and sustainable outcomes and value for our people, our clients, and our communities. BDO is proud to be an ESOP company, reflecting a culture that puts people first, by sharing financially in our growth in value with our U.S. team.  BDO professionals provide assurance, tax and advisory services for a diverse range of clients across the U.S. and in over 160 countries through our global organization.

BDO is the first large accounting and advisory organization to implement an Employee Stock Ownership Plan (ESOP). A qualified retirement plan, the ESOP offers participants a stake in the firm’s success through beneficial ownership and a unique opportunity to enhance their financial well-being. The ESOP stands as a compelling addition to our comprehensive compensation and Total Rewards benefits* offerings. The annual allocation to the ESOP is fully funded by BDO through investments in company stock and grants employees the chance to grow their wealth over time as their shares vest and grow in value with the firm’s success, with no employee contributions. 

We are committed to delivering exceptional experiences to middle market leaders by sharing insight-driven perspectives, helping companies take business as usual to better than usual. With industry knowledge and experience, a breadth and depth of resources, and unwavering commitment to quality, we pride ourselves on:

• Welcoming diverse perspectives and understanding the experience of our professionals and clients
• Empowering team members to explore their full potential
• Our talented team who brings varying skills, knowledge and experience to proactively help our clients navigate an expanding array of complex challenges and opportunities
• Celebrating ingenuity and innovation to transform our business and help our clients transform theirs
• Focus on resilience and sustainability to positively impact our people, clients, and communities
• BDO Total Rewards that encompass so much more than traditional “benefits.”  Click here to find out more!

*Benefits may be subject to eligibility requirements.

Equal Opportunity Employer, including disability/vets