Data Analyst / Data Engineer

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 queries, Spark job, and stored procedures. • An understanding of E-R data models (conceptual, logical, and physical). • Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions. • Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels. • Self-starter. Proven ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever changing priority list and resolve conflicts to competing priorities. • Strong problem-solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements, and priorities. If this sounds like a role you would be interested in or if you know someone in this field. Connect with me or email me at vineetha.s@smartedgesolutions.co.uk Alternatively, you can call me on Tel: +44(0)203 500 2108.