Remote opportunity at
Rubicon PathRQ07958 - Sr. Business Intelligence Specialist
Rubicon Path is seeking a Sr. Business Intelligence Specialist to support organizational information requirements by implementing and maintaining business intelligence software solutions. This position suits an…
Career Tools
About This Role
Rubicon Path is seeking a Sr. Business Intelligence Specialist to support organizational information requirements by implementing and maintaining business intelligence software solutions. This position suits an experienced data professional who can build customized query applications, create guided analysis tools, and deliver automated trend and opportunity alerts. The selected candidate will help clients manage data effectively to connect operational activities with broader strategic objectives. The role focuses heavily on data extraction,…
Job Description
Rubicon Path is seeking a Sr. Business Intelligence Specialist to support organizational information requirements by implementing and maintaining business intelligence software solutions. This position suits an experienced data professional who can build customized query applications, create guided analysis tools, and deliver automated trend and opportunity alerts. The selected candidate will help clients manage data effectively to connect operational activities with broader strategic objectives.
The role focuses heavily on data extraction, transformation, and loading processes, as well as troubleshooting source system cleanliness issues. Responsibilities include designing re-usable components, optimizing complex database queries, and ensuring data accuracy across relational and multidimensional repositories. The individual will work alongside diverse stakeholders to map business processes, construct enterprise architecture deliverables, and document interface specifications between BI solutions and external applications.
Ideal candidates bring substantial technical expertise utilizing the Microsoft BI stack and cloud infrastructure environments. The position demands strong collaboration skills to guide users through complex projects within both agile and waterfall methodologies while adhering to accessibility regulations.
Responsibilities
- Implement and maintain business intelligence software solutions and custom query applications
- Build guided analysis, drill-down functionality, and automated alerts for key business trends
- Develop initial and daily data extraction, transformation, and load programs across relational and multidimensional repositories
- Create schedule and dependency logic for ETL scripts alongside monitoring and error notification processes
- Analyze source systems to identify data cleanliness issues and establish feedback loops to correct corrupt data
- Generate scheduled and ad-hoc research models and reports
- Perform process mapping, business process re-engineering, and complex data modeling using UML
- Design and develop solutions utilizing Microsoft Azure or other cloud infrastructure
- Build cubes, reports, and dashboards with SSAS, SSRS, and Power BI
- Develop and utilize re-usable components for BI processes with detailed documentation
- Write, debug, and enhance the performance of complex SQL queries
- Document code changes and build web and reporting applications meeting WCAG AA compliance
- Integrate token-based authentication solutions such as Azure Active Directory or Auth0
- Execute software testing including unit testing, SIT, SAT, and UAT
Requirements
- Experience designing and developing with the Microsoft suite of BI tools including SQL Server, SSIS, Azure Data Factory, SSAS, SSRS, and Power BI
- Design and development experience as a BI Programmer or Developer
- Experience developing and using re-usable components for BI processes with accompanying detailed documentation
- Experience developing, debugging, and enhancing complex SQL queries
- Experience designing and developing solutions on Microsoft Azure or other cloud infrastructure and services
Qualifications
- Experience developing data analysis applications
- Understanding of Information Management principles, concepts, policies, and practices
- Experience providing expert advice to identify and eliminate redundant business processes
- Hands-on experience working with stakeholders to design and document interface specifications between BI solutions and external applications
- Experience with conceptual, logical, and physical data modeling tools such as Power Designer and Visio
- Knowledge and understanding of the Accessibility for Ontarians with Disability Act and related regulations
- Experience working with aggregate reporting
- Experience analyzing and planning the modernization of large, complex, multiplatform, and multi-tier IT systems
- Experience supporting business users on projects involving multiple interdependent applications or data sources
- Experience using TFS or Azure DevOps for application code packaging
- Experience implementing star schema multidimensional models
- Experience working in both agile and waterfall environments
- Familiarity with the Software Development Life Cycle
- Background working within the Ontario Public Service, particularly education ministries
- Experience developing applications that comply with GO-ITS standards
Core Skills
Frequently Asked Questions
Answers are based only on the employer’s listing; where it doesn’t say, neither do we.
What is the employment type for this role?
The posting specifies that this is a full-time position.
What is the salary for this position?
The job posting does not specify a salary.
What technical tool experience is required?
Applicants must have experience designing and developing with the Microsoft suite of BI tools, including SQL Server, SSIS, Azure Data Factory, SSAS, SSRS, and Power BI, as well as experience with Microsoft Azure or other cloud infrastructure.
Sample Interview Questions
AI-generated questions tailored to this specific role — a preview of the full practice set.