We are looking for an experienced Business Intelligence (BI) Consultant to join our team on a contract basis in Toronto, Ontario. In this role, you will support the development of a corporate Power BI dashboard, integrating data from multiple systems to provide real-time organizational insights. This position offers an excellent opportunity to contribute to meaningful projects within the non-profit sector.<br><br>Responsibilities:<br>• Design and implement data pipelines to merge information from various sources into a Microsoft Fabric-based data warehouse.<br>• Evaluate source systems to identify necessary data, perform transformations, and load data into properly structured warehouse tables.<br>• Develop efficient data models, cubes, and views optimized for Power BI performance.<br>• Build and configure Power BI dashboards based on predefined elements, layouts, and visualization requirements.<br>• Ensure all components, from data ingestion to visualization, are scalable, accurate, and perform effectively.<br>• Collaborate with stakeholders to understand data requirements and deliver tailored solutions.<br>• Troubleshoot and resolve issues related to data integration and dashboard functionality.<br>• Maintain documentation for data architecture, pipelines, and dashboard configurations.<br>• Identify opportunities for process improvements within data and reporting workflows.<br>• Stay updated on industry trends and best practices in business intelligence and data visualization.
<p>We are seeking a talented Oracle Analytics Server (OAS) and OBIEE Developer to join our client's team in Mississauga, Ontario. In this role, you will design, develop, and maintain advanced analytics solutions that drive strategic business outcomes. The ideal candidate possesses strong technical expertise and excels at collaborating with stakeholders to deliver impactful insights and results.</p><p><br></p><p><strong>Key Responsibilities:</strong></p><ul><li>Create interactive dashboards, detailed reports, and data visualizations using Oracle Analytics Server (OAS) and OBIEE.</li><li>Develop and update OBIEE repository layers, including Physical, Business Model, and Presentation layers.</li><li>Perform comprehensive data analysis for OLAP applications and support related ETL processes.</li><li>Implement and refine ETL jobs, troubleshoot data issues, and optimize data mappings for efficiency.</li><li>Integrate OAS and OBIEE platforms with various data sources, such as Oracle databases and APIs, to ensure seamless data flow.</li><li>Provide ongoing support and maintenance for OAS, OBIEE, and Oracle databases, aligning system performance with business requirements.</li><li>Enforce security protocols, including Row-Level and Object-Level Security, to safeguard sensitive information.</li><li>Produce pixel-perfect reports using BI Publisher to address complex reporting needs.</li><li>Collaborate closely with business users to understand requirements and deliver robust analytics solutions.</li><li>Optimize Oracle and PL/SQL queries to maximize performance and data integrity.</li></ul><p><br></p>
