Data Analyst

Saicon Consultants, Inc.

$100K — $120K *
Finance & Insurance
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8-10 years of experience in Asset Management programs with a focus on Aladdin or similar platforms.
  • Solid knowledge of asset wealth management and trade lifecycles, particularly IBOR/ABOR concepts.
  • Capacity to write complex SQL queries and conduct reconciliations, with preferred skills in Excel and Python.
  • Familiarity with ETL tools, data warehouses, and APIs to support data integration efforts.
  • Strong analytical and problem-solving skills coupled with effective communication across business and tech teams.

Responsibilities

  • Analyze inbound/outbound data flows related to Aladdin and validate data integrity across systems.
  • Perform thorough data validation, reconciliation, and quality checks on trades and valuations.
  • Support investment lifecycle analysis and reconciliation processes between IBOR and ABOR.
  • Create detailed documentation for data mappings, dictionaries, and lineage to ensure clarity in data processes.
  • Collaborate with data engineering and integration teams to test ETL pipelines and APIs effectively.
  • Investigate and remediate data issues, ensuring seamless coordination across multiple teams for resolution.
  • Engage in agile project collaboration, participating in relevant ceremonies and working with diverse stakeholders.

Benefits

  • Opportunity to work with cutting-edge data integration technologies pertaining to Aladdin.
  • Potential for flexible working arrangements to foster work-life balance.
  • Involvement in cross-functional collaboration that enhances professional growth and learning opportunities.
Full Job Description
Key Responsibilities
  • Aladdin Data Integration Flows:
    • Analyze and support inbound/outbound data flows to/from Aladdin.
    • Understand integrations with trading platforms, custodian systems, and market data providers.
    • Assist in validating data movement across Aladdin and external applications.
  • Data Analysis & Validation:
    • Perform data validation, reconciliation, and quality checks across trades, positions, holdings, and valuations.
    • Execute SQL queries to detect data breaks and validate transformation logic.
    • Support data completeness, accuracy, and consistency checks.
  • Domain Analysis:
    • Understand investment lifecycle flows and support IBOR vs ABOR reconciliations.
    • Analyze how Aladdin interacts with accounting platforms during migrations/replacements.
    • Understand Order Management System workflows and pre-trade controls.
  • Data Mapping & Documentation:
    • Create and maintain source-to-target mappings, data dictionaries, and data lineage documentation.
    • Document integration assumptions, data issues, and resolutions.
  • Integration & Transformation Support:
    • Work closely with data engineering teams, integration teams, and business stakeholders.
    • Support testing of ETL pipelines and API/file-based integrations.
  • Issue Analysis & Production Support:
    • Investigate data breaks, interface failures, and reconciliation mismatches.
    • Coordinate with multiple teams to resolve end-to-end data issues.
  • Agile Stakeholder Collaboration:
    • Participate in agile ceremonies and work with business users, technology teams, and vendor partners.

Required Skills & Experience
  • Domain Skills:
    • Asset Wealth Management domain knowledge.
    • Strong understanding of securities, trade lifecycle, and exposure to IBOR/ABOR concepts.
  • Aladdin Integration Knowledge:
    • Understanding of Aladdin data model and workflows.
    • Experience with data migration and platform transformation.
  • Technical Skills:
    • SQL mandatory, with complex queries and reconciliation.
    • Data analysis tools like Excel and Python preferred.
    • Exposure to ETL tools, data warehouses, and APIs.
  • Data Skills:
    • Data profiling, quality assessment, and reconciliation break analysis.
    • Data governance and documentation.
  • Soft Skills:
    • Strong analytical and problem-solving skills.
    • Ability to communicate with both business and technology teams.
    • Attention to detail and ownership mindset.

Experience Range:
  • 8-10 years, can be adjusted depending on seniority.
  • Prior experience in Asset Management programs, Aladdin or similar investment account platforms like Simcorp or Portia preferred.

Nice to Have
  • Experience in large-scale Aladdin implementation or migration programs.
  • Exposure to custodian integrations and market data feeds.
  • Experience in data platform transitions, especially legacy Aladdin.

Similar Jobs

More Jobs at Saicon Consultants, Inc.

  • GW Developer
    $95K — $115K *
    Madison, WI 53711 (Dane County)
    Finance & Insurance
    In-Person
  • Data Analyst
    $100K — $120K *
    New York, NY 10025 (New York County)
    Finance & Insurance
    In-Person
  • Sql Server Metric Migration
    $95K — $115K *
    Omaha, NE 68104 (Douglas County)
    Information Technology
    In-Person
  • Warranty Analysis Engineer - HVAC
    $80K — $95K *
    Auburn Hills, MI 48326 (Oakland County)
    Manufacturing & Automotive
    In-Person
  • Firmware Engineer
    $80K — $95K *
    Austin, TX 78745 (Travis County)
    Information Technology
    In-Person

More Finance & Insurance Jobs

Find similar Data Analyst jobs: