Data Engineer

About this role

## Overview

The Data Engineer is responsible for enabling data flow into and out of Origami’s multi-tenant SaaS platform. This role plays a critical part in our modernization initiative, transitioning from legacy ingestion processes embedded in C# .NET code to a scalable, cloud-native architecture on AWS. This helps design and implement solutions that allow clients to seamlessly ingest data via APIs and file uploads, map and transform data, and load it into SQL Server databases. Additionally, the Data Engineer supports the integration of ingested and SaaS-generated data into our Databricks-based analytical platform for advanced processing and analytics.

Starting base pay for this role is between $97,000 and $122,000. The actual base pay is dependent upon many factors, such as transferable skills, work experience, business needs, training, location, and market demands. The base pay range is subject to change and may be modified in the future. This role will be eligible for a bonus as well as competitive medical, dental, and vision benefits, wellness reimbursement, life insurance, and a 401(k) with company match. We offer vacation and sick leave benefits (under a flexible time off policy in most states).

## Responsibilities

• Designs and implements scalable data ingestion pipelines using AWS services (e.g., S3, Lambda, API Gateway, Glue, Step Functions)
• Builds APIs and file upload mechanisms for client data ingestion
• Develops data mapping and transformation workflows for loading into SQL Server client databases
• Contributes to the design and implementation of a data lakehouse architecture leveraging Databricks
• Enables seamless data flow from the SaaS platform to the analytical platform
• Optimizes ETL/ELT processes for performance and reliability
• Collaborates with analytics teams to ensure data availability and quality for reporting and machine learning use cases
• Provides operational support for existing ingestion processes integrated into C# .NET code ...