Job Title: | Data Engineer/DBA - ETL, SQL, Azure |
Contract Type: | Permanent |
Location: | West London, London |
Industry: | |
Salary: | Negotiable |
Start Date: | A.S.A.P |
REF: | AC/014432_1606155248 |
Contact Name: | Amanda Cager |
Contact Email: | amanda.cager@projectpeople.com |
Job Published: | over 3 years ago |
Job Description
This is an exciting opportunity to work for a company with a fantastic office location and working environment who are currently undergoing a major business transformation, underpinned by significant investment in their technology.
Due to the above
What the role will be doing:
You will be responsible for creating and maintaining all data feeds that the Data Platform requires and that data sets are optimised, structured, partitioned, indexed and performant. This role will also have a high degree of ad hoc data requests to be filled for the business and troubleshooting of data issues.
- Working with the BI Developer to ensure that all data feeds are optimised and available at the required times. This can include Change Capture, Change Data Control and other "delta loading" approaches
- Performing ad hoc data requests for the business where quick turnaround time is required for insight and critical decision making. This could be using a variety of technologies and working across Azure, Salesforce and Google platforms
- Optimising and reviewing all ETL and database processes to ensure that the platform is running efficiently and cost effectively
- Assisting the wider team with data optimisation, indexing and partitioning tasks. This resource would also review other developer's SQL queries and interfaces to highlight performance issues and adherence to industry best practice
What we are looking for:
- Strong DBA and SQL coding experience
- Extensive experience developing using T-SQL, relational databases, SSIS, KingswaySoft and other ETL technologies
- Knowledge of SSRS, SSAS, Power BI, Power Query and DAX
- Working knowledge of REST APIs
- Desirable to have working knowledge of SalesForce data structures
- Experiencing using Cloud technologies and tooling for Azure and Google Cloud Platforms (GCP)
- Strong coding skills and ability to write and de-bug ad hoc queries using various tools. Python and understanding of Machine Learning is also a nice to have but an opportunity for future development
Competitive salary on offer and great benefits.
For finer details on the role please contact Amanda Cager - amanda.cager@projectpeople.com - 07796 302988.
Project People is acting as an Employment Agency in relation to this vacancy.
SIMILAR ROLES
-
Infrastructure/Data Comms Project Manager (CSCS/ECS)
Location: London
Salary: Negotiable
-
1st Line Support Engineer
Location: London
Salary: Negotiable
-
Messaging Engineer
Location: Stevenage
Salary: Negotiable
-
3RD LINE WAN ENGINEER- CONTRACT (LONG TERM)- SOLIHULL
Location: Solihull
Salary: Negotiable
-
POWER BI DEVELOPER -FULLTIME-PERMANENT -THEALE/READING
Location: Reading
Salary: £60000 - £61000 per annum
-
Gaming Product Manager_Mandarin speaking
Location: London
Salary: Negotiable