SQL Reporting Developer / Data Analyst - "Uber" for Real Estate Market

  • CVL
  • London, UK
  • Sep 09, 2016
DBA jobs

Job Description

SQL Reporting Developer / Data Analyst - "Uber" for Real Estate Market Vauxhall, London up to £45,000 + Excellent Benefits and Perks Package **Excellent career development opportunity for a talented Graduate or rising star to join the "Uber" of property services. We are changing the way properties are marketed in the UK** The Company We are an award winning and highly technical company specialising in providing services to over 2,000 UK real estate agents. We are an entrepreneurial SME in a period of rapid growth exceeding expectations. We have a clear vision and we’re on a mission to be technical innovators and to have one hell of a lot of fun on the way. You can be part of our journey. The Opportunity: We’re looking for a SQL Reporting Developer / Data Analyst to join us and work with an award-winning group of innovative thinkers, researchers and developers. We are seeking a bright, proactive and highly inquisitive new addition to our growing team to be based in our vibrant London Head Office. The successful individual must follow their own intuition and thrive in a rapidly changing environment always re-prioritising their workload against daily changing pressures. This exciting and pivotal position is within a small dedicated team who love the fast pace, dynamic nature of what we do! If you’ve read ‘The Lean Start-up, Zappos – Delivering Happiness, Good to Great or anything similar, you’ll be a perfect fit. ‘Fanatical about delivering exceptional results’. If you haven't read these we'd highly recommend it! The Role: We are looking for a MI SQL Reporting Developer / Data Analyst responsible for handling the company’s on-going reporting requirements from their Microsoft SQL Server databases. Your primary responsibilities will be to mine the required data from the company’s databases and create specific reports as required in Microsoft PowerBI and SQL Server Reporting Services (SSRS). In the case where the required data does not exist your role will include specifying to the internal development team changes to systems that will allow the required data to be gathered or cleansed. Therefore, a commitment to collaborative problem solving, and team work is essential. This role is suited to a candidate with BSc Computer Science/ MCA / MSC background who has been a Microsoft SQL Server Developer or DBA for two or more years. What we are looking for: Essential: > Comprehensive working knowledge of Microsoft SQL Server 2008/2012/2014. > Commercial database administration with recent production database administration experience > Experience of mining data > Proficiency with Microsoft SSRS Tools > Ability to analyse data to create new reports for operational use > Strong demonstrable T-SQL experience including functions, stored procedures > Knowledge of Microsoft Excel including Pivot Tables > Understanding of relational data > Ability to translate user requirements to functional reports Highly Desirable: > Excellent people skills & work well in a team > Good verbal communication with a BA mind (Exceptional problem solving abilities) > Ability to think clearly and make good decisions under pressure > Excellent analytical and report writing skills > Ability to update and amend existing databases > Ability to optimise existing queries > Experience in setting up and testing new database and data handling systems > Skills in Database monitoring, tuning and performance management > Ability to create complex query definitions that allow data to be extracted > Good excel skills > Experience in using Microsoft PowerBI > Experience setting up a data warehousing solution Unexpected but very useful ‘super’ skills: > Skills in database design and architecture > DBA experience > Experience working at database level with Microsoft Dynamics > Experience working within Jira > Experience working with remote offshore teams > Experience of sustaining the security and integrity of data > Advanced excel skills (VLook-Ups, Macros etc) > Advanced PowerBI Skills (or similar data analytics tool) > Experience setting up a reporting dashboard solution > Experience working with Integration Platform solutions such as MuleSoft > Any experience handling data within or for mobile applications The Rewards: > Base Salary: up to £45,000 per annum > Team Hangouts: with our culture being a high priority to us, we organise regular socials which range from old fashioned drinks in the pub, to medieval banquets. We are always thinking outside the box, and you can be sure never to attend a boring work social at KeyAGENT. > We feed you the best so you can be your best! Every day you can enjoy free healthy breakfasts, inclusive of a variety of fruit, bread and cereal. On Mondays we have fancy breakfasts, croissants, ham, cheese, even more fruit, juice – you name it, and Friday Beer o-clock never comes early enough! > We also have subsidised lunches, so you can have a ridiculously cheap, nutritious AND delicious lunch. > A super ‘barista style’ coffee machine combined with great freshly ground coffee beans means you can expect better-than-Starbucks lattes and a huge variety of teas to choose from for your daily pick-me-up. > Take time out with a pool table, table tennis, Xbox and a fully equipped onsite gym! > A free taste card > Discounted non-office gym membership – keep fit for less! > Discounted cinema tickets in all major cinema complexes > Free phone insurance (one less thing to worry about) > Subscription to Spotify Premium or Netflix > Support in training and development from management and colleagues with a commitment to drive excellence in personal and professional growth. > A unique lending library, with so many books that will help you out with self-development and improve your knowledge base, you won’t know where to start! > A working environment that encourages autonomy and creative approaches > Your birthday off every year! You may have worked in the following capacities: Data Insights Analyst, Data Reporting Analyst, DBA, SQL Developer, Big Data Analytics Developer, SQL Reporting Analyst, Data Miner, SQL Developer Data Modeller, Business MI Developer, BI Developer, Database Developer. Interested? Just Apply Below... In 2005 we ripped up the rule book to deliver a recruitment agency experience that makes everyone feel just that little bit happier. By applying you consent to us processing & passing your application to our client for review for this vacancy only. If your skills match the role you will hear back from us within 2 business days. Good luck, Team RR