Fasset

Data Engineer

• Own the deployment, scaling, and orchestration of core data stack using AWS Managed Workflows for Apache Airflow (MWAA).
• Design and evolve the overall data platform architecture, making thoughtful tradeoffs around scalability, reliability, cost, and maintainability.
• Configure and optimize raw data storage in S3, managing Redshift external schemas (Spectrum) and AWS Glue Data Catalog.
• Define efficient partitioning strategies, leverage columnar file formats (Parquet), and optimize storage layouts for query performance, scalability, and cost.
• Design scalable analytical data models using dimensional modeling and lakehouse best practices to support reporting, analytics, and downstream consumers.
• Manage and optimize dbt to ensure efficient transformation, testing, and materialization of raw data within Amazon Redshift.
• Build observability into the data platform through monitoring, logging, alerting, and operational dashboards.
• Help design and implement the transition toward event-based ingestion into S3.
• Implement and maintain CI/CD deployment pipelines for dbt projects, Airflow DAGs, and infrastructure.
• Ensure high performance, access control, and uptime for BI tools connecting to Redshift.

Senior Data Engineer