Senior Data Analyst – Financial Systems - W2 or 1099
Jersey City, New Jersey - Ability to work onsite 3 days per week in Jersey City, NJ.
Role Overview
We are seeking a Senior Systems Technical Analyst with a deep focus on data architecture, application integration, and platform orchestration to join our Capital Partners Technology group.
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.
Key Responsibilities
· 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.
Technical & Professional Qualifications
Required
· 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.
Preferred / Bonus
· 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.
Never miss an opportunity! Create an alert based on the job you applied for.