.Compugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design, acquire, integrate and operate technology. Our mission is to help organizations realize new possibilities. Every day, our dedicated staff across North America focus on providing extraordinary customer service and support experiences to private and public sector organizations. We combine breadth of skill, depth of expertise, and commitment to operational excellence at scale to deliver exceptional, customer-focused experiences. If you are driven to make a difference, relentlessly curious and collaborative at the core, we'd love to talk to you.Join us and help us make a difference.RESPONSIBILITIESDevelops SQL queries, stored procedures and reports, using customer requirements and documents, in accordance with established criteria and standards.Designs, integrates, tests, maintains and supports automated reports delivered through SSIS or other technologies, as required.Develops test data and analyzes the results.Participates in peer reviews of SQL queries and reports.Designs and executes the moving of data from one environment to another by using Imports, BCP, or SQL queries.Prepares operational documentation for the system users and support teams according to established departmental and divisional standards.Contributes to team effort by completing assigned tasks and supporting other team members.Leads and coordinates change and implementation activities in accordance with established criteria and standards.Creates program design specifications in accordance with established criteria and standards.Follows and is compliant with client's policies and procedures and the Freedom of Information and Protection of Privacy Act.Prepares or assists with feasibility studies, requirements definitions (e.G. Source to Target Mappings), conceptual design documents, work plans, systems designs, implementation designs, system and program specifications, and system and client documentation.Troubleshoots production systems.Researches and has a deep understanding of sources of data.Develops and manages implementation of data/code fixes for defects utilizing the Application Lifecycle Management (ALM) process.Monitors data warehouses load performance and data quality on a regular basis or for month-end and works with Information Technology (IT) staff to improve both performance and quality.Consults with managers in requesting business units to determine project timelines, and where necessary, develops project plans to complete data warehouse requests.Implements small source system changes within databases that are not part of clients Projects such as new products and cover codes.Leads the development, increment and maintenance of data warehouses and Operational Data Stores.Resolves issues related to service requests or production problems.Conducts regular meetings with user contacts