Business intelligence consultant building Sage Intacct and Sage 300 CRE financial reports. Supporting accounting and operations teams with SQL-integrated, multi-entity reporting solutions.
Responsibilities
Design, develop, and maintain custom financial and operational reports and dashboards in Sage Intacct
Build and manage reports in Sage 300 CRE using Crystal Reports and Office Connector
Ensure reports accommodate multi-entity, multi-currency, and department-specific needs
Align reporting outputs with month-end and quarter-end close cycles and ad hoc reporting requests
Maintain data accuracy, consistency, and usability
Replicate key data into SQL tables when built-in tools are insufficient
Support advanced report generation using SQL and Crystal Reports
Troubleshoot data access and quality issues across systems and reports
Gather reporting requirements from Accounting, Finance, and Business Operations teams
Deliver customized reporting solutions to internal stakeholders and clients
Provide guidance, documentation, and user support for interpreting and modifying reports
Document report logic, data sources, and version history
Share reporting best practices and train internal team members as needed
Requirements
2+ years of experience with Sage Intacct, particularly in report development
Proficient with Financial Report Writer
Proficient with ICRW and Custom Report Wizard
Proficient with Dashboards and Dimensions
Proficient with Crystal Reports and Office Connector (Sage 300 CRE)
Strong understanding of GAAP and financial reporting fundamentals
Experience with multi-entity and multi-currency environments
Ability to analyze and reconcile data across AP, AR, GL, Projects, Time & Expenses
Working knowledge of SQL and stored procedures for reporting and data integration
Effective communication with technical and non-technical stakeholders
Candidates must be authorized to work in the US or Canada
Preferred: experience supporting clients or internal teams in the construction industry
BI Developer modernizing Iceberg Finance’s analytics platform with Microsoft Fabric, SQL, Python, Spark, and Power BI. Building data pipelines and models that drive finance business decisions.
Functional Data Analyst defining BI requirements, KPIs, and data validation for Quebec’s energy sector. Delivering Databricks and Azure analytics solutions in a hybrid Montreal setting.
Analyste BI chez iA Financial Group, assureur et gestionnaire d’épargne, développant des tableaux de bord et analyses d’expérience client. Mesure les parcours numériques, le NPS et les occasions d’amélioration.
Business Intelligence Analyst supporting Intact Insurance’s underwriting teams with KPI development and operational performance analytics. Improving data quality, productivity, service quality, and operational excellence.
Remote Power BI Specialist building enterprise dashboards and reports from Dynamics 365 F&O data. Optimizing DAX, SQL, data pipelines, and executive analytics for Canadian stakeholders.
Senior Business Intelligence Analyst driving KPI management, forecasting, and profitability insights for MGID’s global native advertising platform. Partnering with Commercial, Demand, Finance, Product, Sales, and Data teams.
Senior Business Intelligence Analyst driving KPI management, forecasting, and profitability insights for MGID’s global native advertising platform. Supporting commercial growth through SQL, Python, BI, and data analysis.
Étudiant(e) analyste BI chez iA Financial Group, développant des rapports et tableaux de bord. Automatisation de processus et analyse de données pour l’assurance, l’épargne et la retraite.
Senior BI Engineer building data models, semantic layers, and dashboards for Jobber’s small - business service platform. Driving governed self - service analytics and trusted business metrics.
Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.