Tag: Getse

Database Analyst

Purpose of the Post:To carry out Microsoft SQL Server database processing, reporting and administration for automotive databases, including “Motorparc” (vehicles in use), “Anonymised” (new, used and vehicles in use) and MOT data.To create and run reports for customers and stakeholders.To carry out linking of SMMT data to other data sets, including DVLA model codes and insurance group rating (Thatcham / code44).To develop new reporting services and help generate additional income.To build and maintain knowledge of the underlying data and processes and to create/maintain documentation accordingly.To develop an understanding of the business requirements behind the databases and reports.To help improve SMMT data processes and efficiency through technical innovation.To help identify and meet future requirements for automotive data by keeping in touch with other SMMT departments (especially Public Policy and Vehicle Legislation) and external organisations and stakeholders.Please note that the this role requires good technical skills, especially Microsoft SQL Server, but also involves strong interpersonal and team working skills and a certain amount of general business administration, as well as helping out with day to day running of the department and company.Qualifications/Skills/Attributes required:Strong data analysis and processing skills.Proven experience of Microsoft SQL Server. Ability to work with complex databases, to write new complex queries and to understand and adapt existing SQL scripts and procedures.Proficient in the use of Microsoft Office software including MS-Word, MS-Excel, and ideally MS-Access.Strong team player with good customer facing and interpersonal skills.Ability to multi-task and prioritise to meet deadlines.High level of concentration and accuracy.Initiative, ability to learn and enthusiasm, self-starter.Aware of the need to maintain the confidentiality of personal data and commercially sensitive information and comply with contractual requirements.Main duties include:Carry out monthly, quarterly and annual take-on of external data sets.Database administration and housekeeping.To receive and process enquiries and orders for data from customers and other stakeholders and to carry these through to invoicing and order renewal.Carry out weekly vehicle model coding / linking e.g. DVLA codes and insurance group rating (Thatcham / code44).To liaise with the SMMT accounts department on customer invoicing and related financial matters.To help ensure the security and integrity of the databases and compliance with SMMT policies and supplier contract(s).To help develop, document and improve the database take-on and reporting processes.To evaluate and integrate other information sets into SMMT systems as required.To assist in the day to day running of the department and company.To carry out other duties as directed by the line manager and/or head of departmentSalary and benefits package:The package includes private medical insurance, company pension scheme, flexi time, 25 days annual leave, childcare vouchers, interest free season ticket loan (after six months).Deadline for Applications:4 July 2016Method of Application:Prospective candidates should e-mail [email protected] with a CV and covering letter quoting your salary expectations.Early applications are encouraged as interviews will take place and the position offered before this date if a suitable candidate is found.Click to share on Facebook (Opens in new window)Click to share on Twitter (Opens in new window) read more

Brock building codes updated

Several of Brock’s building codes were updated in May.New building codes to several St. Catharines campus buildings will now appear on campus maps, event locations and student and faculty timetables within BrockDB and Sakai.Changes of note include:South Block changed from ‘AS’ to ‘STH’573 Glenridge changed from ‘GL’ to ‘GLN-A’ (or GLA on timetables)International Centre changed from ‘IC’ to ‘GLN-B’ (or GLB on timetables)Plaza Building changed from ‘PL’ to ‘PLZ’Cairns Family Health and Bioscience Research Complex changed from ‘CA’ to ‘CRN’Goodman School of Business (formerly Taro Hall) changed from ‘TA’ to ‘GSB’The Rankin Family Pavilion (under construction) is RFPBelow is a full list of Brock’s building codes.Code               NameAL                   Alphie’s TroughBAR-A             Barn – ABAR-B             Barn – BCAR                 Carpentry ShopCJD                  Brock Research and Innovation Centre (BRIC)CLS                  Concordia Lutheran Theological SeminaryCRN                 Cairns Family Health and Bioscience Research ComplexCUB                 Central Utilities BuildingDEC                 DeCew ResidenceDNLD              McDonald’sEA-1               East Academic – Building 1EA-2               East Academic – Building 2EA-3               East Academic – Building 3ERP                 Alan Earp ResidenceGLN-A             573 GlenridgeGLN-B             International CentreGSB                 Goodman School of BusinessGWY                Gateway ResidenceHAM               Hamilton CampusHH                   Harrison HallHPP                 Heritage Place PlazaHRTN              Tim HortonsHS                   140 LockhartIH                    Inniskillin HallKC                   Kenmore CentreLOW                Arnie Lowenberger ResidenceMCA                Mackenzie Chown – Block AMCB                Mackenzie Chown – Block BMCC                Mackenzie Chown – Block CMCD                Mackenzie Chown – Block DMCE                Mackenzie Chown – Block EMCF                Mackenzie Chown – Block FMCG                Mackenzie Chown – Block GMCH                Mackenzie Chown – Block HMCJ                 Mackenzie Chown – Block JMWS               Marilyn I. Walker School of Fine and Performing ArtsPLZ                  Plaza BuildingQV-1               Quarry View Residence – Block 1QV-2               Quarry View Residence – Block 2QV-3               Quarry View Residence – Block 3QV-4               Quarry View Residence – Block 4QV-5               Quarry View Residence – Block 5QV-6               Quarry View Residence – Block 6RFP                 Rankin Family PavilionRBC                 Rosalind Blauer Centre for Child CareRH                   Rodman Hall Art CentreSBH                 Scotiabank HallSC                    Student Alumni CentreSER                 Service TunnelsSH                   Theal HouseST                    Arthur Schmon TowerSTH                 South Block (also known as Academic South)TH                   Thistle ComplexTRL                 Trillium LaneVAL                 Gordon and Betty Vallee ResidenceVIL-A              Village Residence (Courts 1 – 6)VIL-B               Village Residence (Courts 7 – 9)VIL-C               Village Residence (Courts 10 – 12)WC-A              Walker Sports Complex – Physical Education CentreWC-B              Walker Sports Complex – Eleanor Misener Aquatic CentreWC-C              Walker Sports Complex – Storage Bldg. (at Ball Diamonds)WC-D              Walker Sports Complex – Field HouseWH                  Robert S.K. Welch Hall (including David S. Howes Theatre)Note:Main Campus: Anything above the escarpment, west of Glenridge AvenueEast Campus: Anything above the escarpment to St. David’s Road, east of Glenridge AvenueSatellite: Anything not on Main Campus or East Campus read more