Helios develops Proxi, an AI-powered operating system that helps public policy, regulatory, legal, and compliance professionals automate research, drafting, data analysis, and stakeholder management.
<p></p> <p>We are looking for a Senior Data Engineer to build and evolve the data platform powering our global workforce management ecosystem. You will design, implement, and maintain scalable data pipelines that consolidate data from multiple operational systems, transform it into trusted analytical datasets, and make it available for reporting, product analytics, and business intelligence.</p> <p>You should be comfortable working with modern cloud-native data architectures on AWS, building reliable ETL/ELT pipelines, and designing data models optimized for analytical workloads. This role requires a strong engineering mindset, balancing performance, scalability, data quality, and operational excellence while collaborating closely with software engineers, product teams, analysts, and data scientists.</p> <h2>What You Will Own</h2> <ul> <li>Design, build, and maintain scalable batch and streaming data pipelines using AWS-native services and distributed processing frameworks</li> <li>Develop ETL/ELT workflows to ingest, consolidate, sanitize, enrich, and transform data from multiple internal and external systems</li> <li>Build and optimize AWS Data Lake solutions using Amazon S3, AWS Glue, Amazon Redshift, and Amazon Kinesis Firehose</li> <li>Design and implement distributed data processing jobs using Apache Spark, AWS Glue, Databricks, or equivalent technologies</li> <li>Develop orchestration workflows using Apache Airflow (MWAA), AWS Step Functions, or similar workflow orchestration platforms</li> <li>Design analytical data models including star schemas, snowflake schemas, dimensional models, and optimized reporting datasets</li> <li>Optimize Redshift performance through distribution strategies, sort keys, partitioning, workload tuning, and query optimization</li> <li>Build resilient pipelines supporting retries, idempotency, checkpointing, incremental processing, and partial failure recovery</li> <li>Implement automated data quality validation, schema evolution, lineage tracking, and governance controls</li> <li>Develop infrastructure and deployment automation using Infrastructure as Code and CI/CD pipelines</li> <li>Monitor, troubleshoot, and continuously improve the reliability, scalability, and performance of the data platform</li> <li>Collaborate with analysts, software engineers, data scientists, and product managers to translate business requirements into scalable data solutions</li> <li>Participate in architecture discussions and contribute technical documentation, standards, and best practices</li> </ul> <h2>What We Are Looking For</h2> <ul> <li>5+ years of professional experience building production data pipelines and cloud-based data platforms</li> <li>Strong experience with AWS data services including Amazon Redshift, AWS Glue, Amazon S3, and Amazon Kinesis Firehose</li> <li>Strong Python programming skills for ETL development, automation, event processing, and scripting</li> <li>Advanced SQL expertise including query optimization, window functions, analytical queries, versioned migrations, rollback strategies, and warehouse tuning</li> <li>Experience designing scalable ETL/ELT pipelines for both batch and streaming workloads</li> <li>Experience with distributed compute and storage using Apache Spark, AWS Glue, Databricks, or similar distributed processing frameworks</li> <li>Strong understanding of data warehousing concepts including dimensional modeling, star schemas, snowflake schemas, partitioning strategies, and analytical data structures</li> <li>Experience designing end-to-end data architectures including ingestion, transformation, orchestration, and consumption layers</li> <li>Experience implementing workflow orchestration using Apache Airflow (MWAA), AWS Step Functions, or equivalent orchestration tools</li> <li>Understanding of data governance, metadata management, security best practices, IAM, encryption, and regulatory compliance considerations</li> <li>Experience with Git-based collaborative development workflows, CI/CD pipelines, Infrastructure as Code, deployment approvals, versioned migrations, and safe rollback strategies</li> <li>Experience monitoring and maintaining production data infrastructure, ensuring high availability, observability, data quality, and operational reliability</li> <li>Strong communication skills with the ability to explain technical concepts to business stakeholders and collaborate effectively across engineering, analytics, and product teams</li> </ul> <h2>Nice to Have</h2> <ul> <li>Experience with Apache Iceberg, Delta Lake, Apache Hudi, or modern open table formats</li> <li>Experience with dbt or SQL-based transformation frameworks</li> <li>Familiarity with Kafka, Amazon MSK, or other streaming platforms</li> <li>Experience with Lakehouse architectures and modern analytical data platforms</li> <li>Knowledge of Terraform or AWS CloudFormation</li> <li>Experience with containerized data workloads using Docker and ECS/EKS</li> <li>Experience implementing DataOps practices and automated testing for data pipelines</li> <li>Familiarity with BI platforms such as Tableau, Power BI, Looker, or QuickSight</li> <li>Experience implementing data catalogs, lineage, and governance solutions</li> <li>Exposure to machine learning feature pipelines or data science infrastructure</li> </ul> <h2>Tech Stack</h2> <table> <tbody> <tr> <td width="314"> <p><strong>Layer</strong></p> </td> <td width="314"> <p><strong>Technology</strong></p> </td> </tr> <tr> <td width="314"> <p><strong>Programming</strong></p> </td> <td width="314"> <p>Python, SQL, PySpark</p> </td> </tr> <tr> <td width="314"> <p><strong>Data Processing</strong></p> </td> <td width="314"> <p>Apache Spark, AWS Glue, Databricks</p> </td> </tr> <tr> <td width="314"> <p><strong>Data Storage</strong></p> </td> <td width="314"> <p>Amazon S3, Amazon Redshift, Parquet</p> </td> </tr> <tr> <td width="314"> <p><strong>Streaming</strong></p> </td> <td width="314"> <p>Amazon Kinesis Firehose, EventBridge<