Job Description:
The Business Analyst supports Finance ERP integration and M&A initiatives through advanced data analysis, process documentation, and cross‑functional collaboration. This role partners closely with Finance, IT, Operations, and acquisition partner teams to analyze financial data, identify process gaps, and support scalable enterprise reporting and integration.
Key Responsibilities
Analyze and manipulate large financial data sets using SQL, Power BI, Alteryx, and other tools to support ERP integrations and reporting
Facilitate requirements‑gathering sessions and workshops with Finance, Operations, and acquisition partner teams
Develop understanding of current‑state processes and perform process gap analysis to support detailed data integration
Map and harmonize data between partner legacy systems to new platforms
Develop and optimize SQL queries for data extraction, transformation, and analysis
Gather and translate finance and business requirements into clear process documentation and analytical outputs
Perform data validation, reconciliation, and analysis to ensure accuracy during system integrations
Contribute to the development of a scalable finance integration playbook for future M&A activity
Support change management efforts related to new systems, processes, and reporting standards
Collaborate with external consultants, IT, and finance to ensure timely and accurate integration deliverables
Required Skills & Experience:
Bachelor’s degree in Accounting, Finance, Business, or related field
3+ years of experience in accounting, finance, data analytics, or business analysis roles
Strong SQL skills for querying, validating, and reconciling financial data
Experience with Power BI, Alteryx (or similar visualization & analytics tools)
Solid understanding of finance and accounting processes
ERP system integration or finance transformation, Deltek Vantagepoint experience a plus
Ability to communicate effectively with Finance, Accounting, and business stakeholders
Experience working in fast‑paced, M&A‑driven environments preferred
Background in finance transformation or advisory / transaction services
Experience supporting enterprise‑scale data models and reporting standards
Ability to travel up to 25%, as well as work some evenings and weekends to support integration cutovers and partner firm needs
EEO Statement:
All qualified applicants for Pape-Dawson Engineers will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Skills Required
- Bachelor's degree in Accounting, Finance, Business, or related field
- 3+ years of experience in accounting, finance, data analytics, or business analysis roles
- Strong SQL skills for querying, validating, and reconciling financial data
- Experience with Power BI, Alteryx (or similar visualization & analytics tools)
- Solid understanding of finance and accounting processes
- ERP system integration or finance transformation
What We Do
Who We Are Founded in 1965, Pape-Dawson provides professional civil engineering, surveying, GIS, and environmental services for public and private clients across Texas. With 850+ staff and offices in San Antonio, Austin, Houston, Tomball, Fort Worth, Dallas, New Braunfels, and Corpus Christi, we provide both our clients and our employees with a deep bench of valuable in-house resources that span a wide range of disciplines. Pape-Dawson has provided civil engineering services for many noteworthy projects in Texas including theme parks; educational campuses; healthcare facilities; transportation improvement projects; water and wastewater infrastructure projects; commercial land development projects; and thousands of residential projects. We take great pride in producing projects than not only impact quality of life, but also help generate economic opportunity within our communities. Culture and Benefits We acknowledge the value of our employees by providing an enlightened company culture that encourages personal growth and professional excellence, supported by state-of-the-art technology and frequent training opportunities. Employee engagement is an integral part of working at Pape-Dawson. Monthly birthday celebrations, weekly trivia and bingo breaks, picnics, holiday parties, professional speakers, and networking opportunities are just a few of the many events employees enjoy. In addition to fostering a culture that promotes satisfaction and success, we provide our employees with a robust benefits package including a variety of insurance plan options; a generous PTO policy; impressive 401(k) match program; education and gym reimbursements; and flexible and remote work opportunities.
