Data Integration Analyst

1 month 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 Integration Analyst

    2 weeks ago

    Cape Town, Western Cape, 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...

  • Integrations Analyst

    2 weeks ago

    Cape Town, Western Cape, South Africa Dotdigital Full time

    We're hiring an Integrations Analyst!Are you ready to join our team and help take Dotdigital to the next level? Here's a sneak peek into what we're looking for:Plenty of experience working with SaaS platformsAwareness of API capabilities and data modelsExcellent communication and collaboration skillsCommercial programming or scripting experienceAs an...

  • Data Analyst

    3 months 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...

  • Data Analyst

    4 weeks ago

    Cape Town, South Africa Clockwork Media Full time

    If your numerical abilities are off the charts (see what we did there?), or you were a proud mathlete at school, we want you! But mostly your brain. Clockwork is looking for a Data Analyst to join our dynamic team. Our new Data Analyst will develop analysis and reporting capabilities for all clients across all digital touchpoints - from web and SEO to paid...

  • 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...

  • Data Analyst

    2 weeks ago

    Cape Town, Western Cape, South Africa Clockwork Media Full time

    If your numerical abilities are off the charts (see what we did there?), or you were a proud mathlete at school, we want you But mostly your brain. Clockwork is looking for a Data Analyst to join our dynamic team.Our new Data Analyst will develop analysis and reporting capabilities for all clients across all digital touchpoints - from web and SEO to paid...

  • Data Analyst

    1 week ago

    Cape Town, Western Cape, South Africa ExclusivelyRemote Full time

    Data Analyst (Excel and Power BI)Position: Data AnalystHours: 15-25 hours per week (US hours, flexible)Employment Type: Project-based, ongoingWe are seeking a skilled Data Analyst with strong expertise in Excel and Power BI. This role is ideal for someone looking to work part-time, with flexibility around US hours.Key Responsibilities:Analyze complex data...

  • Data Analyst

    2 weeks ago

    Cape Town, South Africa Exclusively Remote Full time

    **Data Analyst (Part Time)** We are seeking a talented and detail-oriented Data Analyst with expertise in Excel and Power BI to join our dynamic team. As a Data Analyst, you will play a pivotal role in extracting, analyzing, and visualizing data to provide actionable insights that drive informed decision-making across our organization. **Key...

  • Data Analyst

    3 weeks ago

    Cape Town, 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. We are looking for an individual with experience in using a variety of data tools, analysis methods and data visualization to...

  • 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

    3 weeks 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...

  • Junior Data Analyst

    4 weeks ago

    Cape Town, South Africa Nimble Group Full time

    **Reporting to**: Operational Analyst **Job Purpose**: Processing and validating data to be loaded into internal systems. **Location**: Woodstock, Cape Town **KEY PERFORMANCE AREAS**: Under the management / direction of the Operational Analyst, the Junior Data Analyst will have the following responsibilities (including but not limited to): - Analyse new...

  • Data Analyst

    2 weeks ago

    Cape Town, Western Cape, South Africa Fetola Full time

    Data Analyst (consultant/service provider):Type of contract: service provider to consult on an ad-hoc basis.Rate:hourly rate will be discussedClosing date:07 July 2023- "Our purpose is simple: we help people to grow the economy and create jobs by building businesses that last"._We pride ourselves on innovation, efficiency, and data-driven decision-making. As...

  • Systems Analyst

    2 weeks ago

    Cape Town, Western Cape, 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

    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...

  • Risk Data Analyst

    2 weeks ago

    Cape Town, Western Cape, South Africa Shoprite Full time

    Purpose of the Job The Risk Data Analyst I is an entry-level position within the Enterprise Risk Management (ERM) department. This role involves supporting the collection, analysis, and reporting of risk-related data. The analyst will assist in maintaining data accuracy and integrity, performing routine data processing tasks, and supporting senior...

  • Risk Data Analyst

    3 weeks ago

    Cape Town, South Africa Shoprite Full time

    Purpose of the Job The Risk Data Analyst I is an entry-level position within the Enterprise Risk Management (ERM) department. This role involves supporting the collection, analysis, and reporting of risk-related data. The analyst will assist in maintaining data accuracy and integrity, performing routine data processing tasks, and supporting senior...

  • Media Data Analyst

    1 week ago

    Cape Town, South Africa Dentsu Aegis Network Full time

    Our new Media Data Analyst will develop analysis and reporting capabilities for all clients across all digital media touchpoints. The Media Data Analyst will also be responsible for managing, cleaning, and sourcing data; building and maintaining data dashboards; and monitoring campaign performance. dentsu is looking for a person with an analytical mindset...

  • Global Data Analyst

    5 days ago

    Cape Town, South Africa Dentons Full time

    The Global Business Technology (GBT) department is essential to meet the Firm's strategic vision. We help to align technology services with the Firm's objectives. This alignment is essential for providing excellent service and value to the firm and its stakeholders. The Firmwide technology function mirrors the firm's Verein structure, balancing the delivery...

  • Integration Data Specialist

    3 weeks ago

    Cape Town, South Africa Crisis24 Full time

    About Crisis24 Crisis24, a GardaWorld company, is widely regarded as the leading integrated risk management, crisis response, consulting, and global protective solutions firm, serving the world's most influential people, disruptive brands, and prominent organizations. Championed by our advanced Global Operation Centers and our skilled team of intelligence...