IT Solutions Designer BI

Posted via LinkedIn Recruiter (not a company profile)

Posted 3 months ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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.

Job type

Contractor

Experience level

Senior

Salary

$500.00 to $800.00 per day

Degree requirement

No Education Requirement

Tech skills

Power BICognosMicrosoft SQL ServerSSISAzure DevOpsGitHubAzure Data FactorySSASSSRSOracleVisual Studio.NET FrameworkJavaGitErwinPowerDesigner

Location requirements

Linkedin Recruiter PostTorontoOntario Toronto

Report this job

Found something wrong with the page? Please let us know by submitting a report below.