Description

You will lead the design of data pipelines and automated ETL processes to evolve ledger reconciliation and reporting systems.

Responsibilities

• Design data pipelines and automate ETL processes and SQL optimization to improve ledger reconciliation and reporting.
• Mentor engineers while contributing as an individual contributor.
• Partner with third-party vendors, Data Analytics, and Crypto Core engineers for data processing.
• Maintain and create data adaptors for real-time data processing, validation, and root cause analysis for exception reports.
• Improve data warehouse structures as required to support next-generation reconciliation.

Required Skills

• 7+ years of experience with schema design and dimensional data modeling.
• 7+ years designing and implementing reconciliation systems and improving data pipelines.
• Hands-on experience with cryptocurrency data.
• Experience in trade or ledger reconciliation.
• Advanced SQL skills and database design experience.
• Experience building real-time data solutions and automating reconciliation analysis.
• Proficiency in Python and/or Java.
• Experience with FIX, Kafka, REST, and other data messaging types.
• Experience with Airflow, Databricks, Spark, or Hadoop.
• Experience with MPP databases such as Redshift, BigQuery, or Snowflake.
• Extensive ETL and database experience with financial transaction systems (banking or exchange systems).
• Experience in financial reporting for "above the line" revenue and building annual, audited financials.
• Experience building and integrating web analytics solutions.

Preferred Skills

• Experience with financial reporting requirements for publicly traded companies.

Key Skills

Education

Any graduate