Data Engineer

Gunderson Dettmer is the only business law firm of its kind - exclusively serving the global venture capital and emerging technology marketplace. With 400 attorneys in eleven offices - from Silicon Valley to Singapore - we innovate for innovators, accelerate entrepreneurship, and help build companies at every stage of the growth lifecycle. We are committed to being the employer of choice by working together to create an environment, in which each of our people can grow, take initiative, and develop a fun, fulfilling and financially rewarding career. 

Benefits

In addition to offering competitive salaries, we also offer an excellent benefit package, which includes full medical, dental and vision coverage; 401(k) Profit Sharing Plan; Flexible Spending Account and Paid Time Off. 

Job Description
Join Gunderson Dettmer, the preeminent international law firm with an exclusive focus on the innovation economy, as a full time Data Engineer to work at the intersection of technology, law, data and innovation. We’re at the forefront of legal innovation and are actively developing and refining the law firm tech stack of the future. This unique position offers the opportunity to help architect the modern law firm’s data infrastructure, power key applications to solve problems for legal practitioners, and craft the integration layer between these bespoke tools and our data warehouse. We seek a talented individual who thrives in a collaborative, cross-functional environment and embodies a commitment to precision, repeatability, and quality.
Responsibilities:

• Design, build and manage robust, end-to-end ETL processes with performance monitoring.
• Create data integrations between various cloud-based software solutions and platforms (including our enterprise data warehouse) using iPaaS tools.
• Manage and optimize enterprise data warehouse on RDBMS with a complex Dim/Fact data model for analytics.
• Manage and optimize cloud infrastructure to ensure scalability, reliability, and cost-effectiveness.
• Work with cross-functional teams—including legal engineers, data visualization specialists, business solutions and product specialists and subject-matter experts—to ensure efficient and coherent data processes and delivery of high-quality data products.
• Improve and maintain quality control, implementing best practices to ensure data products meet our standards of reliability, usability, and performance.
• Proactively identify opportunities to improve data quality, tooling, and version controls.

Requirements:

• 5+ years of relevant experience designing, building and managing ETL processes with a variety of tools.
• Significant experience with:

iPaaS tools like Apache AirFlow
API technologies such as REST and GraphQL and transfering files using SFTP
Data transformation tools like dbt
RDBMS platforms like Snowflake
noSQL databases like Mongo
Dim/Fact data models for analytics

• Proficiency writing Python scripts and SQL queries (with experience writing Mongo Atlas aggregation queries considered a plus).
• Exceptional problem-solving skills, ability to work independently, and a collaborative spirit.
• Excellent communication skills, underpinning effective collaboration with various teams and subject-matter experts.

Nice-to-haves:

• Experience with Google Cloud Platform (particularly IAM permissions, as well as log analytics, queries and dashboards).
• Experience with other Snowflake platform features like Snowsight and Cortex.
• Experience in a financial services, professional services or law firm environment.
• Experience in, or familiarity with, the venture-backed company or venture capital space, especially including familiarity with private company equity data schemas and transaction modeling.

Location:
Work out of any of our firm’s U.S. offices or remotely.
Our Offer:
Join us as a Data Engineer and be at the forefront of innovation and change in the legal industry. We offer a dynamic, supportive, and collaborative work environment, where our contributions will shape the future of legal service delivery. Be part of our journey to optimize the way we serve our clients and make a lasting impact on the legal landscape. The expected starting salary for this position is $100,00 - $200,000 annually, dependent upon qualifications, experience and location.