SQL Developer and Database Analyst
|Job Title:||SQL Developer and Database Analyst|
|Contact Name:||Kevin Raymond|
|Job Published:||September 13, 2018 08:31|
Your experience as an SQL Developer and Database Analyst providing data support would make you an asset to the business; an industry leader and pioneer of mobile satellite communications. You will be tasked with providing data support, manipulating and extracting data from Postgres Data Warehouse.
This is an opportunity to work for a global leader in Satellite communications.
Read on for the job details. To apply click the button at the bottom of the page.
*Extract, analyse, review and interpret data in existing databases to support projects for maximum data accuracy and reliability.
*Aggregate and correlate complex data sets from a variety of sources into easily digestible data sets.
*Flag and resolve data issues, and solve data problems by interpreting SQL stored procedures that update our databases, and by analyzing/validating the data in our databases.
*Integrate data in different formats (e.g., csv, excel, etc.) into our Postgres Datawarehouse with accuracy, efficiency and scalability.
*Work with our data clients to optimize the insights that can be extracted from the available data.
*Perform data analysis with comprehensive understanding of the technology involved in providing In-Flight Satellite Connectivity
*Exemplary work ethics, self-motivation in learning and taking on new challenges to support the challenges facing the team
*Prepare monitoring scripts for data quality
*Provide ad-hoc data analysis where needed for internal stakeholders
*Document technical processes
*Experience in high-tech data-processing
*Good understanding of SQL and ad-hoc query development in Postgres environment
*UNION, INTERSECT, EXCEPT clauses.
*Nested SQL queries.
*Windowing queries (postgres has a distinct flavor).
*INNER, LEFT, and OUTER JOINs.
*EXPLAIN and how to interpret query plans.
*Table design optimization: data types, partitioning, when/why indexes are useful, etc
*Scripting-languages such as Python or Perl
Location: London, Central London
Keywords: SQL, Python, Postgresql, Postgres, Database, Oracle, Sybase
Electus Recruitment Solutions provides specialist engineering and technical recruitment solutions to a number of high technology industries. We thank you for your interest in this vacancy. If you don't hear from us within 7 working days please presume your application has been unsuccessful on this occasion. You are of course free to resubmit your CV/details in the future and we shall assess your suitability at that time.
This role is a PERMANENT position
Electus Recruitment Ltd is acting as an Employment Agency in relation to this vacancy.
Get similar jobs like these by email
By submitting your details you agree to our T&C's
Application Support and Development Analyst
Senior Safety and Reliability Specialist
.NET Software Developer
Software Developer (Java)
Rotherham, South Yorkshire
£36800 - £40000 per annum + Bonus + pension