Data Engineer

Location: San Ramon, CA

Time Type: Full time

Job Description

• Years of experience: 5 to 10  years

Focus: Reliability, Automation, and Data Quality. The Engineer turns the architect's blueprint into a working, automated reality.

• Key Responsibilities:
• Build and maintain ETL/ELT pipelines to move data from source to storage.
• Implement automated data quality testing and observability alerts.
• Optimize data storage formats (e.g., Parquet, Delta Lake) for high-speed querying.
• Manage CI/CD pipelines for data code deployment.
• Create interactive visualizations with actionable insights by persona
• Deliverables: Production-ready optimized data pipelines, Cleaned  datasets, interactive & intelligent dashboards.
• Tech Stack - AWS
• Data Ingestion & Processing : AWS API Gateway, AWS Lambda, AWS Glue ETL, AWS Glue Crawler
• Data Storage & Analytics : Amazon S3, Amazon Redshift (Data Warehouse), Amazon Athena
• Governance & Security : AWS Lake Formation, AWS IAM, AWS CloudTrail, Amazon CloudWatch
• AI & Analytics : AWS Bedrock
• Visualization : Amazon QuickSight 
• Visa Requirement: USA Work Visa - H1B / H4 with EAD with a minimum validity of 2 years

Salary Range

• Please note that the salary information provided herein is base pay only (gross); it does not include other forms of compensation which may or may not apply to this specific position, namely, performance-based bonuses, benefits-related payments, or other general incentives - none of which are guaranteed, may be subject to specific eligibility requirements, and are wholly within the discretion of Astreya to remit.
• Further, the salary information noted above is a range that consists of a minimum and maximum rate of pay for this specific position. Where an applicant or employee is placed on this range will depend and be contingent on objective, documented work-related considerations like education, experience, certifications, licenses, preferred qualifications, among other factors.

Astreya offers comprehensive benefits to all Regular, Full-Time Employees, including:

• Medical provided through UHC (PPO, HSA, Surest options) / Medical provided through Kaiser (HMO option only) for California employees only

• Dental provided through UHC

• Nationwide Vision provided by UHC

• Flexible Spending Account for Health & Dependent Care

• Pre-Tax Account for Commuter Benefit/Parking & Transit (location-specific)

• Continuing Education and Professional Development via various integrated platforms, e.g. Udemy and Coursera

• Corporate Wellness Program provided by Goomi Group

• Employee Assistance Program

• Wellness Days

  401k Plan

• Basic and Supplemental Life Insurance

• Short Term & Long Term Disability

• Critical Illness, Critical Hospital, and Voluntary Accident Insurance

• Tuition Reimbursement (available 6 months after start date, capped)

• Paid Time Off (accrued and prorated, maximum of 120 hours annually)

• Paid Holidays

• Any other statutory leaves, paid time, or other ancillary benefits required under state and federal law