Data Analyst

Saicon Consultants Inc.
Rosemont, United States
15 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Application Programming Interfaces (APIs) Agile Methodology Data Analysis Data Validation Data Dictionary Information Engineering Data Governance Data Infrastructure Data Integration Extract Transform Load (ETL) Data Mapping
+9 more
Data Migration Data Profiling Data Warehousing Database Queries Python (Programming Language) SQL Databases Data Streaming Data Lineage Enterprise Integration

Job description

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

Requirements

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:39 min

Harnessing data mapping tools to identify unmapped opportunities

Laura Möller Laura Möller +3 · World Congress 2024

9:51 min

Live demonstration of dynamic data redaction plugins

Tom Kaltofen Tom Kaltofen +1 · Europe 2026 Virtual

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · World Congress 2024

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

3:57 min

Mapping abstract data attributes into geometric visual configurations

Johanna Schmidt · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

Videos

See all

Related articles

See all