Data Engineer
Redwood City, CA
Full Time Mid-level / Intermediate USD 100K - 200K
Gunderson Dettmer
#1 law firm globally for venture-backed companies and investors by PitchBook for 9 years in a row.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.
- 5+ years of relevant experience designing, building and managing ETL processes with a variety of tools.
- Significant experience with:
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.
- 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.
Gunderson Dettmer is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.
By applying to this job you acknowledge that you have read the California Consumer Privacy Act Applicant Notice
View HERE
Tags: Airflow APIs Data quality Data visualization Data warehouse dbt ETL GCP Google Cloud GraphQL NoSQL Privacy Python R RDBMS Snowflake SQL
Perks/benefits: Career development Competitive pay Equity Flex hours Flexible spending account Flex vacation Health care Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Business Intelligence Engineer jobs
- Open Data Engineer II jobs
- Open Lead Data Analyst jobs
- Open Power BI Developer jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Sr Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Principal Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Research Scientist jobs
- Open Junior Data Engineer jobs
- Open Data Quality Analyst jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Data quality-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open NLP-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Consulting-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Data warehouse-related jobs