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.
Smart Factory Manager leading a team to develop software for digitizing production lines and implementing streaming machine controls. Focused on building modern smart factory solutions and collaborating with cross - functional teams.
Solutions Engineer delivering high quality production - ready AI and software solutions for businesses at Cake. Collaborating with customers and product teams to drive successful implementations and technical support.
Bilingual Senior Consultant managing professional services and implementation of software solutions at Ricoh. Engaging with clients to optimize workflow and ensure customer satisfaction throughout the project lifecycle.
Associate Solution Architect at Vena Solutions collaborating on cloud - based SaaS architecture and solutions. Engaging with cross - functional teams in a flexible working environment for real - world problem solving.
P&C Business Partner Consultant within TELUS Health Employer Solutions, leading people strategies. Supporting Directors in Absence & Disability Management, Workers' Compensation, and Safety operations with strategic and operational support.
Enterprise & Solution Architect leading the architecture for a Canadian Credit Union's digital transformation initiative. Focused on integrating cloud - native platforms and modernizing legacy systems.
Solutions Sales Manager focusing on water treatment solutions across the USA and Canada. Building strategic relationships and driving revenue growth in the municipal market.
IT Technical Advisor managing and optimizing systems for contact center solutions at Intact. Providing technical support and enhancing collaboration between departments.
Cisco Solutions Architect designing and developing Cisco - based solutions for Softchoice. Collaborating with customers to create technical documentation and providing guidance during implementation.
Solutions Consultant providing technical expertise and leadership in cybersecurity solutions for Palo Alto Networks. Aligning customer needs with business value and driving adoption of security platforms.