> Markdown version of [/jobs/ext/1481673-data-analyst](https://www.wearedevelopers.com/jobs/ext/1481673-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** Saicon Consultants Inc. - **Location:** Rosemont, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** 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, Data Migration, Data Profiling, Data Warehousing, Database Queries, Python (Programming Language), SQL Databases, Data Streaming, Data Lineage, Enterprise Integration - **Published:** July 29, 2026 - **Apply:** https://www.dice.com/job-detail/fd566df7-3eb2-4b84-b64b-1b000e7c1b81 ## About the Role * 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. ## 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. ## Related Videos - [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation) - [Web-based Information Visualization](https://www.wearedevelopers.com/videos/84-web-based-information-visualization) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)