Data Engineer & Analyst Job at Progressive Edge … See details on how to apply for the opportunities available at Progressive Edge.
Vacancy Details
A smaller business of around 50 people, in a much larger listed financial group, offers the best of both worlds for its employees, offering a small, personal & intimate team to work in, within a large corporate.
The company offers bespoke funding solutions to institutions seeking term debt funding and actively participates in larger, complex debt transactions.
They offer Trading, Treasury, & Asset Liability management; Asset origination, and Risk & Capital management.
The Role
This leading financial services company is seeking a self-driven individual with a background in data infrastructure development and data analysis for the role of Data Engineer/ Analyst. You will serve as a key connection point between quantitative development and business operational teams, helping to align strategies with data insights.
Your primary duties will include designing data models, gathering and extracting information, writing code, maintaining data documentation, communicating results, and collaborating with data team members. As part of your role, you will build data pipelines and perform ETL (Extract, Transform, Load) processes, extracting data from various sources, transforming it, and loading it into a centralized repository like a data warehouse.
You will maintain and manage various internal databases such as SQL, MongoDB, Document DB, among others, design new data structures, and assist in implementing new data lake/warehouse systems. Furthermore, you will oversee daily data flows, carry out data validations, and ensure timely data delivery to consumers. You will also be tasked with building reports and dashboards on top of preprocessed data and drawing out insights from it, using business intelligence tools like Power BI, Tableau and Jupyter Notebook.
A strong understanding of cloud-based data storage mechanisms like Azure and AWS is essential, and the ability to guide and inform our team about these technologies will be a significant part of your role.
Key Result Areas:
- Designing data models, extracting and transforming information, and maintaining data documentation.
- Building data pipelines and performing ETL operations.
- Building reports and dashboards and drawing insights from preprocessed data using business intelligence tools like Power Bi, Tableau and Jupyter Notebook.
- Communicating results and collaborating with data team members to bridge the gap between data and business operations.
- Maintaining and managing various internal databases (SQL, MongoDB, DocumentDB, etc.)
- Designing and implementing new data structures and data lake/warehouse systems.
- Building, managing, and overseeing daily data flows, validations, and deliveries to data consumers.
- Leveraging cloud-based data storage mechanisms, specifically Azure and AWS, to optimize data handling processes.
- Implementing data validation protocols.
Performance Metrics will be evaluated based on:
- Successfully develop and implementation of data projects.
- Efficiency in Business-As-Usual (BAU) operational oversight.
- Ability to provide high-quality service to clients.
- Candidates should be aware that ongoing learning and staying up to date with developments in relevant technology will be crucial for this role. We are looking for a candidate who is not only equipped with the necessary knowledge and skills but can also guide us in areas where internal knowledge is lacking.
Candidate Requirements
Qualifications and Experience Required:
- A minimum of 5 years of experience in a relevant field.
- Proficiency in SQL, MongoDB, DocumentDB, and similar databases.
- Proficiency in C#, Python, SQL, Power Query, and Power BI.
- Prior experience in data validation and data analysis is advantageous.
- Experience with cloud-based data storage mechanisms like Azure and AWS.
- Familiarity with financial transactional data is preferred but not necessary.
- High attention to details will be a necessity for the role.
Competencies:
- Exceptional problem-solving skills and attention to detail.
- Ability to work independently and as a part of a team
- Excellent communication skills, with the ability to convey complex information to a variety of audiences.
To Apply
Application Deadline: November 06 2023