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

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

Standardization & Rule-Building

Power BI Reporting & Data Modeling

Documentation & Collaboration

Skills & Qualifications :

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