> Markdown version of [/jobs/ext/3218025-systems-technical-analyst](https://www.wearedevelopers.com/jobs/ext/3218025-systems-technical-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).

---

# Systems Technical Analyst

- **Company:** Icon Clinical Research, Inc
- **Location:** Jersey City, NJ, United States
- **Experience:** Expert
- **Salary:** $124,800.0 - $135,200.0
- **Contract:** Temporary contract
- **Skills:** Airflow, Big Data, Business Process Management, Databases, Data Validation, Data Mapping, Data Structures, Data Warehousing, Database Queries, Middleware, Open Database Connectivity, Systems Development Life Cycle, Simple Object Access Protocol (SOAP), Data Streaming, Workflow Management Systems, Freeform SQL, Integration Tests, Data Lineage, Data Analytics, Drilldown, Data Management, Api Design, Databricks
- **Published:** September 24, 2026
- **Apply:** https://www.dice.com/job-detail/144e59ae-d9e1-4a46-9490-0f26c14eddd2

## About the Role

* Experience: 7+ years of experience as a Systems Technical Analyst, Data Analyst, or Integration Analyst-specifically within Financial Services, Investment Management, or Private Banking.
 * SQL Proficiency: Hands-on ability to write complex SQL queries, perform data validation across large datasets, and read/interpret PL/SQL code.
 * Data Analytics: Proven track record in large-scale data mapping, source system profiling, and merging multi-source data repositories.
 * Work Authorization: Must be a (USC) or Permanent Resident (GC).
 * Work Model: Ability to work onsite 3 days per week in Jersey City, NJ., * MDM & Data Warehousing: Experience with enterprise Master Data Management solutions (e.g., GoldenSource), Databricks, or complex data warehouse consolidation initiatives.
 * Financial Accounting Systems: Exposure to wealth management accounting platforms such as SEI / SEI Wealth Platform (SWP).
 * Orchestration & Workflow Tools: Working knowledge of Apache Airflow or similar workflow schedulers.
 * BPM Tools: Familiarity with business process execution tools and modeling notation.

Core Competencies

 * Autonomous Drive: Ability to take ownership of ambiguous requirements and work independently to deliver solution specifications.
 * Strong Communication: Excellent written and verbal communication skills with a polished, collaborative, and solution-oriented delivery.
 * Methodical Problem Solver: Exceptional listening skills and a meticulous approach to documenting system dependencies and data lineage.

## Description

In this role, you will act as a key liaison between business stakeholders, database engineers, architects, and development teams. You will drive multi-year strategic data initiatives-including Master Data Management (MDM) platform implementations, data warehouse consolidations, modern data lakehouse adoption (Databricks), and wealth accounting system integrations., * Data Mapping & Source-to-Target Analysis: Perform deep-dive analysis on complex data structures across disparate source systems to create detailed data mapping, transformation specs, and schema designs.

 * Integration Specification & Design: Analyze and document robust system-to-system data flows utilizing multiple patterns, including:

 * API-based integrations (REST/SOAP)
 * Batch and data loader file processes
 * Direct database-driven/ODBC integrations
 * Point-to-point and middleware-based interfaces

Workflow & Process Modeling: Work closely within the Business Process Management (BPM) ecosystem to model workflows, define system interaction patterns, and manage dependencies across upstream/downstream systems.

Data Quality & Validation: Perform hands-on data validation, profile large volumes of financial data, and trace data lineage across merged warehouses and operational platforms.

Orchestration Support: Support and optimize workflow orchestration schedules (e.g., Apache Airflow), managing dependency trees, monitoring execution, and establishing error-handling protocols.

SDLC & Testing Collaboration: Partner with QA and engineering teams to support integration testing (SIT/UAT), investigate root causes of lower/production environment data issues, and write comprehensive methodology documentation.