Data Integration Analyst

2 weeks ago

Cape Town, South Africa Recruiter Ruth | Performability Recruitment Full time

Are you a whiz at investigating and correcting integration issues relating to data recons?
You have experience with d ata integrity testing and fixes that include, but is not limited, to income, fee checks and tax checks.
Managing wrap funds to ensure the models are correct is just part of a days work for you.
- One part system support. Dev support. One part investment finance.
A leading hedge fund management firm is in need for a junior/ intermediate Data Integrity Analyst to join their thriving team.

Purpose of the role
Support the PAS Operations team with data integrity checking on instructions and assisting with operational projects
Minimum skills and knowledge required
SQL knowledge
Min 3 years experience in investment and planning environment and LISP experience
Min 3 years data integrity experience
Knowledge of financial services industry and products
Relevant post matric qualification
Responsibilities | Skills
KPA/ STRATEGIC BUSINESS DELIVERABLES
Investigate and correct integration issues relating to data recons and data reconciliations
Identify discrepancies or inconsistencies in data reconciliations.
Analyze the integration processes and data flows to determine the root causes of the issues.
Collaborate with relevant teams or stakeholders to rectify the integration problems.
Implement corrective measures to ensure accurate and reliable data reconciliations.
Data integrity testing and fixes, including, but not limited, to income, fee checks and tax checks.
Perform tests and checks to verify the accuracy and integrity of the data.
Focus on specific areas such as income calculations, fee calculations and tax related data.
Execute test cases and checks based on the defined plan.
Compare data across different sources to ensure consistency
Identify any anomalies or errors in the data and work towards resolving them.
Ensure all data integrity checks are completed accurately and timeously.
Establish a systematic process to conduct data integrity checks.
Ensure that the checks cover all relevant aspects of the data.
Adhere to a defined timeline to complete the checks in a timely manner.
Document the results of the checks and address any identified issues promptly.
Assist with system testing when required.
Collaborate with the testing team to develop test scenarios and plans.
Execute test cases to verify the functionality and performance of the system.
Report any defects or issues encountered during testing.
Work with the team to resolve identified problems and retest as necessary.
Manage Wrap funds make sure models are correct and investigate any issues
Verify the accuracy of the investment models used for the funds.
Collaborate with investment managers or analysts to ensure the correct models are applied.
Allocate and clear bulk contract residual balance.
Handle the allocation and clearance of residual balances related to bulk contracts or transactions.
Analyze the contract terms and financial records to determine the appropriate allocation of residual amounts
Coordinate with relevant parties, such as clients or counterparties, to resolve any outstanding residual balances.
Ensure static data related to tax reporting is accurate.
Maintain and update static data related to tax reporting requirements.
Review the accuracy of client or account information relevant to tax reporting.
Implement processes to periodically validate and reconcile tax-related static data.
Assist with adhoc operational projects.
Support the execution of various operational projects or initiatives.
Collaborate with cross-functional teams to achieve project goals.
Perform assigned tasks or responsibilities as part of the project team.
Provide insights or recommendations based on your expertise and observations
Technology exposure
Microsoft packages
Fusion/Maxim (internal software)
Advanced Excel skills
SQL
Competitive, market related salary starting at R25k per month
- experience depending.

  • Data Analyst

    1 month ago

    Cape Town, South Africa PBT Group Full time

    Key Responsibilities: - Analyse large data sets to identify trends and patterns - Develop and maintain data reporting and dashboard tools - Ensure data accuracy and integrity through regular audits and quality control processes - Work closely with stakeholders to understand their data requirements and develop solutions to meet their needs - Collaborate with...

  • Mobile Test Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Mobile Test Analyst, you'll help the development team ensure that our applications are functioning correctly on all devices and operating systems. You'll test apps on multiple mobile platforms including iPhone/iPad, Android and BlackBerry. You will also be required to follow up with developers for specific issues that may arise in their work flow or...

  • System Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a System Analyst, you'll be responsible for maintaining and managing the company's IT infrastructure. You will be responsible for identifying issues and recommending solutions to maintain the network, database systems, servers and workstations in good working order. You will also have to manage the installation of new hardware as well as software...

  • Data Analyst

    1 month ago

    Cape Town, South Africa Paracon Full time

    We are on a search for a Data Analyst to be part of a diversified financial services group that operates across the African continent. Additionally, the Data Analyst will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights. Our client...

  • Systems Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    The Systems Analyst will be responsible for implementing and maintaining a number of technology systems including but not limited to: - Azure, AWS (AWS Database, Redshift, ElasticSearch) - Oracle Databases and SQL databases - SAP applications in Finance/HR/CRM and Marketing. You'll also be responsible for data migration from various legacy systems into...

  • Systems Analyst

    4 weeks ago

    Cape Town, South Africa Cape Union Mart Full time

    The Systems Analyst for Integration will be responsible for requirements analysis, solution mapping, configuration, development, testing, and documentation of the same, to address interface requirements for internal and external systems. The Systems Analyst will provide effective maintenance and support for interfaces. The Systems Analyst will also be...

  • Data Analyst

    2 weeks ago

    Cape Town, South Africa GG Financial Recruitment Full time

    Fantastic position for a mid-level analyst aspiring to leadership. My client is a leading & stable medium sized FMCG company who requires a Data Analyst / Customer Insights Analyst to provide data/dashboards and reports on both existing as well as forecasted customer behaviour. The ideal candidate should be committed to gaining and learning more about...

  • Data Analyst

    2 weeks ago

    Cape Town, South Africa GG Financial Recruitment Full time

    Fantastic position for a mid-level analyst aspiring to leadership. My client is a leading & stable medium sized FMCG company who requires a Data Analyst / Customer Insights Analyst to provide data/dashboards and reports on both existing as well as forecasted customer behaviour. The ideal candidate should be committed to gaining and learning more about...

  • Data Analyst

    1 month ago

    Cape Town, South Africa RPO Recruitment Full time

    Data analyst responsibilities include conducting full lifecycle analysis to include requirements, activities and design. Data analysts will develop analysis and reporting capabilities. They will also monitor performance and quality control plans to identify improvements. **Responsibilities**: - Develop and implement databases, data collection systems, data...

  • Data Analyst

    4 weeks ago

    Cape Town, South Africa Affirmative Portfolios Full time

    **Data optimization analyst - Cape Town**: **Admin and Office Management ~ Project Management** **Cape Town - Western Cape** ***: **Data Analyst (Contract) - Cape Town** **The TES employee(s) will be responsible for the following function / work** **As the Ease of Doing Business: Data optimization analyst, the individual will be responsible...

  • Senior Business Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Senior Business Analyst, you'll be responsible for analyzing and testing new software applications. You'll be tasked with ensuring that the application is working as intended before it goes live to customers. You will work closely with other development teams and the business analysts in order to ensure that all aspects of our product are functioning...

  • Data Analyst

    1 month ago

    Stellenbosch, Western Cape, South Africa PBT Group Full time

    PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex. We are looking for an individual with experience in using a...

  • Financial Data Analyst

    4 weeks ago

    Cape Town, South Africa TalentintheCloud PTY Limited (trading as titc.io) Full time

    A dynamic, fast-moving, and rapidly growing fintech lending company is seeking a Financial Data Analyst, which is committed to delivering innovative financial solutions to its clients is currently looking for a Data Analyst, this role is to assist in building and delivering a range of data-driven models across the entire credit life cycle.**Position...

  • Automation Test Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As an Automation Test Analyst, you will be responsible for the implementation of software testing strategies to help increase quality and productivity. You will also provide test automation support for new or existing applications in a range of environments including Web, Desktop and Mobile. Requirements Evaluates the quality of test automation...

  • Business Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Business Analyst, you will be working on a project that involves business process analysis and requirements gathering. You'll use the relevant software tools to gather information for your team to work from. You may also be required to help test new functionality or build prototypes of new features using web applications. Requirements ...

  • Financial Data Analyst

    1 week ago

    Cape Town, South Africa Adzuna ZA B C2 Full time

    Financial Data Analyst (Financial Report Writer) Our U.S. client is hiring to build out their reporting team! As their business is growing, sharing financial information with key stakeholders is a key factor to facilitating the business’s growth. As a dedicated member of their reporting team, you’ll play a key role in fostering that success. They are...

  • SQL Data Analyst

    6 days ago

    Cape Town, South Africa Adzuna ZA B C2 Full time

    SQL Data Analyst Our U.S. client is hiring to build out their reporting team! As their business is growing, sharing financial information with key stakeholders is a key factor to facilitating the business’s growth. As a dedicated member of their reporting team, you’ll play a key role in fostering that success. They are looking for a highly motivated...

  • Data Analyst

    4 weeks ago

    Cape Town, South Africa Datonomy Solutions Full time

    Guided by Lead Analyst(s), this role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights. We are looking for an individual with experience in using a variety of data tools, analysis methods and data visualization to turn data into...

  • Data Analyst

    1 month ago

    Cape Town, South Africa Olive Branch Recruitment Full time

    Looking for a Data Analyst to join a growing Tech organization. This position is Hybrid and based in Cape Town. Should you meet the requirements and are passionate about making a difference in the lives of others, please be sure to apply. **Requirements**: Tech/B.Sc. Engineering, Maths; Stats; Actuarial Science 1 to 3 years of work experience Must have...

  • Data Analyst Cape Towndata Optimization Analyst

    4 weeks ago

    Cape Town, South Africa Affirmative Portfolios Full time

    Data Analyst - Cape Town Data optimization analyst - Cape Town Admin and Office Management ~ Project Management Cape Town - Western Cape Data Analyst (Contract) - Cape Town The TES employee(s) will be responsible for the following function / work As the Ease of Doing Business: Data optimization analyst, the individual will be responsible...