ETL Developer Lead Consultant
Share
Job Location:
New York City, NY - USA
Monthly Salary:
Not Disclosed
Posted on:
15-10-2025
Vacancies:
1 Vacancy
Job Summary
ETL Consultant/Developer
Location: 100% Remote
Duration: 9 Months W2 Contract
Key Responsibilities
- ETL Pipeline Development: Design build and maintain robust and scalable data ingestion pipelines (ETL) to extract transform and load trading and market data into the TradingHub platform from various source systems.
- TradingHub Platform Integration: Configure and integrate the TradingHub platform ensuring seamless data flow and optimal performance of surveillance models and custom controls.
- Capital Markets Data Expertise: Apply a deep understanding of financial markets including equities fixed income FX and derivatives to ensure accurate data mapping and transformation.
- Data Quality and Governance: Implement a strategic data quality framework to validate and monitor the completeness and accuracy of trading data addressing any issues to prevent false positives in surveillance alerts.
- System Enhancement and Performance Tuning: Collaborate with technology and business stakeholders to enhance data pipelines and system performance introducing automation and advanced analytics where appropriate.
- Troubleshooting and Support: Investigate and resolve complex data-related issues perform root cause analysis and provide technical support for production systems.
- Stakeholder Collaboration: Work cross-functionally with compliance trading risk and other technology teams to continuously improve data flows and overall surveillance effectiveness.
- Documentation: Create and maintain technical documentation related to data mapping data lineage and ETL processes.
Required Skills and Qualifications:
- Experience: Proven experience in a data engineering or ETL development role preferably within a financial services or capital markets environment.
- Capital Markets Knowledge: Strong understanding of financial instruments market data concepts and capital markets trading practices.
- ETL Expertise: Hands-on experience with designing implementing and optimizing complex ETL processes for large-scale data sets.
- Programming/Scripting: Proficiency in SQL and scripting languages like Python or C# is essential.
- Database and Big Data: Experience with databases (e.g. SQL Server Oracle) and big data technologies (e.g. Spark Hadoop) is highly desirable.
- Surveillance Systems: Familiarity with trade surveillance systems and platforms like TradingHub Actimize or SMARTS is a significant advantage.
- Problem-Solving Skills: Excellent analytical and problem-solving skills to effectively troubleshoot and resolve complex data and production issues.
- Communication: Strong verbal and written communication skills to articulate technical concepts and findings to a range of stakeholders.
- Regulatory Knowledge: An understanding of financial regulations such as market abuse and other regulatory reporting requirements.
Qualifications :
A Bachelors degree in Computer Science Finance or a related field
Additional Information :
Location: Remote
Visa: GC/USC Only
Mail ID should be associated with LinkedIn
Phone number has to be service provider number not VOIP/Google Voice
Share additional phone number to reach in case of emergency
Remote Work :
Yes
Employment Type :
Contract
Key Skills
- SQL
- Pentaho
- PL/SQL
- Microsoft SQL Server
- SSIS
- Informatica
- Shell Scripting
- T Sql
- Teradata
- Data Modeling
- Data Warehouse
- Oracle
