Senior FP&A Systems Consultant

You must have native or near native-level English language skills to be considered

About the Role

Vivid Reports is hiring a Senior FP&A Systems Consultant to help design, optimize, and extend our Flex reporting platform. This role sits at the intersection of FP&A, ERP systems, SQL and reporting architecture, Excel engineering, and customer-facing solution consulting. You will work directly with financial data structures, ERP transaction models, integrations, and reporting performance challenges to help customers build scalable, trusted reporting environments. This is not a traditional software engineering role and not a traditional FP&A role. The right candidate combines deep financial systems understanding with strong development capability and the ability to solve complex reporting and data architecture problems end-to-end.

The right candidate works independently with minimal supervision, owns complex customer assignments from discovery through delivery, and thrives operating across both technical and business domains.

The Role

• Understand ERP transaction flows and financial semantics
• Design dimensional reporting structures across chart of accounts and management reporting hierarchies
• Validate reporting accuracy and reconciliation integrity
• Translate operational transactions into reliable financial reporting outputs
• Work with ERP systems and external data sources
• Design and troubleshoot integrations and APIs
• Map inbound financial and operational data feeds
• Support scalable warehouse-oriented reporting architectures
• Design approaches for data movement, transformation, and synchronization
• Write advanced SQL for reporting and analysis against financial data sources
• Diagnose reporting bottlenecks and warehouse inefficiencies
• Design scalable reporting structures and reusable query logic
• Apply data warehouse thinking to financial reporting problems
• Lead technical discoveries with customers around reporting requirements and data challenges
• Translate finance problems into scalable technical architecture
• Communicate tradeoffs and alternative solution paths clearly
• Independently drive customer assignments from requirements through delivery
• Coordinate with implementation partners and internal teams

Qualification for Success

• Native or near-native English language skills, all writing and client interaction will be in English
• 6–10 years of experience spanning FP&A, ERP implementation, financial systems consulting, or a combination of these
• Deep understanding of ERP transaction flows, GL structures, subledgers, dimensions, and financial reporting hierarchies
• Hands-on experience with mid-market ERP platforms such as Microsoft Dynamics GP, Business Central, Oracle EBS, or SAP HANA
• Advanced Excel capability; Power Query, Power Pivot, DAX, and experience building reports used by large groups of end users
• Practical SQL mastery; ability to reverse-engineer queries, trace data to source systems, tune for performance, and diagnose reporting errors
• Demonstrated experience building financial reports end-to-end, including scoping, layout, validation, and reconciliation
• Ability to operate independently without rigid specifications, consulting or implementation background strongly preferred
• Development capability sufficient to work in stored procedures, debug data pipelines, and navigate development environments (expert-level coding not required)
• Experience marketing to or working alongside finance leaders and accounting teams preferred
• Background in financial software, reporting tools, or BI platforms is an asset

Diversity, Equity, Inclusion & Equal Employment Opportunity at Banyan: Banyan affirms that inequality is detrimental to our Global Teams, associates, our Operating Companies, and the communities we serve. As a collective, our goal is to impact lasting change through our actions. Together, we unite for equality and equity. Banyan is committed to equal employment opportunities regardless of any protected characteristic, including race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, or protected veteran status and will not discriminate against anyone on the basis of a disability. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.

Recruitment Notice

Banyan Software may use artificial intelligence (AI) tools to assist in screening and/or assessing applicants during the recruitment process. All hiring decisions are made by our team. Personal information submitted through your application will be collected and used for recruitment purposes in accordance with applicable privacy laws. Contact us at any time with questions about our process or to request accommodation.

Beware of Recruitment Scams

We have been made aware of individuals fraudulently posing as members of our Talent Acquisition team and extending fake job offers. These scams may involve requests for personal information or payment for equipment.

Protect yourself by following these steps

• Verify that all communications from our recruiting team come from an @banyansoftware.com email address.
• Remember, employers will never request payment or banking information during the hiring process.
• If you receive a suspicious message, do not respond — instead, forward it to careers@banyansoftware.com and/or report it to the platform where you received it.

Your safety and security are important to us. Thank you for staying vigilant.