- 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
- 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
-
Solutions 2 GO is a premier global distributor of video game products with operations in North America and partnerships extending to Europe Africa Australia and Asia. The company represents all publishers in the Canadian market offers coast-to-coast distribution in the USA and is ...
Brampton3 weeks ago
-
The company Insight Global is hiring a Data Analyst for a Quality Assurance and Inspection company. · translate complex data into clear, actionable recommendations, · drive continuous improvement through analytics, · operate effectively in a fast-paced environment with minimal ov ...
Mississauga2 weeks ago
-
· Job Description · The Financial Data Entry Coordinator is responsible for accurate and timely entry of multiple Aramark locations financial data. Essential functions and responsibilities of the position may vary by Aramark location based on client requirements and business nee ...
Mississauga $18 - $21.75 (CAD) Freelance1 week ago
-
Job Description · The Financial Data Entry Coordinator is responsible for accurate and timely entry of multiple Aramark locations financial data. Essential functions and responsibilities of the position may vary by Aramark location based on client requirements and business needs. ...
Mississauga, ON LW G1 week ago
-
Job Description · The Financial Data Entry Coordinator is responsible for accurate and timely entry of multiple Aramark locations financial data. Essential functions and responsibilities of the position may vary by Aramark location based on client requirements and business needs. ...
Mississauga, Ontario1 week ago
-
We at Kelly hear you, and we're here for you We're seeking a Business Information Management Analyst III to work at a premier financial institution in Toronto, · Ontario.Sound good? Take a closer look below. You owe it to yourself to consider this great new opportunity. · ...
Toronto3 weeks ago
-
The Financial Data Analyst is responsible for analyzing financial transactions ensuring accuracy in reporting identifying discrepancies and driving process improvements. · Extract and analyze financial data from the book of record Clarity system · Validate transactions and identi ...
Toronto3 weeks ago
-
The Financial Data Analyst will assist in developing updating and maintaining platforms models and procedures used in financial results of HomeEquity Bank. · University Degree · 5 years+ experience in a Canadian financial institution working in an analytical capacity. · ...
Toronto1 month ago
-
The Financial Data Analyst will support the FinOps team by developing detailed financial reports, · enhancing forecasting models, · and implementing monitoring and reporting tools across all Rahona assets. · ...
Toronto $69,700 - $98,400 (CAD)1 month ago
-
We are seeking a Financial Data Analyst to join our team at HomeEquity Bank. The successful candidate will assist in developing and maintaining financial platforms, models and procedures used in the bank's results. · ...
Toronto Full time1 month ago
-
The role is a critical member of the Finance team and will assist developing, · updating and maintaining platforms, · models and procedures used in · the financial results of HomeEquity Bank (the Bank).Maintain reports and queries supporting other department requests. · Maintain ...
Toronto, Ontario1 month ago
-
We are looking for a Financial Data Analyst Intern/Co-op student to join our Crestpoint Real Estate Investments Ltd. · This role blends finance, data, quantitative analysis, and technology—ideal for a student interested in real estate capital markets, · financial modeling, and ap ...
Toronto1 month ago
-
Join FMP– A Fintech Leader Transforming Financial Market Data · FMP is at the forefront of the fintech revolution, delivering Financial Market Data as a Service (DaaS) to empower businesses of all sizes. · About Us:FMP is at the forefront of the fintech revolution... · Our missio ...
Toronto1 month ago
-
We are looking for a Financial Data Analyst Intern/Co-op student for an existing vacancy for a 4-month term to join our team. This role blends finance, data, quantitative analysis and technology ideal for students interested in real estate capital markets financial modeling and a ...
Toronto, Ontario1 month ago
-
Join FMP– A Fintech Leader Transforming Financial Market Data · Analyze extensive datasets to identify trends, patterns and opportunities for improvement. · Ensure data quality and integrity through robust database design and record linkage techniques. · ...
Toronto, Ontario1 month ago
-
Venture outside the ordinary - TMX Careers · The TMX group of companies includes leading global exchanges such as the Toronto Stock Exchange, Montreal Exchange, and numerous innovative organizations enhancing capital markets. United as a global team, we're connecting cross-funct ...
Toronto $25 - $28 (CAD) Full time1 week ago
-
We are looking for a Financial Data Analyst Intern/Co-op student to join our Crestpoint Real Estate Investments Ltd. team. · ...
Toronto, ON MX C1 month ago
-
Venture outside the ordinary - TMX Careers · The TMX group of companies includes leading global exchanges such as the Toronto Stock Exchange, Montreal Exchange, and numerous innovative organizations enhancing capital markets. United as a global team, we're connecting cross-functi ...
Toronto, ON1 week ago
-
Venture outside the ordinary - TMX Careers · The TMX group of companies includes leading global exchanges such as the Toronto Stock Exchange, Montreal Exchange, and numerous innovative organizations enhancing capital markets. United as a global team, we're connecting cross-functi ...
Toronto, Ontario1 week ago
-
We're looking for someone who meets the minimum requirements to be considered for the role. If you meet these requirements, you are encouraged to apply.A Financial Data Analyst will develop and maintain SQL queries to analyze and navigate complex financial data effectively. · ...
Toronto $140,000 - $210,000 (CAD)2 weeks ago
-
We are looking for a Data Analyst to join our Payments Intelligence Engineering team. The ideal candidate will have 5+ years of experience in payments at a leading technology or payments company and strong financial modeling and analytical skills. · ...
Toronto $140,000 - $210,000 (CAD)1 month ago
Senior Financial Data - Brampton - Solutions 2 GO Inc.
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
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:
#J-18808-Ljbffr
-
Senior Financial Data
Only for registered members Brampton
-
Financial Data Analyst
Only for registered members Mississauga
-
Financial Data Entry Coordinator
Freelance Only for registered members Mississauga
-
Financial Data Entry Coordinator
Only for registered members Mississauga, ON LW G
-
Financial Data Entry Coordinator
Only for registered members Mississauga, Ontario
-
Financial Data Analyst
Only for registered members Toronto
-
Financial Data Analyst
Only for registered members Toronto
-
Financial Data Analyst
Only for registered members Toronto
-
Financial Data Analyst
Only for registered members Toronto
-
Financial Data Analyst
Full time Only for registered members Toronto
-
Financial Data Analyst
Only for registered members Toronto, Ontario
-
Intern, Financial Data Analyst
Only for registered members Toronto
-
Financial Market Data Analyst
Only for registered members Toronto
-
Intern, Financial Data Analyst
Only for registered members Toronto, Ontario
-
Financial Market Data Analyst
Only for registered members Toronto, Ontario
-
Financial Research Data Analyst
Full time Only for registered members Toronto
-
Intern, Financial Data Analyst
Only for registered members Toronto, ON MX C
-
Financial Research Data Analyst
Only for registered members Toronto, ON
-
Financial Research Data Analyst
Only for registered members Toronto, Ontario
-
Financial Data Analyst, Payments Health
Only for registered members Toronto
-
Financial Data Analyst, Payments Health
Only for registered members Toronto