Senior Solutions Designer to design, develop, and implement enterprise BI solutions using Cognos and Power BI. Requires 10+ years experience in data modeling, ETL, BI architecture, and Microsoft/Azure stack.
Responsibilities
Design, develop, and implement enterprise Business Intelligence (BI) solutions using Cognos and Microsoft Power BI. Translate complex business requirements into scalable, high-performing technical solutions while adhering to ITS standards and industry best practices. Responsible for BI solution architecture, data warehousing, migration, transformation, and working with tools like Azure Data Factory, SSIS, SSAS, SSRS. Produce technical documentation, release books, deployment guides, and ensure compliance standards. Lead large-scale BI and data migration projects using SDLC, Agile, and Waterfall methodologies.
Requirements
Must-Have (10+ Years Overall Experience): Power BI (Service – Cloud & Server – On-Prem) report and dashboard design, Microsoft SQL Server and database development, ETL processes using SSIS and daily job scheduling/monitoring, Release pipeline automation and CI/CD (Azure DevOps, GitHub, etc.), Deployment coordination with Release, Infrastructure, and Operations teams, Data analysis, data management, and semantic model design. Core Technical Expertise: BI solution architecture (on-premises and cloud), Data warehousing, data migration, and transformation, Azure Data Factory, SSIS, SSAS, SSRS, Cognos development, Oracle and MS SQL platforms, Role-based access control (e.g., Azure AD). Preferred Skills: Visual Studio, .NET Framework, Java, Cloud services and advanced analytics, Version control systems (Git), Data modeling tools (e.g., Erwin, PowerDesigner). Core Competencies: Strong analytical and problem-solving skills, Ability to define technical roadmaps and long-term strategies, Expertise in system design, integration, and architecture, Deep understanding of Microsoft technology stack and Azure services. Project Experience: Proven experience leading large-scale BI and data migration projects, Strong background in SDLC, Agile, and Waterfall methodologies, Ability to evaluate solution options and recommend optimal approaches, Provide walkthroughs of all deliverables before assignment completion, Complete knowledge transfer at least 2 weeks before the project ends. Nice-to-Have Skills: Business analysis techniques (process modeling, functional modeling), CASE tools for requirements documentation, Awareness of emerging I&IT trends and technologies, Experience aligning solutions with organizational best practices.
Senior Solutions Architect Operations Manager optimizing operational systems, workflows, and reporting for GitLab’s DevSecOps platform. Supporting SA capacity planning, customer engagements, and data quality.
Senior Data Architect designing Microsoft Fabric, Azure, and lakehouse ecosystems for Keyrus’ intelligent enterprise solutions. Guiding architecture, integration, optimization, and delivery teams.
Principal AI Solutions Architect delivering enterprise IVR, conversational, generative, and agentic AI solutions at Genesys. Leading customer architecture, integrations, Agile delivery, and technical enablement.
Architecte TI dirigeant la modernisation des systèmes patrimoniaux de la Ville de Montréal. Conception, intégration et déploiement de solutions cloud et sur mesure.
Lead Optimizely architect designing enterprise digital platforms and AI - enabled experiences for Valtech, an experience innovation company. Advising clients, leading delivery teams, and shaping digital transformation solutions.
Solutions Engineer supporting demos, trials, integrations, and technical evaluations for Spellbook’s AI copilot for transactional lawyers. Advising enterprise prospects through the sales cycle.
Solutions Consultant connecting industrial plant systems to MaintainX’s mobile - first work execution platform. Demonstrating OT connectors and scoping integrations for manufacturing customers.
Solutions Consultant supporting Mid - Market sales for MaintainX's industrial work execution platform. Building tailored demos, trials and technical validations for manufacturing and frontline operations customers.
Solutions Consultant customizing demos and technical validations for MaintainX, a mobile - first industrial work execution platform. Partnering with mid - market sales teams and customer stakeholders.