- Company Name
- Solutions 2 GO Inc.
- Job Title
- Senior Financial Data & BI Analyst (9-Month Contract)
- Job Description
-
**Job Title:** Senior Financial Data & BI Analyst
**Role Summary:** Lead data consolidation, standardization, and BI reporting for financial and operational data across global systems, ensuring accuracy and alignment with financial records.
**Expectations:** Consolidate and reconcile financial data from multiple source systems (ERPs, CRM, logistics) into standardized BI outputs; own end-to-end data validation processes to support period-end close and audit requirements.
**Key Responsibilities:**
- Extract, validate, and reconcile financial data using SQL Server against GL, billing systems, and revenue recognition.
- Design and implement global data standardization rules to unify inconsistent datasets from ERPs, CRM, logistics systems, and spreadsheets.
- Build Power BI models, DAX measures, and dashboards to deliver actionable insights with drill-down capabilities.
- Develop mapping tables, testable rulesets, and staging tables to ensure data consistency and audit readiness.
- Collaborate with Finance, Operations, and IT teams to refine requirements, document procedures, and present reconciliation outcomes.
**Required Skills:**
- Advanced SQL Server querying (complex queries, joins, CTEs).
- Power BI: data modeling, DAX, Power Query, dashboard design.
- Financial acumen: GL reconciliation, billing, revenue recognition.
- ERP system experience (Dynamics, SAP, NetSuite).
- Multi-system data integration (CRM, logistics, spreadsheets).
- Strong documentation and data governance practices.
**Required Education & Certifications:**
- Bachelor's degree in Finance, Accounting, Information Systems, Data Analytics, or Computer Science.
- Certifications: None specified.
---
*Output adheres to ATS-friendly keywords and global neutrality. Excludes company details, location, benefits, and non-essential text.*