Remote Data Warehousing Specialist

Summary

Join Clarasight as a Data Manager to help close the gap between climate-related intent and action by building the Carbon Planning and Analytics platform. As a stellar person with exceptional data and engineering talent, you will develop and maintain Clarasight's data architecture strategy, own the company's data warehouse, and manage the process of data ingestion.

Requirements

• 5+ years of data architecture, data modeling, data warehousing concepts, methodologies, and best practices
• Experience scaling and re-architecting data platforms and infrastructure through orders of magnitude of growth and scaling data volume
• Experience working on data infrastructure-focused engineering teams building a data lake or data warehouse from scratch
• Experience with state-of-the-art ETL tools, techniques and processes
• Experience with AWS and cloud-based data services
• RDBMS; SQL; query optimization; performance troubleshooting
• Familiarity with DBT or SQLMesh
• Familiarity with one of the data warehouses like Google Big Query, Snowflake, Redshift, Databricks
• 0 to 1 startup experience
• Exceptional common sense and the ability to manage ambiguity

Responsibilities

• Develop and maintain Clarasight’s data architecture strategy
• Own Clarasight’s data warehouse – the backend of our B2B SaaS platform
• Manage the process of data ingestion into Clarasight’s data warehouse
• Establish an enterprise ETL technical architecture for ingestion of all third party and customer data feeds
• Perform data cataloging analytics on source data including data provided by clients and determine business rules for data ingestion
• Write requirements for and then implement ETL and data pipelines including exception-handling protocols and processes
• Build core datasets
• Implement manual and automated data quality management
• Define and uphold SLAs
• Become a subject matter expert in travel and expense data
• Collaborate with Software Development, Data Scientists, Product Management, and Customer Success
• Democratize compliant and secure access to data through self-serve channels
• Establish data governance policies and procedures
• Monitor and troubleshoot data infrastructure issues
• Manage the planning, implementation and testing of Continuity of Business and Disaster Recovery for Clarasight’s data warehouse
• Provide technical leadership and share knowledge, for instance, through code reviews, pairing, ADRs, and presentations

Preferred Qualifications

• Experience with open-source libraries, frameworks, and systems such as DuckDB, Spark, Trino, Iceberg, and Deltalake
• Building or using Financial Planning & Analysis (FP&A) systems
• Data visualization tools (e.g., Tableau in particular, Power BI)
• TypeScript – It’s what our ETL is written in now
• Data Science
• Data Wrangling

Benefits

• Generous stock options in our early stage startup for full time members of the team
• Robust benefits for full-time employees including full medical, dental and vision insurance, 401k and sustainability benefit ($500 annually to spend on increasing personal sustainability)
• Opportunity to make a foundational contribution to our mission of closing the gap between climate-related intention and action
• Remote-first work environment
• Working among a diverse, expert team at the forefront of climate tech, behavioral change, and people technology