Data Engineer in Heredia at TradeStation

Date Posted: 5/10/2021

Job Snapshot

Job Description

Data Engineer
Heredia, Costa Rica
TradeStation is an online brokerage firm seeking to level the playing field for self-directed investors and traders, empowering them to claim their individual financial edge.  At TradeStation, we're continuously pushing the boundaries of what's possible, encouraging out-of-the-box thinking and relentless search for innovation.  We offer a collaborative and flexible work environment, competitive salaries, comprehensive benefits and a generous PTO policy.
The Enterprise Analytics team helps TradeStation extract valuable business insights from terabytes of raw data scattered across dozens of silos.
Our Data Engineers:
  • Ensure that our data is fresh, accurate, and presented in a way that is meaningful to the business.
  • Create data pipelines using DevOps practices to ensure their code is always tested, performant and delivered.
  • Are lifelong learners and self-starters who are constantly on the lookout for new ways to solve old problems.
  • Find creative solutions to improve our efficiency, in speed and cost, when working with big data and help us develop them one Agile sprint at a time.
  • Are instrumental in our process to migrate away from legacy data pipelines to our new lake-house architecture.
ESSENTIAL JOB FUNCTIONS:
  • Help us build a modern lake data-warehouse.
  • Migrate old SSIS/SSRS based ETL jobs to our new Databricks/ADF based ELT architecture
  • Write python and SQL solutions for data transformation, applying test driven development principles and automated data quality controls
  • Process unstructured data from SQL DBs or JSON, Parquet, CSV files, or Rest APIs
KNOWLEDGE, SKILLS & CORE TECHNOLOGIES:  
  • Bachelor’s Degree in Computer Science or related field
  • 2+ years of experience in data processing with of these technologies:
    • Python, Pandas, Py-Spark, ML Flow, Delta Lake
    • Amazon Web Services and/or Azure clouds
    • SSIS, SSRS, Data-Factory
    • ANSI SQL applied to warehousing on Databricks, Synapse and/or RedShift
    • Git, Azure DevOps/Jenkins/Gitlab, Kubernetes
  • Excellent communication skills with English at B2+ level