Senior FP&A Systems Consultant
Position Description
Senior FP&A Systems Consultant – Flex Platform
Argentina, Remote
About Vivid Reports (A Banyan Software Portfolio)
Vivid Reports is a Canadian B2B SaaS company that simplifies financial reporting and budgeting by automating reporting and analysis directly within Excel. We enable finance teams to handle complex data, reduce manual work, and make faster, more informed decisions.
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