BlockFi is hiring a

Web3 Senior Data Warehouse Engineer

JOB DESCRIPTION

BlockFi is looking for a Senior Data Warehouse Engineer to join our growing team!

About Your Team

As a member of the Data Warehouse Team your responsibilities will be focused on the creation, maintenance, and scalability of all data sources that BlockFi currently has, or will have in the future. You will be expected to not only meet your direct day to day responsibilities detailed below, but also assist with helping to shape the future of the tech stack within the Data Warehouse department.

Your Mission

• Build reusable components and infrastructure that make it simple for anyone asking data questions to get the answers they need
• Design, build, and operate your platform components so that others can rely on your great ideas (common streaming architectures, data storage methods, proper processing environments)
• Write code that allows consumers of your components to implement infrastructure as code libraries (AWS CDK, Pulumi, etc) so that other teams can use them with ease
• Describe and document examples on how teams can perform different tasks that integrate with your infrastructure
• Construct your flows so that the absolute highest security standards are implemented from the start for your consumers
• Profile your work to maintain metrics on systems so that your documentation describes the limits and tradeoffs of each set of architectures
• Simplify and improve as you go

Your Expertise

• 5+ years of professional experience as a data warehouse engineer
• Strong knowledge of cloud databases, particularly PostgreSQL
• Strong programming skills in Python, Elixir or other high level languages
• Experience with SQL adapters such as Ecto and managing SQL schema changes with code
• Experience with AWS cloud services: S3, EC2, RDS, Aurora, Redshift
• Experience with stream-processing systems: Kinesis, EventBridge, Confluent, Kafka or similar.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience building and optimizing data pipelines, architectures and data sets.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• A successful history of manipulating, processing and extracting value from large disconnected datasets.
• Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.
• Strong project management and organizational skills.

Your Perks:

We benefit from the great work our employees do each day. That is why we are committed to providing a variety of awesome benefits to help them live their best lives.

• Competitive salary because we value your experience and expertise
• Unlimited vacation / sick days because everyone deserves time for R&R
• Employer contribution towards health coverage (including vision & dental) because your physical health and well-being is important to us
• Various fringe benefits such as 401k, Parental Leave, FSA/HSA, and Employee Assistance Programs because health coverage is more than just choosing your yearly plan
• Flexible work environment because we are a geographically dispersed team and we believe in balance
• Pet insurance because all of your beloved family members should have coverage too
• Weekly lunch stipend because there is such a thing as a free lunch!
• A close-knit team of enthusiastic, collegial and driven people to work alongside in a highly meritocratic environment because teamwork makes the dreamwork

Apply Now: