Senior Financial Data & BI Analyst (9-Month Contract)

Job Description

Job Description

Job Description

About Us

Are you ready to move distribution forward?

Solutions 2 GO is a premier global distributor of video game products. With operations reaching 19 countries in North, Central and South America, and partnerships that further extend to Europe, Africa, Australia and Asia, Solutions 2 GO represents all publishers in the Canadian market, offers coast-to-coast distribution in the USA and is the exclusive distribution partner for Sony PlayStation in Latin America. Our leadership, processes and partnerships have earned us a reputation as the premier provider of flexible, dynamic distribution solutions for publishers, manufacturers and retailers around the world.

We are a remarkable team that delivers remarkable results. Our people help move Solutions 2 GO forward every day, through a shared commitment across every facet of our business. At Solutions 2 GO, we are moving distribution forward. If you are an achiever who is relentless in ensuring that we achieve business results and create a great company culture while doing it, then we’re looking for you!

Scope:

The Senior Financial Data & BI Analyst is responsible for consolidating and standardizing financial and operational data from multiple enterprise systems to deliver accurate, reconciled, and trusted business intelligence outputs. This role partners closely with Finance and cross-functional teams to ensure data integrity, consistency, and alignment with financial records. This role will consolidate data across two ERPs, a CRM, logistics systems, and spreadsheets, and build accurate, reconciled, and standardized reporting outputs. The position will own the process of investigating source systems, designing standardization rules, validating data against GL, billing, and revenue recognition, and delivering trustworthy BI assets.

Duties & Responsibilities:

• Data Discovery & Extraction (SQL Server)
  • Analyze SQL Server database schemas to understand the data structure and relationships
  • Write advanced SQL queries (joins, CTEs, aggregations) to extract financial and operational data from ERP database tables
  • Design and build SQL scripts that extract, validate, and reconcile ERP transaction data (including revenue, sales, and GL postings) into standardized datasets used for period-end close and audit procedures
  • Create staging tables, mapping tables, and QA datasets for reconciliation.

• Reconciliation & Financial Validation

  • Perform reconciliations against:
    • General Ledger (GL)
    • Billing systems
    • Revenue recognition outputs
  • Perform variance analysis, completeness checks, tie-outs, and exception tracking.
  • Document reconciliation logic and provide audit-ready evidence.

• Standardization & Rule-Building

  • Build a global standardized category model that unifies inconsistent ERP, CRM, logistics, and spreadsheet data
  • Develop rulesets (conditional logic) to categorize non-uniform data into predefined categories
  • Create and maintain mapping tables; ensure rules are transparent, testable, and repeatable

• Power BI Reporting & Data Modeling

  • Build semantic models, DAX measures, dataflows, and dashboards in Power BI
  • Implement refresh pipelines and monitor data quality
  • Deliver intuitive reports with drill-downs, filters, and standardized KPI logic

• Documentation & Collaboration

  • Maintain complete documentation: definitions, mappings, data lineage, QA processes
  • Collaborate closely with Finance, Ops, Sales, and IT teams to refine requirements
  • Present reconciliation outcomes and ensure stakeholder confidence in final report

Skills & Qualifications:

• Bachelor’s degree in Finance, Accounting, Information Systems, Data Analytics, Computer Science,
• Advanced SQL Server experience (complex queries, joins,)
• Strong Power BI (Power Query, modeling, DAX)
• Accounting/finance knowledge — especially GL flows, billing structures, and revenue recognition logic.
• Experience with enterprise ERP systems (i.e Dynamics, SAP, NetSuite)
• Experience working across multiple systems (ERPs, CRM, logistics, spreadsheets)
• Strong reconciliation, variance analysis, and QA skills
• Excellent documentation discipline
• Experience building normalization/mapping frameworks across multi‑system environments
• Background in distribution, supply chain or multi-entity business environment
• Background in data governance, lineage, or audit compliance

The successful candidate will receive a conditional offer, contingent upon the successful completion of a background check conducted by our contracted third-party vendor. The specific clearance requirements vary by position and may include one or more of the following: criminal background check, credit check, employment verification, education verification, and driver’s abstract review. If you have any questions along the way, please do not hesitate to ask.

Solutions 2 GO Inc. is an equal opportunity employer. Accommodations are available on request for candidates taking part in all aspects of the selection process.

For more information on Solutions 2 GO Inc., please visit our website at: www.solutions2go.ca