RQ10389 Business Intelligence Specialist Oracle Senior

Responsibilities:

• Provides a comprehensive range of I&IT business analysis services for clients with diverse business and technological needs.
  
• Interacts with the business stakeholders and subject matter experts in order to understand their requirements through gathering documenting and analyzing business needs and requirements.
  
• Prepares and advises on business analysis policies processes best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
  
• Provide technical support and participate in the development package creation code merge testing and release activities.
  
• Primary interface between technical teams (Dev QA) and business stakeholders focusing on requirements clarification.
  
• Develop and manage solutions using Power BI Cognos Oracle MS-SQL Visual Studio SSIS Attunity framework GIT and SQL-based reporting tools.
  

General Skills:

• Leads and conducts business analysis in order to assess clients business problems/opportunities and documents the business requirements in such a way that I&IT solutions can be determined.
  
• Applies re-engineering concepts to promote business improvements through alternative and cost effective service delivery approaches
  
• Leads and conducts business analysis at varying levels of detail appropriate to the project and phases of project aligning with OPS Unified Project Management Methodology Enterprise Architecture and Gating Process and OPS Standard
  
• Systems Development Methodologies
  
• Develops strategies prepares business cases and cost-benefit analysis and conducts feasibility studies for business I&IT initiatives
  
• Develops sound processes for requirements gathering including but n o t limited to JAD sessions interviews mockups etc.
  
• Conducts business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non-functional requirements definitions for assigned projects
  
• Monitors progress resolves problems and reports regularly to I&IT management and stakeholders
  
• Develops performance measures and traceability matrices for business analysis evaluation and conducts follow-up
  
• Experience developing strategies preparing business cases and cost-benefit analysis
  
• Experience conducting requirements gathering developing documentation including presentations and briefing notes and conducting stakeholder engagement
  
• Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope
  
• Awareness of emerging I&IT trends and technologies
  
• Excellent analytical problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
  
• A team player with a track record for meeting deadlines
  

Desirable Skills:

• Experience in the use of information retrieval packages
  
• Knowledge and understanding of Information Management principles concepts policies and practices
  
• Ability to translate business and data requirements into specifications sufficient for designing appropriate technology solutions
  
• Experience with a wide range of methods tools and techniques for business analysis such as: business functional modelling business event modelling business process mapping
  
• Experience in structured object oriented and agile methodologies for user requirements
  
• Experience developing performance measures for business analysis evaluation and subsequent follow-up
  
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
  
• Provides a comprehensive range of I&IT business analysis services for clients with diverse business and technological needs. Interacts with the business stakeholders and subject matter experts in order to understand their requirements through gathering documenting and analyzing business needs and requirements.
  
• Prepares and advises on business analysis policies processes best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
  

Requirements

Experience and Skill Set Requirements:

MUST HAVES:

5-7 years Experience:

• Power BI Services (Cloud) - Design and Development of Reports
  
• Power BI Server (On-Prem) - Design and Development of Reports
  
• Microsoft SQL Database
  
• ETL Process SSIS Daily Jobs Handling
  
• Release Pipeline Automation
  
• Deployment Coordination with Release Infrastructure and Operations Team
  
• Data Analysis and Management
  
• Semantic Model design & development
  

Skill Set Requirements:

Technical Experience:

• The ideal candidate should possess 5-7 years of experience as a Business Analyst with a focus on the following project environments:
  
• Required Skills (3-5 years): Power BI MS SQL Server SSIS Informatica ETL Cognos Development Data Migration & Transformation
  
• Preferred Skills (2-4 years): Oracle Visual Framework Java Cloud Services Data Warehousing Advanced Data Analytics Version Control
  
• Extensive experience designing and implementing BI solutions for both on-premise and cloud environments ensuring scalability performance and maintainability.
  
• Led technology upgrade and migration projects to Microsoft BI Suite determining which components to migrate rebuild or optimize.
  
• Over 5 years of hands-on experience in ETL development and data warehousing including large-scale data migrations and daily operational data loads.
  
• Deep knowledge of the Microsoft technology stack including Azure Data Factory SSIS SSAS SSRS Power BI and supporting tools like Visual Studio and SQL Server Management Studio.
  
• Experienced with data governance role-based access control (Azure AD) and working with multiple database platforms including Oracle and MSSQL.
  

Power BI Expertise:

• Hands-on experience with Power BI Server (On-Prem) and Power BI Service (Cloud) including report deployment administration and publishing.
  
• Skilled in designing interactive dashboards reports and visualizations that meet business user requirements.
  
• Implemented row-level security automated data refresh scheduling and performance optimization for enterprise datasets.
  
• Knowledge of integrating Power BI with other MS BI tools and Azure services for end-to-end reporting solutions.
  

Data Modeling & ETL:

• Expertise in designing and developing semantic models dimensional models and data warehouse architectures aligned with analytics needs.
  
• Strong hands-on experience with ETL development using SSIS and Azure Data Factory including debugging transformations mappings and unit testing.
  
• Skilled in data ingestion staging cleansing and integration from multiple sources to support reporting and analytics.
  
• Experience with data modeling tools such as PowerDesigner and Erwin Data Modeler for creating and maintaining accurate and efficient data models.
  

Release Pipeline Automation & Scripting:

• Hands-on experience automating ETL and Power BI deployments using CI/CD pipelines in Azure DevOps GitHub Actions or similar platforms.
  
• Proficient in scripting (PowerShell Python or command-line tools) to automate report publishing ETL job execution and environment promotion.
  
• Experienced in implementing automated testing validation and rollback mechanisms for smooth production deployments.
  
• Strong understanding of integrating version control into release workflows to maintain consistent environment and version management.
  

Release Management & Operations Support:

• Experience creating comprehensive release documentation (Release Book) and coordinating with Release and Operations teams.
  
• Capable of providing technical support troubleshooting production issues and implementing quick fixes in live environments.
  
• Knowledge of production deployment processes version control change management and environment governance.
  
• Able to review and improve existing technical documentation data dictionaries and source-to-target mappings providing guidance to development teams.
  

Documentation:

• Experienced in creating and maintaining comprehensive technical documentation including data dictionaries source-to-target mappings and data flow diagrams.
  
• Skilled in documenting data models ETL processes and BI solution designs to ensure clarity standardization and maintainability.
  
• Provides guidance and feedback to teams on improving existing documentation and aligning it with organizational data governance standards.
  
• Able to produce clear release and deployment documentation (Release Books) for technical and operational stakeholders.
  
• Ensures documentation supports troubleshooting auditing and compliance requirements across BI and data warehouse environments.
  

Core Skills:

• Experience conducting requirements gathering and developing documentation
  
• Working knowledge of systems design and development and related methods techniques practices and standards enable you to analyze and define clients business and information technology requirements pertaining to data flow and data integration; provide recommendations to business
  
• Demonstrates Analytical and problem-solving skills to assess clients business priorities and needs; to evaluate business and technical design alternatives
  
• Ability to work with business and development teams to document system requirements
  
• Demonstrated experience with creating Business Cases Screen Design/User Interface Business Process Models Privacy Impact Assessments Threat Risk Assessments and Logical architecture artifacts among other deliverables
  
• Demonstrated experience with Business Architecture
  
• Working knowledge of technology data databases applications and networking techniques tools and practices enables you to lead the design and development of infrastructure-related projects
  

Project Experience and Techniques:

• Demonstrates lead design experience with technology upgrade/migration projects and shows acumen in being able to evaluate and determine the best path going forward
  
• Demonstrates experience leading discussions with stakeholders to elicit requirements developing/consulting on options and solutions and facilitating the resolution of I&IT and Business issues. Ability to drill down on business pain points and determine the right solution rather than delivering only the item thats being requested by stakeholders
  
• Demonstrates development and design experience with SDLC processes Agile and Waterfall methodologies
  

Communication Skills:

• Demonstrated experience in solving problems analytically and making sound decisions based on
  
• Experience in negotiating using both verbal and written communication skills and should have worked in a team-based environment with a proven record of meeting deadlines
  
• Strong stakeholder engagement facilitation negotiation and consensus building
  

Public Sector Experience:

• Previous public sector experience in an organization of equivalent size or complexity to the Ontario Public Service