Report Developer

Bayshore • Mississauga, ON

8h

About The Position

As a Report Developer, you will be responsible for writing complex scripts to extract data for the purpose of building client reports. This role also requires Microsoft CRM development skills to customize the current database to support future reporting requirements.

Requirements

• 5+ years of experience with Microsoft CRM 365 with strong knowledge of and experience with platform capabilities, out of the box configurations, customizations, and integration with other components such as SharePoint, Exchange Server, and Outlook etc. or other equivalent CRM experience
• 5+ years of experience with Microsoft SQL Server (RDBMS, SSRS, SSIS and SSAS Tabular/Multidimensional)
• 5 – 8 years of experience working with complex data sets
• 2+ years of experience with Developer scripting Language (.Net, Python, PowerShell, Command)
• Experience with Microsoft Azure technology stack
• Strong written and verbal communication skills

Nice To Haves

• Data transformation knowledge and overall knowledge of Data Science techniques is an asset
• Experience working with pharmaceutical data is an asset
• Knowledge in data warehouse, ETL, data modeling is an asset

Responsibilities

• Design forms, workflow processes, web services and other components needed to meet the business requirements of the departmental customers utilizing Microsoft CRM
• Assist and support other programmers in development, techniques and coding assignments
• Develop efficient data solutions through MS application stack including MS SQL Management Studio, SSRS, SSIS, SSAS, Power BI, Data repository, Data Lake reporting solutions
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Develop reports to support internal and external commitments
• Follow standard Software Development Life Cycle (SDLC) practices
• Utilize DevOps tracking methodology and Source control systems
• Generating and distributing reports internally and externally
• Recommend and implement innovations and efficiencies in technology for reporting solutions and development platforms
• Develop, implement data collection and data analytics best practices that optimize efficiency and quality
• Maintain data integrity by creating quality checks and reports to support different processes
• Work with management to prioritize business and information needs
• Formulating and communicating meaningful and actionable process plans
• Working in partnership with IT and Business Lines to support multiple projects
• Participate in ongoing internal and/or external continuing education activities
• Adhere to Bayshore Policies and Procedure
• Participate in quality activities and continuous improvement initiatives in keeping with the company’s Quality Management System
• Adept at queries, report writing and presenting findings
• Participates in proactive Health & Safety activities while performing all duties. Is responsible to notify immediate Supervisor of any health and safety risks or concerns. Responsible for completing Accident Reports for all direct reports who injure themselves on the job, within 24 hours of the incident.
• Maintains confidentiality of client and corporate information and discusses same only with appropriate Bayshore personnel

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level