Data Analyst
Saicon Consultants Inc.
Rosemont, United States
15 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
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.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
EM
Eli McGarvie
about 3 years ago
EM
Eli McGarvie
Data Analyst Salary Austria
about 3 years ago
CH
Chris Heilmann
Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production
almost 2 years ago
BB
Benedikt Bischof
Making Data Warehouses Fast: A Developer’s Story
about 4 years ago
EM
Eli McGarvie
Data Analyst Salary in Switzerland
about 3 years ago
EM
Eli McGarvie
Highest Paying Tech Companies for Developers
over 3 years ago