Core Data Engineer
New York·Posted today
data-platformspythongcpkafkaspark
<p><span data-usefontface="false" data-contrast="none">Flow Traders is looking for a Core Data Engineer to own the end-to-end lifecycle of our most fundamental data </span><span data-usefontface="false" data-contrast="none">products, including our Security Master; our reconciled ETF Compositions; high-resolution historical market </span><span data-usefontface="false" data-contrast="none">data; and records of our trades, orders, quotes, and inquiries. High-quality data is the cornerstone of Flow </span><span data-usefontface="false" data-contrast="none">Traders' strategic direction - beyond reducing complexity and BAU for stakeholders across the organization, </span><span data-usefontface="false" data-contrast="none">quality data is a key requirement for our growth of quantitative trading styles.</span></p> <p data-ccp-props="{"335551550":1,"335551620":1,"335559683":0,"335559685":0,"335559731":0,"335559737":0,"335562764":2,"335562765":1,"335562766":4,"335562767":0,"335562768":4,"335562769":0}"><span data-usefontface="false" data-contrast="none">Specifically, you will craft and execute the blueprint for these products, leveraging our Data Platform to build </span><span data-usefontface="false" data-contrast="none">and monitor automated pipelines which ensure that users across the organization have reliable data at their </span><span data-usefontface="false" data-contrast="none">fingertips when they need it. Further, you will become an expert in these data sets, leveraging that knowledge </span><span data-usefontface="false" data-contrast="none">to optimize our use of the data we have and explore new sources for additional value. Finally, you will </span><span data-usefontface="false" data-contrast="none">constantly collaborate with teams across the organization to ensure that our in-house systems are designed </span><span data-usefontface="false" data-contrast="none">with data in mind, streamline additional data-related workflows, and work with stakeholders to maximize the </span><span data-usefontface="false" data-contrast="none">value they extract from our data.</span></p> <p data-ccp-props="{"335551550":1,"335551620":1,"335559683":0,"335559685":0,"335559731":0,"335559737":0,"335562764":2,"335562765":1,"335562766":4,"335562767":0,"335562768":4,"335562769":0}"><span data-usefontface="false" data-contrast="none">As the architect and guardian of our most valuable data, you will have a unique opportunity to make your mark </span><span data-usefontface="false" data-contrast="none">on Flow Traders. You will be accountable for delivering these data products at an exceptional level of quality, </span><span data-usefontface="false" data-contrast="none">ensuring that they are not only timely and pristine, but powerful enough to drive Flow Traders' future growth. </span><span data-usefontface="false" data-contrast="none">Ultimately, your work will not only provide highly visible benefits that every division feels every day, but it will </span><span data-usefontface="false" data-contrast="none">also deliver one of the most important building blocks to the firm's strategic growth for the years to come.</span></p> <h4>What you will do</h4> <ul> <li><strong><span data-usefontface="false" data-contrast="none">Craft datasets with quants. </span></strong><span data-usefontface="false" data-contrast="none">Take an underspecified research question and turn it into the right </span><span data-usefontface="false" data-contrast="none">dataset: aligned, adjusted, point-in-time correct, documented, and reproducible.</span></li> <li><strong><span data-usefontface="false" data-contrast="none">Develop and own the end-to-end lifecycle of these data products. </span></strong><span data-usefontface="false" data-contrast="none">Build and maintain </span><span data-usefontface="false" data-contrast="none">pipelines, develop quality checks, correct day-to-day operational issues, and </span><span data-usefontface="false" data-contrast="none">systematize/automate manual </span><span data-usefontface="false" data-contrast="none">processing steps</span></li> <li><strong><span data-usefontface="false" data-contrast="none">Own data quality where it matters. </span></strong><span data-usefontface="false" data-contrast="none">Design the checks and alerts that catch the problems that </span><span data-usefontface="false" data-contrast="none">would actually hurt a strategy, and deliberately leave out the ones that are just noise.</span></li> <li><strong><span data-usefontface="false" data-contrast="none">Build shared foundations. </span></strong><span data-usefontface="false" data-contrast="none">Reference data, instrument identifiers, corporate actions and </span><span data-usefontface="false" data-contrast="none">vendor feeds that every researcher and trading desk depends on.</span></li> <li><strong><span data-usefontface="false" data-contrast="none">Keep critical pipelines running. </span></strong><span data-usefontface="false" data-contrast="none">Markets in several regions, and digital asset markets that </span><span data-usefontface="false" data-contrast="none">never close, depend on this data. You will be part of a team that supports it across time zones.</span></li> </ul> <h4>What you need to succeed</h4> <p data-ccp-props="{"335551550":1,"335551620":1,"335559683":0,"335559685":0,"335559731":0,"335559737":0,"335562764":2,"335562765":1,"335562766":4,"335562767":0,"335562768":4,"335562769":0}"><strong><span data-usefontface="false" data-contrast="none">Required</span></strong></p> <ul> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="1" data-aria-level="1"><span data-usefontface="false" data-contrast="none">Analytics or data engineering experience, ideally at a startup or scale-up through a growth phase</span></li> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="2" data-aria-level="1"><span data-usefontface="false" data-contrast="none">Strong data modelling and data quality practice: tests, contracts, lineage, observability in production</span></li> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="3" data-aria-level="1"><span data-usefontface="false" data-contrast="none">Strong proficiency in Python (ideally familiarity with another statically-typed language)</span></li> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="4" data-aria-level="1"><span data-usefontface="false" data-contrast="none">Working proficiency with SQL and relational databases, and version control systems</span></li> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="5" data-aria-level="1"><span data-usefontface="false" data-contrast="none">Demonstrated ability to work with large datasets and familiarity with big data solutions</span></li> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="6" data-aria-level="1"><span data-usefontface="false" data-contrast="none">You have owned something in production, not only built it</span></li> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="7" data-aria-level="1"><span data-usefontface="false" data-contrast="none">You enjoy working directly with the people who use your data</span></li> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="8" data-aria-level="1"><span data-usefontface="false" data-contrast="none">Strong interpersonal and communication skills, with the ability to collaborate effectively with technical and </span><span data-usefontface="false" data-contrast="none">non-technical stakeholders</span></li> <li data-charcodes="8226" data-font="Arial,Sans-Serif" data-buautonum="8" data-margin="450" data-aria-posinset="9" data-aria-level="1"><span data-usefontface="false" data-contrast="none">Ability to balance individual stakeholder requirements with data quality, consistency, and broad </span><span data-usefontface="false" data-contrast="none">applicability </span></li> </ul> <p data-ccp-props="{"335551550":1,"335551620":1,"335559683":0,"335559685":0,"335559731":0,"335559737":0,"335562764":2,"335562765":1,"335562766":4,"335562767":0,"335562768":4,"335562769":0}"><strong><span data-usefontface="false" data-contrast="none">Strongly preferred</span></strong></p> <ul> <li><span data-usefontface="false" data-contrast="none">Experience with financial data: prices, market data, transactions, instruments</span></li> <li><span data-usefontface="false" data-contrast="none">Familiarity with point-in-time data, look-ahead bias and survivorship bias</span></li> <li><span data-usefontface="false" data-contrast="none">Experience with a modern cloud data stack, such as Spark or Databricks, </span><span data-usefontface="false" data-contrast="none">dbt</span><span data-usefontface="false" data-contrast="none">, a cloud warehouse, and </span><span data-usefontface="false" data-contrast="none">orchestration</span></li> <li><span data-usefontface="false" data-contrast="none">Experience with Airflow, Kafka, and GCP (esp. GKE, </span><span data-usefontface="false" data-contrast="none">Dataproc</span><span data-usefontface="false" data-contrast="none">, and Big Query), strongly preferred</span></li> <li><span data-usefontface="false" data-contrast="none">Experience with Polars, Pandas, Spark, Apache Beam, Apache </span><span data-usefontface="false" data-contrast="none">NiFi</span></li> <li><span data-usefontface="false" data-contrast="none">Experience at a trading firm, systematic fund, brokerage, crypto exchange or market data company</span></li> <li><span data-usefontface="false" data-contrast="none">On-call or incident response experience</span></li> </ul> <p> </p> <p>At Flow Traders, we acknowledge the importance of open and transparent communication whether it be with our employees, our stakeholders, or our local and global communities. When it comes to salary, Flow Traders uses reliable market research to create base ranges. Where candidates will fall within the range depends on a few different factors including but not limited to level of experience, location, and specific skill set. We also consider ourselves one global team, and to demonstrate that, all employees are eligible to share in the company’s success through an annual discretionary variable remuneration allocated based on company, group and individual performance and contribution. </p> <p>Per NYC salary transparency law, the total compensation for this role includes a base range of $165,000 to $210,000 plus annual discretionary variable remuneration.</p> <p><em>Flow Traders does not accept unsolicited resumes from any professional staffing or search firms. All resumes, and any other information identifying potential candidates, submitted to any employee at Flow Traders via-email, the Internet or directly without a valid and signed search agreement will be deemed free to contact by Flow Traders without any restrictions and no placement fee of any kind will be paid in the event the candidate is hired by Flow Traders.</em></p> <h6>#LI-MM1</h6> <p> </p>