Job Specifications
Smartedge's Client is looking for an individual to help with their Data Analyst / Data Engineer @ Glasgow, UK (Hybrid Working)
Experince Required :
Data Analyst:
Data Analyst with over 5+ years of experience to join our team to help a strategic banking client in various data transformation activities.
This person will be part of the Data & AI practice.
This position is to support the Enterprise System Management (ESM) department of a global financial institution.
The position is with a team responsible for managing the FI's IT inventory and assets data.
This data is critical for regulatory, operational, and efficiency purposes.
As part of a team focused on rationalizing different legacy hardware asset and configuration management solutions into a single strategic platform, we are looking for a data analyst.
This is a dual role requiring interaction with stakeholders and technical delivery.
The candidate will work closely with a broad range of stakeholders and the rest of the project team to analyse and implement requirements into the new solution.
Responsibilities include collecting and analysing requirements, analysing data, building data pipelines to load and transform data, measuring data quality, doing code reviews, and mentoring junior team members.
Qualifications (required) Strong experience on SQL and relational databases Strong verbal and written communication
Strong data modelling experience
Strong experience with Python
Experience working with data analytics/visualization software.
Experience working in Unix environments Experience working directly with data consumers to fulfil their needs Strong networking and collaboration skills Ability to work independently
Experience navigating large/complex IT environments and infrastructure Qualifications (nice to have) Knowledge of the ServiceNow platform
Experience with Agile/DevOps Knowledge of data governance concepts
Knowledge of data centre and IT inventory equipment Experience working on IT Inventory systems Minimum Skills Required:
At least 5+ years of strong experience on SQL and relational databases
At least 5+ years of strong experience with Python Financial services experience (either as a consultant or at a FI) Experience working with data analytics/visualization software.
Experience working in Unix environments Experience working directly with data consumers to fulfil their needs Experience navigating large/complex IT environments and infrastructure
Knowledge of the ServiceNow platform Experience working on IT Inventory systems'
Data Engineer:
Design and implement tailored data solutions to meet customer needs and use cases, spanning from streaming to data lakes, analytics, and beyond within a dynamically evolving technical stack.
Provide thought leadership by recommending the most appropriate technologies and solutions for a given use case, covering the entire spectrum from the application layer to infrastructure.
Demonstrate proficiency in coding skills, utilizing languages Python & SQL, to efficiently move solutions into production while prioritizing performance, security, scalability, and robust data integrations.
Collaborate seamlessly across diverse technical stacks, including Cloudera, Databricks, Snowflake, Azure, AWS, etc.
Develop various components in Python of our unified data pipeline framework.
Contribute towards the establishment of best practices for the optimal and efficient usage of data across various on-prem and cloud platforms.
Assist with the testing and deployment of our data pipeline framework utilizing standard testing frameworks and CI/CD tooling.
Monitor the performance of queries and data loads and perform tuning as necessary.
Provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues.
Develop SQL-based data validation, reporting, analysis, etc. as required Generate comprehensive solution documentation, including sequence diagrams, class hierarchies, logical system views, etc.
Adhere to Agile practices throughout the solution development process.
Design, build, and deploy databases and data stores to support organizational requirements.
Experience supporting Software Engineering, Data Engineering, or Data Analytics projects.
Experience in data development and solutions in highly complex data environments with large data volumes.
SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis.
Experience developing data pipelines and data warehousing solutions using Python and libraries such as Pandas, NumPy, PySpark, etc.
experience developing solutions in a hybrid data environment (on-Prem and Cloud) Hands on experience with developing data pipelines for structured, semi-structured, and unstructured data and experience integrating with their supporting stores (e.g. RDBMS, NoSQL DBs, Document DBs, Log Files, etc.) Experience with performance tuning SQL qu
About the Company
Smartedge is a globally recognised Technology firm established in the year 2005.
We are headquartered in London with 15 offices globally, and offer a full range of IT Services and Professional Recruitment Services (PRS) across Europe.
Our reputation in the IT and Engineering domain coupled with an excellent consultant network across Europe, with an in-house authenticated database of 100,000+ consultants helps us to be truly SMART in our solutions.
Smartedge Brand Promise:
We are committed to transforming your organi...
Know more