Average Data Specialist salary in City of London

Data Warehouse Specialist - 6 month Contract (possibility of extension) cer Financial are looking for an experienced Data Warehouse Specialist for an established financial institution. The right person will have technical hands-on experience with IBM Datastage (architecture, collaborate with designer, knowledge of jobs and stages) and ETL (development, data transformation and cleansing, data integration, problem solving and debugging. Summary of duties and responsibilities: Translate requirements and data mapping documents to a technical ETL designCreate and review high level design of solutionPerform technical walkthroughs of amended DataStage ETL solutions for peer reviewsDevelop, enhance and maintain ETL code following JRIA best practices and standardsCreate and execute unit testing plans. Support Regression and System test effortsDebug and problem solve issues found during testing and/or productionEnsure all deliverables meets internal standards, industry best practice within the agreed timeframeEnsure clear and transparent communication to all key stakeholdersResponsible for the project deliverables related to assigned initiativesResponsible for the IT related risks, issues and ensure appropriate escalation to appropriate management The right person will also have experience in project life cycles and database and SQL exposure.

Data Content Specialist (Python SQL) London to £180k Are you a tech savvy Data Engineer with Data Content experience and a strong knowledge of data management principles and best practices? You could be progressing your career working on complex and challenging systems at a Hedge Fund with over $17 billion under management. As a Data Content Specialist you will join a small team responsible for understanding, managing and transforming raw data content from various 3rd parties for the trading team, investment quants and investment desk. Typical responsibilities will include combining and transforming raw data into useful insights, analysis and visualisations, interrogating various vendor data endpoints to source and analyse data, ensuring data consistency, completeness and accuracy across all platforms. You'll develop data dictionaries and other documentation and collaborate with technology teams to implement and enhance data systems and processes, keeping up to date with industry trends and emerging technology in data content and tooling. Location / WFH: You'll join the team in fantastic London (Soho) based offices that offer a wide range of facilities including nutritionally balance breakfast, lunch and all day snacks. Please note this role is full-time office based (Monday to Friday). About you: You have an outstanding record of academic achievement - minimum 2.1 in a STEM discipline from a top tier university (i.e. Russel Group or top 100 global university), backed by A grades at A-levelYou have strong technical skills with Python and SQL, experience with version control and contributing to a shared codebaseYou have a strong knowledge of data management principles and best practicesYou have experience with data analysis, visualisation tools and techniquesYou're able to convey complex data and technical information to front office tradersYou have a strong understanding of financial markets and investment management What's in it for you: As a Data Content Specialist (Python SQL) you will earn a competitive package: Salary to £180kSignificant bonus earning potentialFund performance sharePersonal training budget and mentoringFamily friendly benefits that include unlimited emergency backup childcare as well as care for elderly relativesVarious social groups including sports teamsPrivate healthcare and wellness activities Apply now to find out more about this Data Content Specialist (Python SQL) opportunity. At Client Server we believe in a diverse workplace that allows people to play to their strengths and continually learn. We're an equal opportunities employer whose people come from all walks of life and will never discriminate based on race, colour, religion, sex, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. The clients we work with share our values.

DataStage Data Warehousing Specialist Duration: Up until 31 March 2025 (Possibility for extension) Location: London/Hybrid (2 - 3 days per week on site) £280 PD VIA UMBRELLA, Inside IR35 Role Profile Our client, a leading investment banking organisation, is seeking a Data Warehousing Specialist to join their team. As a Data Warehousing Specialist, you will be responsible for translating requirements and data mapping documents into technical ETL designs, creating and reviewing high-level solution designs, and developing, enhancing, and maintaining ETL code following best practises and standards. Purpose of Job: Translate requirements and data mapping documents to a technical ETL design. Create and review high-level design of solution. Perform technical walkthroughs of amended DataStageETL solutions for peer reviews. Develop, enhance, and maintain ETL code following best practises and standards. Create and execute unit testing plans. Support Regression and System test efforts. Debug and problem solve issues found during testing and/or production. Promote DataStageETL code using Perforce and Urban Code deployment tools. Evaluate data for completeness and correctness, validate that ETL code is working as expected. Communicate status, issues, blockers to project manager and ETL team lead. Support continuous improvement of ETL interfaces by identifying and solving opportunities. Update and publish documentation, system diagrams, presentations, workflows, project plans, log issues, and unit testing logs. Attend project and ETL meetings. Perform knowledge transfer sessions to ETL Production support and Development team. Assist Production support team on the resolution of production incidents related to ETL processes when required. Accountabilities: Ensure all deliverables meet internal standards, industry best practise within the agreed timeframe. Ensure clear and transparent communication to all key stakeholders. Be responsible for the project deliverables related to assigned initiatives. Be responsible for IT-related risks, issues, and ensure appropriate escalation to appropriate management. Support strategic discussions and propose appropriate recommendations to IT management. Be responsible for troubleshooting, root cause analysis, data analysis related to BAU support requests. Ensure appropriate tracking and escalation of IT-related risks and issues observed. Skills and Experience: IBM DataStage: Understanding of DataStage architecture and components. Familiarity with DataStage Designer, Director, and Administrator. Knowledge of DataStage jobs, stages, and data connections. Experience with parallel job design and development. Database Systems: Relational databases (e.g., IBM Db2, Oracle, SQL Server). SQL and PL/SQL programming. ETL development: Designing, developing, and deploying DataStage jobs. Creating complex ETL processes using DataStage and connectors. Performance tuning of DataStage jobs. Data Transformation and Cleansing: Applying data transformation rules. Implementing data quality and data cleansing routines. Data Integration: Integrating data from various sources (e.g., databases, flat files, XML). Handling structured and unstructured data. Problem Solving and Debugging: Identifying and resolving ETL job failures. Troubleshooting performance issues. Hands-on Experience with IBM DataStage: Several years of experience developing ETL solutions using IBM DataStage. Experience with different DataStage versions. Project Experience: Involvement in full project life cycles, from requirements gathering to deployment and maintenance. Working in Agile or Waterfall project environments. Database and SQL Experience: Writing complex SQL queries and stored procedures. Working with large datasets and optimising queries for performance. Due to high demand we are only able to respond to applications that meet the required criteria