Junior Data Engineer (SQL, SSIS, QlikView, Power BI) (CPT Remote) at Datafin IT Recruitment – Cape Town | Jobyssey

ENVIRONMENT:

A leading FinTech company urgently seeks a solutions-driven Junior Data Engineer who will be involved in the design and build of data management solutions. There will also be elements of integrating with Data Science tools allowing business users to visualise their data. You will also participate in manipulation, modelling and being responsible for the understanding of inter-dependencies between various data sources and business processes involving data flow. The ideal candidate must preferably have a BSc. Degree in Computer Science, B.IT or Informatics related Degrees with experience in Data analysis, modelling and surfacing; Data Cleaning / Integrity Checking; creating reports using Excel or equivalent & proficient with SQL, SSIS, QlikView, Power BI & Tableau.

DUTIES:

· The configuration and implementation at various clients.

· Understand the business requirements of clients, the focus being the research and investment process of these Asset Managers.

· Construct end to end data service solutions.

· Liaise and interface with clients in a support role, providing 2nd Tier support and enhancement services.

· Understand and manage the client’s data requirements, the data being specific to the financial markets.

· Contribute towards a team that develops, constructs, tests and maintains architectures (such as databases and large-scale processing systems).

· Ensure data architecture will support the requirements of the client’s business.

· Employ a variety of languages and tools (e.g. scripting languages) to marry systems together.

· Recommend ways to improve data reliability, efficiency and quality.

· Employ sophisticated analytics and statistical methods to prepare data for use in prescriptive modelling.

· Automate work by using process flow tools.

· Provide feedback to the Development team regarding new functionality and issue logging.

· Creation of user interfaces allowing users to upload their own data.

REQUIREMENTS:

Preferred Qualifications & Experience -

· Tertiary Degree in BSc Computer Science, B.IT or Informatics related degrees, Mathematics, Applied Mathematics, Actuarial Science or an Engineering degree.

· Understanding and working experience in data integration and transformation.

Experience/Skills –

· Data analysis, modelling and surfacing.

· Data Cleaning / Integrity Checking.

· Experience of creating reports using Excel or equivalent.

· SQL, SSIS, database scripting (stored procedures, user defined functions, queries, triggers).

· Iterative testing including debugging and refactoring.

· Constructing data queries by combining multiple data sources.

· Present information using data visualization techniques (such as QlikView, Power BI and Tableau).

Advantageous –

· Asset Management and Financial Services (Distinct advantage).

· Experience of consuming APIs.

· Some experience in a Programming language.

· Any sort of ETL or Data Warehousing knowledge.

· Statistical languages (such as R and MATLAB).

ATTRIBUTES:

· A passion to learn and extend knowledge outside of the work sphere.

· Good at problem solving (core to the role).

· The ability to self-manage and self-motivate.

· Can communicate clearly with clients and the team.

· A team player.

· Adaptable.

· Able to efficiently and effectively plan and structure tasks.

· Execute assignments against deadlines.

· Thrive in an Agile environment.

Explore more jobs