Senior Data Engineer

This is a fully remote position, open to applicants in Philippines.

📋 Description

• Develop Silver layer dbt models for each phase of the dataset, including staging models, intermediate models, and conformed fact and dimension tables.

• Establish and execute incremental load strategies for each entity, incorporating upsert logic, snapshot tables, and managing data freshness.

• Create and maintain dbt schema tests, ensuring not-null constraints, uniqueness, referential integrity, accepted values, and custom generic tests are implemented.

• Collaborate with the analytics engineer on the Silver-to-Gold interface to ensure Silver models provide the necessary fields and granularity for Gold metric calculations.

• Partner with IT throughout each phase to verify entity availability, field mappings, and the quality of Bronze tables before construction begins.

• In a steady-state operation: take ownership of pipeline incident responses, manage schema drift, and monitor Snowflake performance across all live datasets.

• Investigate and address pipeline incidents that have been escalated by the AI triage layer.

• Manage any upstream schema changes that impact Bronze-to-Silver mappings.

• Monitor and enhance Snowflake query performance across live Gold datasets.

• Own and oversee the AI triage pipeline, ensuring the accuracy of alert classifications and the completeness of incident logs.

• Ensure that escalated alerts are acknowledged and resolved within the established SLA timelines.

• Maintain precise data catalog documentation and quality certifications for all production Gold datasets.

⛳️ Requirements

• 4-6 years of experience in Data Engineering.

• Advanced knowledge of Snowflake, including incremental models, time travel, merge statements, clustering, and zero-copy cloning for testing environments.

• Advanced expertise in dbt, including macros, packages, generic tests, snapshots, sources, exposures, and CI/CD integration.

• Proficient in SQL, with skills in complex joins, window functions, managing late-arriving data, and optimizing query performance.

• Intermediate Python skills, particularly with Snowpark for custom transformations where SQL is insufficient.

• Proficient with Git, including branching strategies, pull requests, and conflict resolution within a shared dbt project.

• Intermediate understanding of retail data structures, such as order headers and lines, inventory snapshots, customer master data, and fiscal calendars.

• Hands-on experience with AI & Automation Tools, including tools like GitHub Copilot, Cursor, Claude (or similar LLMs), Snowflake Cortex AI_COMPLETE, Elementary, and data observability platforms for AI-assisted development, SQL debugging, anomaly detection, alert classification, incident reporting, and workflow automation.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health, dental, and vision insurance plans.

• Generous paid time off and flexible working arrangements.

• Opportunities for professional development and continuous learning.

• Collaborative and innovative work environment.