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.Liaises and communicates with all levels of management and other project teams to coordinate efforts.Collaborates with business users to understand and collect business requirements.Provides client and project owner satisfaction.Supports the coaching and training of staff on processes, procedures and appropriate work practices, as needed.Provides both technical and general direction to junior team members.Provides input into the performance of assigned staff, as required.Participates in enterprise architecture development and ensures that all activities adhere to client's architectural principles, standards and processes, unless an exemption has been granted.Develops and enforces policies, standards and procedures for work carried out in this area.QUALIFICATIONSDiploma in Computer Science, Computer Programming, Business Analytics or related discipline.Three years of experience in systems analysis, design and/or programming in a data warehousing environment, including two years using applicable software.Advanced knowledge of Data Warehousing concepts.Advanced knowledge of SQL programming preferably in a Microsoft environment.Ability to read and interpret database performance reports from SQL databases.Ability to prioritize multiple activities and work within deadlines.Ability to complete technical reports and conduct thorough research.Working knowledge of high-level architectural solutions.Knowledge in system integration is an asset. Working knowledge of SSIS is preferable.Ability to communicate effectively, orally and in writing, in order to convey technical information in a clear, concise and understandable manner for both technical and non-technical audiences.Ability to establish and maintain effective relationships and communication with supervisors, other employees, and vendors.Working knowledge of general insurance terminology and practices is an asset.Ability to write code in programming languages is an asset.Ability to estimate the completion of an analysis document based on the requirements provided.Ability to complete a detailed system design document based on the requirements and analysis document provided.Ability to read and create a process flow diagram.Ability to support databases, analytics and reporting servers.Experience with SSIS is a must.Consistent with our commitments to equity and diversity, we actively recruit from all designated groups. We also provide employment accommodation upon request to current staff members and to applicants during the recruitment process. We aim to provide a work environment where excellence is allowed to flourish and diversity is prized. Compugen is committed to providing accommodation throughout the interview and employment process. If you require an accommodation, the hiring manager and the human resources contact will work with you to meet your needs.
#J-18808-Ljbffr