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.

#J-18808-Ljbffr

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