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 (Winnipeg)
🏢 Rubicon Path
📍 Winnipeg