TradingHub Engineer (Database Engineer Contractor)

Description: As a Database Engineer Contractor, you will design, develop, and optimize database systems to support data storage, retrieval, and analysis. Design and construct large relational databases to meet project requirements. Develop and maintain ETL processes to integrate new systems with existing data warehouse structures. Optimize database performance by refining system functionality and ensuring efficient data retrieval. Implement and enforce database security measures to protect data integrity and confidentiality.Perform regular data validation and quality checks to ensure database accuracy and reliability. Primary Skill Required for theRole: Implementation SupportAdditional Skills Requested for Role (Optional):• ETL - Intermediate (3-5 years experience)• Data quality - Intermediate (3-5 years experience)• Implementation support - Intermediate (3-5 years experience)Level Required for Primary Skill: Intermediate (3-5 years experience)Additional Details forRole:The TradingHub Trade Surveillance Engineer is a key technical expert responsible for designing, building, and maintaining the data pipelines that feed high-volume, complex capital markets data into the TradingHub trade surveillance platform.The role requires a deep understanding of ETL processes, financial market data across various asset classes, and regulatory compliance requirements. The engineer will work closely with compliance officers, quantitative analysts, and other technology teams to ensure data accuracy, completeness, and timeliness for effective market abuse detection. 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. Education• A Bachelor's degree in Computer Science, Finance, or a related field3+ years experienceMandatory Skills & ExperienceTradingHub Engineer• Trade Surveillance implementation experience using TradingHub is required• Deep ETL and data management experience (preferably financial markets)• Direct capital markets experience (equities, fixed income, FX, derivatives) is essential• Build and maintain robust data pipelines to feed the TradingHub platform• Ensure regulatory compliance and high data quality• Work cross-functionally with compliance, technology, and trading teams• Strong SQL and Python (or C#)Bachelor’s in Computer Science, Finance, or related field requiredJob Type: ContractPay: $83.00 - $88.00 per hourExpected hours: No less than 40 per weekApplication Question(s):• Are you comfortable working on W2?• Are you legally authorized to work in the United States, US Citizen/Green Card Holder? • Are you willing to work on a contract basis? • How many years of experience do you have with ETL? • How many years of experience do you have with data management? • How many years of experience do you have with Trade Surveillance implementationusing TradingHub? • How many years of Direct capital markets experience (equities, fixed income, FX, derivatives) do you have? • How many years of experience do you have with SQL?• How many years of experience do you have with Python (or C#)? • Do you have a Bachelor’s degree in Computer Science, Finance, or related field? • How many years of experience do you have with Database and Big Data? Work Location:Remote Apply tot his job