Business Intelligence Developer – Central Toronto (Lawrence Park East)

About you: You are considered as a front liner, solutions driven and can provide support for all assigned areas. Your goal is to always make sure that customer value is maintained to the standards set forth by a company.You thrive in a highly collaborative, rapidly changing environment who workshard, but likes to be engaged and personable with a close nit team. Job Responsibilities: Collaborate with data analysts and operations to produce insightful business intelligence related to the Supply Chain distribution and contract packaging operations. Support the development of key processes to design and manage Supply Chain performance management reporting leveraging data analysis while ensuring linkage to the strategic planning process. Manage data and data mining providing analytical support through data collection and analysis to support business decision making Work proactively with key business partners to identify opportunities and to drive transformational business growth initiatives, which deliver customer and shareholder value and meet targets as agreed with company senior leadership. Requirements Related university degree in computer science or software engineering. 3-5 years of experience as SQL/Bi Developer, involved in Design, Development, and Support of MS SQL Server 2005/08/12/14/16, and providing Business Intelligence solutions using SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). Knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT and Dimension Tables using Analysis Services. Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages. Experience in design and development of ETL packages for integrating data from various data sources (Excel, Xml, flat file, Web APIs, MS Access) to MS SQL Server using Data Tools, SSIS. Proficiency in creating SSIS packages using SSIS variables and expressions (for dynamic ETL), SSIS Control Flow) and SSIS Data Flow items. Experience working in agile environment for Custom workflows and dashboards using JIRA. ETL Tools SQL Server Business Development studio (BIDS), SQL Server Integration services (SSIS) [2008, 2012 and 2014], Data Transformation Services (DTS) SQL Server Tools SQL Server Management Studio, Reporting Services Configuration Manager, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Import and Export Data wizard. Reporting and Analysis Tools SQL Server Reporting Services, Microsoft Power BI, PowerPivot, Power View, SharePoint, SSAS If you are interested in this opportunity, please apply with an updated resume in MS Word Format. Due to the volume of resumes wereceive, only those applicantswhose skill set match our requirements will be contacted. All applicants must have legalauthorization to work in Canada for an unlimited period of time.