Senior Data Engineer

Sr Data Engineer

Position Summary

We are looking for a self-sufficient BI Analyst / Data Engineer to join a small, high-impact analytics team. In this role you will own the full lifecycle of business intelligence delivery-from building and maintaining ETL pipelines in AWS to designing interactive dashboards in Amazon QuickSight. You will work closely with onshore stakeholders to translate business requirements into reliable, well-documented data products that drive operational and strategic decision-making.

The ideal candidate is comfortable operating independently across the data stack, takes ownership of their work, and communicates proactively with team members across time zones.

Core Responsibilities

ETL / Data Pipeline Development

• Design, build, and maintain AWS Glue (PySpark) ETL jobs that ingest data from multiple source systems such as Salesforce, JIRA, Azure DevOps, and Zendesk into a layered data lake architecture (raw core presentation).
• Develop and optimize AWS Step Functions workflows for pipeline orchestration, including parallel execution, error handling, retry logic, and concurrency management.
• Implement incremental loading strategies, schema evolution handling, and data quality checks within Glue scripts.
• Work with Apache Iceberg table format on S3 for ACID-compliant analytics tables, including MERGE operations, compaction, snapshot expiration, and orphan file cleanup.
• Integrate supporting AWS services such as EventBridge, SQS, SNS, Athena, and CloudWatch into pipeline architectures.
• Troubleshoot production pipeline failures, diagnose performance bottlenecks (OOM errors, API timeouts, DPU tuning), and implement fixes with minimal guidance.
• Write and maintain clear technical documentation for all pipeline components.

Dashboard Reporting Development

• Build, publish, and maintain Amazon QuickSight dashboards and analyses that serve operational and executive audiences.
• Create well-modeled QuickSight datasets backed by Athena queries over Iceberg tables, applying appropriate joins, calculated fields, and filters.
• Translate business requirements and existing Tableau/Excel reports into QuickSight visuals, ensuring accuracy and usability.
• Optimize dashboard performance, evaluating SPICE vs. Direct Query modes and managing refresh schedules.
• Collaborate with stakeholders to iterate on dashboard designs, incorporating feedback and refining KPIs.

General Team Responsibilities

• Participate in code reviews, sprint planning, and knowledge-sharing sessions with the broader BI and engineering teams.
• Follow established Git branching strategies and CI/CD practices for infrastructure and code deployment.
• Monitor data freshness and pipeline health; respond to alerts and escalate issues as appropriate.
• Proactively identify opportunities to improve data quality, reduce pipeline run times, and enhance reporting capabilities.

Required Qualifications

• 5-10+ years of professional experience in data engineering, BI development, or analytics engineering.
• Strong hands-on experience with AWS Glue (PySpark), Step Functions, S3, Athena, and IAM.
• Proficiency in Python and SQL; experience writing PySpark transformations and Athena queries.
• Experience building and maintaining ETL pipelines that ingest data from REST APIs or SaaS platforms (e.g., Salesforce, JIRA, Zendesk).
• Working knowledge of Amazon QuickSight, including dataset creation, calculated fields, parameters, and dashboard publishing.
• Familiarity with columnar/lakehouse table formats such as Apache Iceberg, Delta Lake, or Apache Hudi.
• Solid understanding of data warehouse concepts: dimensional modeling, slowly changing dimensions, incremental vs. full loads.
• Comfortable working independently with minimal day-to-day supervision, managing your own task priorities, and communicating status asynchronously.
• Strong written and verbal English communication skills; able to participate in cross-timezone meetings and write clear documentation.

Preferred Qualifications

• Experience with infrastructure-as-code tools such as AWS CDK, CloudFormation, or Terraform.
• Familiarity with CI/CD pipelines (GitHub Actions, CodePipeline) for data engineering workflows.
• Exposure to PII detection/redaction practices or data governance frameworks.
• Prior experience translating Tableau workbooks or Excel-based reports into another BI platform.
• Knowledge of EventBridge-driven architectures and SQS/SNS messaging patterns.
• AWS certifications (e.g., Data Analytics Specialty, Solutions Architect Associate) are a plus.

What We Offer

• The opportunity to work on a greenfield BI platform with modern cloud-native tooling.
• A collaborative, small-team environment where your contributions have direct and visible impact.
• Exposure to a broad technology stack spanning data engineering, analytics, and cloud infrastructure.

• Mentorship and growth opportunities within a growing data organization.