Banyan Software is the best permanent home for software businesses that serve specialized industries, their employees, and their customers. We are on a mission to acquire, build, and grow great companies worldwide, helping them modernize through shared AI expertise and operational discipline. The Banyan Software Foundation, endowed with $100 million in Banyan stock, leverages technology to build a greener and more equitable world. Banyan is Great Place to Work Certified, a five-time Inc. 5000 honoree, and a top 10 company on the Deloitte Technology Fast 500. Founded in 2016 and headquartered in Atlanta, Banyan operates more than 100 portfolio companies across North America, the UK, EU, and APAC.Senior FP&A Systems Consultant – Flex PlatformAbout 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 RoleVivid 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 RoleUnderstand ERP transaction flows and financial semanticsDesign dimensional reporting structures across chart of accounts and management reporting hierarchiesValidate reporting accuracy and reconciliation integrityTranslate operational transactions into reliable financial reporting outputsWork with ERP systems and external data sourcesDesign and troubleshoot integrations and APIsMap inbound financial and operational data feedsSupport scalable warehouse-oriented reporting architecturesDesign approaches for data movement, transformation, and synchronizationWrite advanced SQL for reporting and analysis against financial data sourcesDiagnose reporting bottlenecks and warehouse inefficienciesDesign scalable reporting structures and reusable query logicApply data warehouse thinking to financial reporting problemsLead technical discoveries with customers around reporting requirements and data challengesTranslate finance problems into scalable technical architectureCommunicate tradeoffs and alternative solution paths clearlyIndependently drive customer assignments from requirements through deliveryCoordinate with implementation partners and internal teamsQualification for SuccessNative or near-native English language skills, all writing and client interaction will be in English6–10 years of experience spanning FP&A, ERP implementation, financial systems consulting, or a combination of theseDeep understanding of ERP transaction flows, GL structures, subledgers, dimensions, and financial reporting hierarchiesHands-on experience with mid-market ERP platforms such as Microsoft Dynamics GP, Business Central, Oracle EBS, or SAP HANAAdvanced Excel capability; Power Query, Power Pivot, DAX, and experience building reports used by large groups of end usersPractical SQL mastery; ability to reverse-engineer queries, trace data to source systems, tune for performance, and diagnose reporting errorsDemonstrated experience building financial reports end-to-end, including scoping, layout, validation, and reconciliationAbility to operate independently without rigid specifications, consulting or implementation background strongly preferredDevelopment 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 preferredBackground in financial software, reporting tools, or BI platforms is an assetDiversity, 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, affection
30 days ago