Data Integration Analyst

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

    8 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

    2 weeks ago

    Cape Town, South Africa Frogg Recruitment SA Full time

    Data Analyst Cape Town WaterfrontOur Fintech client in the Cape Town Waterfront is looking for a Data Analyst with 3-5 years’ experience. You will work with the software engineering team and will be responsible for conducting full lifecycle analysis to include requirements, activities and design.Salary negotiable – Hybrid roleMin RequirementsA Bachelor's...

  • Data Analyst

    4 months ago

    Cape Town, South Africa HR Genie Full time

    Our Client is Looking for a Data Analyst to join their team.Responsibilities:Use data analyst tools to extract data from various data sources.Identify and remove corrupt or incorrect data.Perform quality analysis on data to ensure accuracy and integrity.Manage and maintain databases effectively.Utilize data analysis and statistical tools to analyze data and...

  • Senior Business Intelligence Data Analyst

    4 weeks ago

    Cape Town, Western Cape, South Africa Dimension Data Full time

    About the RoleWe are seeking a highly skilled Senior Business Intelligence Data Analyst to join our team at Dimension Data. As a key member of our data analytics team, you will play a critical role in developing and maintaining daily, weekly, and monthly MIS reports as well as data flows.

  • Global Data Analyst

    1 month ago

    Cape Town, Western Cape, South Africa Dentons Full time

    Job Title: Global Data AnalystJob Description:The role of the Global Data Analyst is a crucial one within the Global Digital Data Services group at Dentons. The successful candidate will play a pivotal role in leading the integration of data across all global business systems. With Dentons' data being complex and requiring a deep understanding of sources and...

  • Data Analyst

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

  • Data Analyst

    2 months ago

    Cape Town, South Africa FROGG Recruitment Full time

    Data Analyst Cape Town Waterfront Our Fintech client in the Cape Town Waterfront is looking for a Data Analyst with 3-5 years’ experience. You will work with the software engineering team and will be responsible for conducting full lifecycle analysis to include requirements, activities and design.Salary negotiable – Hybrid role Min Requirements A...

  • Data Analyst

    1 month ago

    Cape Town, South Africa Frogg Recruitment SA Full time

    Data Analyst Cape Town Waterfront Our Fintech client in the Cape Town Waterfront is looking for a Data Analyst with 3-5 years’ experience. You will work with the software engineering team and will be responsible for conducting full lifecycle analysis to include requirements, activities and design.Salary negotiable – Hybrid role Min Requirements A...

  • Data Analyst

    2 months ago

    Cape Town, South Africa Frogg Recruitment SA Full time

    Data Analyst Cape Town Waterfront Our Fintech client in the Cape Town Waterfront is looking for a Data Analyst with 3-5 years’ experience. You will work with the software engineering team and will be responsible for conducting full lifecycle analysis to include requirements, activities and design. Salary negotiable – Hybrid role Min Requirements ...

  • Data Analyst

    2 months ago

    Cape Town City Centre, South Africa Jobted ZA C2 Full time

    Data Analyst Cape Town Waterfront Our Fintech client in the Cape Town Waterfront is looking for a Data Analyst with 3-5 years’ experience. You will work with the software engineering team and will be responsible for conducting full lifecycle analysis to include requirements, activities and design. Salary negotiable – Hybrid role Min Requirements A...

  • Data Analyst

    6 months 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

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

  • Data Analyst

    3 months ago

    Cape Town, South Africa SHEQ Full time

    Establish PPE Company who is a forward-thinking company committed to leveraging data-driven insights to enhance our operations and decision-making. We are currently seeking a highly skilled Data Analyst with expert Excel skills to join our dynamic team. If you have a passion for numbers, enjoy solving complex problems, and are an Excel wizard, we want to...

  • Junior Data Analyst

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

  • Mobile Test Analyst

    6 months 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 months ago

    Cape Town, South Africa Network Recruitment Full time

    A well-known insurer is seeking a dynamic Data Analyst with strong business analysis skills to join their team This company has over 30 years of experience and wants to add more value to their amazing analytics team In this role you will be required to not only analyse data but bridge the gap between insights and strategic business decisions, ensuring that...

  • Global Data Analyst

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

  • Media Data Analyst

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

  • Integration Data Specialist

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

  • System Analyst

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