Lead -Data Engineer Snowflake

Reporting to: Technical Manager

Who we are:

Orion delivers game changing business transformation & digital product development with agility at scale. With a maturity and scale of 25+ years in the industry, Orion has 6000+ associates working across 13 major delivery centers across the globe! Follow us on the links below to know more!  www.orioninc.com 


The ideal candidate will show interest in mastering and exercise responsibility towards both project and Team. The candidate must have strong analytical skills and possess excellent communication skills, both oral and written.

 Key Accountability:

  • Assist with technical design and development activities for implementation of large-scale data solutions in Snowflake
  • Support design and development of technology and data architectures to support client solutions leveraging best practices for cloud data warehouse migrations
  • Developing ETL pipelines in and out of data warehouse using leading ETL tools and Snowflakes Snow SQL
  • Writing SQL queries against Snowflake
  • Implement data pipelines and modern ways of automating ELT data pipelines using advanced SQL
  • Translate requirements for BI and Reporting to Database design and reporting design
  • Understanding data transformation and translation requirements and which tools to leverage to get the job done
  • Understanding data pipelines and modern ways of automating data pipelines
  • Testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions

 Key Competencies:

  • Total Years of Experience 10+ years in IT industry
  • 5+ years current and deep experience with Cloud Data platform implementation
  • Relevant years of experience in ETL tools like (SnowPipe, StreamSets, Matillion, Informatica, Talend and Apache Airflow etc.)
  • Hands on experience Designing and developing Data Pipelines for Data Ingestion or Transformation using Python (PySpark)/Spark SQL
  • Proven experience in implementing & executing projects using Snowflake
  • Proficient in identifying, analyzing and solving problems
  • Knowledge of Data warehousing and its components. STAR and Snowflake Schema, Dimension, Fact and Measures
  • Experience in Cloud data migration patterns
  • Agile methodology experience essential
  • 3+ years’ experience assessing feasibility of migrating customer solutions and/or integrating with 3rd party systems both Microsoft and non-Microsoft platforms
  • Proven interpersonal skills while contributing to team effort by accomplishing related results as needed

Life at Orion APAC

Orion offers an immersive, energetic work environment where employees can innovate. We encourage you to join us at any of our offices in Mumbai, Pune, Kochi, Chennai, Coimbatore, Madurai, or Hyderabad in India or in Melbourne, Australia.

Work Environment

Orion believes in creating a productive, diverse work environment for employees. The ability to solve business problems using technology, pushing the normal and driving a high-performance culture is what brings excitement to Orion. Everyone brings a diverse set of perspectives, work and life experiences, which makes us valuable, both internally and for our clients.  

Growth Potential

No matter where you start, one can go a long way at Orion. As a scale player in the digital transformation space, Orion offers limitless opportunities across digital and custom application development work in various technology stacks and industry domains.

Education Programs

Orion offers many learning opportunities through various certification and proficiency programs to build depth and width in technology, domain, functional, process and Leadership areas.

For technology students, we offer training through our partner institutions and public programs run by our specialists. 

Employee Benefits

Apart from cutting edge work that creates exceptional talent, we offer competitive compensation and benefits that include leave, retirals, medical benefits and comfortable, safe workspaces. We also encourage our employees to maintain a healthy work life balance across all our office locations. 

Keep Connected