Business Data & Insights Developer
- Oakville, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Business Data & Insights Developer – Power BI / SSIS / ETL
Client: Cencora / Innomar Strategies
Project: Data Efficiency Dashboards
Location: Oakville, ON (Work arrangement TBD)
Employment Type: Contract
Duration: 6 months to start
We are seeking an experienced Power BI / Business Data & Insights Developer with strong hands-on experience in Microsoft Power BI and SSIS/ETL to support enterprise dashboards, reporting, and data integration initiatives.
Mandatory Skills
- Strong hands-on Power BI development, including dashboards, reporting, DAX, Power Query, and data modelling.
- Strong hands-on Microsoft SSIS / ETL experience, including data integration and transformation workflows.
Strongly Preferred
- SQL Server, T-SQL, stored procedures, and query optimization.
- Enterprise BI reporting and data warehousing.
- Business analysis, requirements gathering, and stakeholder engagement.
- Excellent communication and problem-solving skills.
Highly Desirable
- SAP BusinessObjects and/or Databricks.
- Azure Data Factory (ADF), Python, or PySpark.
- Pharmaceutical or healthcare industry experience.
Key Responsibilities
- Design, develop, and optimize Power BI dashboards and reports.
- Build and maintain SSIS/ETL data integration workflows.
- Develop SQL queries and data models to support enterprise reporting.
- Work with business stakeholders to gather requirements and deliver reporting solutions.
- Ensure data accuracy, reporting performance, and data quality.
More about this job
Responsibilities
Design, develop, and optimize Power BI dashboards and reports, and build and maintain SSIS/ETL data integration workflows. Develop SQL queries and data models, gather requirements with business stakeholders, and ensure reporting accuracy, performance, and data quality.
Requirements
The role requires strong hands-on Power BI development, including dashboards, DAX, Power Query, and data modeling, as well as Microsoft SSIS/ETL experience. SQL Server, T-SQL, enterprise BI reporting, data warehousing, business analysis, and stakeholder engagement are preferred; SAP BusinessObjects, Databricks, Azure Data Factory, Python/PySpark, and pharmaceutical or healthcare experience are desirable.
Skills
- Power BI
- Dashboard Development
- Reporting
- DAX
- Power Query
- Data Modeling
- SSIS
- ETL
- SQL Server
- T-SQL
- Stored Procedures
- Query Optimization
- Data Warehousing
- Business Analysis
- Requirements Gathering
- Stakeholder Engagement
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Healthcare
Keywords
- Power BI
- SSIS
- ETL
- SQL Server
- T-SQL
- DAX
- Power Query
- Data Modeling
- Data Integration
- Data Transformation
- Enterprise BI
- Business Intelligence Reporting
- Data Warehousing
- Stored Procedures
- Query Optimization
- Business Analysis
- Requirements Gathering
- Stakeholder Engagement
- SAP BusinessObjects
- Databricks
- Azure Data Factory
- Python
- PySpark
- Pharmaceutical Industry
- Healthcare
- Data Quality
- Dashboard Development
- Data Efficiency Dashboards