Oran Inc is seeking a highly experienced Senior Data Engineer to support a large-scale Snowflake migration project for a regulated financial environment. The role involves designing, developing, and supporting modern data pipelines while translating legacy ETL systems into scalable Snowflake solutions.
Responsibilities:
- Design, develop, and optimize end-to-end data pipelines using Snowflake and modern data engineering tools
- Translate and modernize legacy ETL workflows (SAS or similar) into scalable Snowflake-based architectures
- Build and maintain metadata-driven ETL frameworks with strong auditability, lineage, and control mechanisms
- Write and optimize complex SQL queries for performance and scalability within Snowflake
- Ensure data quality, integrity, and governance across all pipelines
- Provide production support, including troubleshooting, root cause analysis, and issue resolution in a regulated environment
- Collaborate with cross-functional teams including Data Architects, Analysts, and Business stakeholders
- Implement best practices for CI/CD, version control, and automated testing in data pipelines
- Participate in code reviews, design discussions, and continuous improvement initiatives
Requirements:
- 7+ years of experience in data engineering / ETL development
- Strong hands-on experience with Snowflake (data modeling, performance tuning, SnowSQL, Snowpipe, etc.)
- Advanced proficiency in SQL and pipeline design
- Proven experience migrating legacy ETL systems (SAS, Informatica, or similar) to modern cloud-based platforms
- Experience building metadata-driven frameworks with logging, auditing, and control layers
- Strong experience in production support environments, including monitoring, incident management, and recovery
- Familiarity with regulated environments (financial services preferred) with strict data governance and compliance requirements
- Experience with orchestration tools (e.g., Airflow, Azure Data Factory, etc.)
- Strong problem-solving skills and ability to work independently at a senior level
- Experience working on Snowflake migration projects in large enterprises
- Background in SAS-based data environments
- Knowledge of data governance, lineage, and compliance frameworks
- Experience with cloud platforms (AWS, Azure, or GCP)
- Familiarity with DevOps practices in data engineering