Data modeling and ETL expertise anchor this Senior Business Intelligence Specialist role. Apply SQL Server, Oracle, R Shiny, and analytical skills to complex data.

This position blends business intelligence development with business analysis across relational and multidimensional data stores. Responsibilities include data extraction, transformation, loading, monitoring, reporting, interface documentation, and customized analysis. The specialist also supports enterprise architecture deliverables, data quality processes, and information models that help reduce redundant business processes.

Key Responsibilities:

- Develop ETL programs for daily and initial data loads
- Maintain ETL schedules, dependencies, monitoring, and error notifications
- Analyze source data for missing, duplicate,



and invalid values
- Document interfaces between BI solutions and external applications
- Develop data models, reports, dashboards, and analysis applications

Requirements:

- Database design experience with SQL Server and Oracle
- R Shiny or R Server experience required
- Proficiency in complex queries and scripting languages
- Experience with Power Designer, Visio, or modeling tools
- Seven-plus years combining BI development and business analysis

Use ETL, data modeling, R Shiny, and database expertise to build reliable business intelligence solutions.

📌 Senior BI Developer Data Modeling (Toronto)
🏢 Rubicon Path
📍 Toronto