ETL Developer Lead/ Consultant

Company Description

Job Description

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 Bachelor's 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