data Engineer

Who We're Looking For - The Dream Maker
We are looking for a hands-on data engineer who will build and develop the entire data engineering capabilities and infrastructure, from scratch. This role will possess a combination of technical expertise, problem-solving skills, and strong communication abilities. It will interface with all the departments of our rapidly growing organization in this transformative period.
Your Arena Data Standardization : Make sure that data is standardized, and manage efforts on that initiative (including past data), create a live documentation for the existing data schema (main entities + each field), ensure that data schema is consistent and participate in design reviews that involve database design, oversee the adoption of a common data access layer for our main DB entities (disputes, customer data, integrations, billing), add and maintain a validation processes ayer to prevent divergence from schema and closed set of value Data Correctness & Integrity : Set up processes to ensure data correctness, validity based on business requirements, processes to detect data duplication in our database, and take actions to remediate this with the business stakeholders Data Optimization and Operations : Monitor and Operate DB Performance, manage indices, alerts, scaling on a daily basis Data Engineering technologies and roadmap : Analyze and choose the right database and related technologies for our evolving needs including data warehouses, data lakes, graph database, relational and non-relational databases and ETL tools. Be a knowledgable source to consult on DB design, optimization and operations for our existing and future DB technologies: Mongodb, dynamodb, rockset, postgres, snowflake. Oversee ETL, ELT processes that are used in the company, both inside R&D and in other departments (R&D, Opertations, Marketing), using AWS Glue, HighTouch, Airbyte. Design data tiering practices to find the tradeoffs for cost/performance/flexibility/query Data Security, Access control and regulation : Support our efforts to map out PII data in our database and limit access to it, Implement encryption at rest and other practices to protect our databases, Execute data deletion tasks like removal of personal data, customer(shop/account) data as part of our SOC2/GDPR compliance Business Intelligence : Choose and configure a BI system that makes all of our data accessible in a single system to various stakeholders and departments in the company (R&D, Product, Operations, Finance, Sales, Marketing, Customer Success, etc.). Create ad-hoc and periodic reports & dashboards for stakeholder, on demand.