Data Engineer

The Coinbase Customer Experience (CX) organization plays an imperative role in achieving our mission. Our team is dedicated to eliminating customer challenges, empowering our global user base via self-service and automation, and optimizing customer support interactions to build an effortless experience. As a Data Engineer on our team, you will function as a force multiplier, enabling Analytics and Operations to function seamlessly at scale. You’ll have the opportunity to translate complex technical and operational requirements into easily consumable front end data solutions, while also heavily influencing the overarching strategy for CX Analytics and its partners.

What we do:

• Build and maintain a foundational data layer (data marts), that serves as the single source of truth across CX and Coinbase. 
• Design and implement robust data pipelines, guaranteeing data quality and timely data delivery across our organization.
• Pioneer developer tools that inject automation into data science processes, improving efficiency and productivity. 
• Deliver tailored data products, designed to empower users with self-serve capabilities and ensure accurate answers to their data queries.

What you’ll be doing (ie. job duties): 

• Capturing customer and partner team user stories to develop solutions that truly solve their needs
• Collaborate with stakeholders to manage a long-term engineering roadmap that balances the tactical and strategic needs of the business
• Proactively identify opportunity areas for improvement including deep dive investigations and processes to better serve our customers
• Drive the vision, building, and adoption of self-service analytic capabilities; develop these capabilities at scale
• Understand data resources and know when, how, and which best to use for each project
• Ability to frame and break down complex business problems into key components and recommend practical solutions
• Function as a team expert on data infrastructure efficiency and cost optimization
• Build a collaborative team environment that fosters efficient execution, innovation, and continuous improvement
• Collaborate with analysts to solve complex data problems and provide recommendations on both content and optimization.

What we look for in you (ie. job requirements): 

• Python and Advanced SQL: Must be adept at scripting in Python, particularly for data manipulation and integration tasks, and have a solid grasp of advanced SQL techniques for querying, transformation, and performance optimization.
• Data Modeling: Understanding of best practices for data modeling, including star schemas, snowflake schemas, and data normalization techniques.
• ETL/ELT Processes: Experience in designing, building, and optimizing ETL/ELT pipelines to process large datasets.
• Apache Airflow: Experience in building, deploying, and optimizing DAGs in Airflow or a similar tool.
• GitHub: Experience with version control, branching, and collaboration on GitHub.
• Data Visualization: Knowledge of tools like Superset, Looker or Python visualization libraries (Matplotlib, Seaborn, Plotly…etc)
• Collaboration and Communication: Ability to work closely with data scientists, analysts, and other stakeholders to translate business requirements into technical solutions. Strong documentation skills for pipeline design and data flow diagrams.
• Fluent in English.
• Able to work with team based in the Pacific Time Zone. 

Nice to haves:

• Prompt Engineering for LLMs: Expertise in crafting, testing, and refining prompts for effective communication with LLMs, like GPT, to generate accurate and contextually relevant responses.
• Familiarity with Cloud platforms like AWS/GCP
• Knowledge of fundamental DevOps practices, including unit testing and repository management.

Job #: P57533