Sr. Data Engineer
Location: NYC, NY
Duration: 12 Months
Job Description –
Sr. Data Engineer (Bloomberg Market Data License, SQL, Python)
Required Skills:
Hands-on backend engineering experience working with Bloomberg market data within a financial institution.
Experience using Bloomberg Request and Response files used in Bloomberg Per Security Data License.
Advanced SQL expertise across multiple relational databases and warehouses including Snowflake, Sybase, SQL Server, and Oracle, particularly for complex joins, reconciliations, and historical data analysis.
Hands-on experience with ETL techniques and processes, including identifying and resolving gaps, overlaps, and inconsistencies in market data feeds.
Prior experience partnering with cross-functional Operations and Technology teams to evaluate current market data usage, rationalize overlapping datasets and workflows, and improve efficiency, performance, and cost management across the platform.
Knowledge of best practices for code quality, testing, and performance optimization.
Broad understanding of the systems and business processes supporting Middle Office and Back Office functions within investment banks or asset managers.
8+ years in Data Engineering within Financial companies with Bloomberg Market Data for some of those years
Use Snowflake native warehousing capabilities to design and build a historical Bloomberg data archive and expose it securely to downstream consumers using Snowflake RBAC.
Work on Per Security Data License request files and convert them to SQL scripts that utilize the Direct Share data directly.
Work closely with various Ops and Tech stakeholders to rationalize existing usage of Bloomberg data for various use cases to find redundancy and duplication.
Create and evolve Snowflake schemas to replace legacy Sybase structures while ensuring a smooth transition for users and dependent applications.
Use DBT (Data Build Tool) when transformations are required between raw ingestion layers and curated downstream datasets.
Use Python when scripting or automation is needed to support the platform.
Respond to end-user requests and troubleshoot issues related to data access, latency, performance, and operational support.
Need top tier folks only in Snowflake and Data Engineering – true snowflake platform admins
Need rockstars with Snowflake and below requirements and Cortex AI – must relo or be local – need to be unreal with Snowflake and true senior.