Solution Architect/Tech lead

Ankura is a team of excellence founded on innovation and growth.

Experience: 15+ years

Location: Gurgaon, Mumbai & Hyderabad

Ankura:

Ankura Consulting Group is recognized as one of the five fastest-growing consulting companies, with 1,500 employees across 32 offices in 4 continents. The Company provides services to its client on expert witness, bankruptcy and corporate restructuring, litigation support, forensic accounting, geopolitical risk assessment, and general management consulting services. Ankura Consulting Group's headquarters is based in Washington, USA.

Role Overview:

We are seeking a highly motivated and experienced Data Engineer to join our growing data team. The ideal candidate will have a strong understanding of modern data stack technologies and be proficient in building and maintaining robust data pipelines. This role requires expertise in ELT processes, data warehousing, and scripting, along with the ability to collaborate effectively with other engineers and stakeholders.

Why Join Ankura

• We can support and develop individuals who aspire to be an expert.

• Vast opportunities for career development, with formal development process, training programmes and internal e-learning training platform, Ankura Academy.

• Work within a team of world recognised leading experts in an established leading global consultancy.

• Work with a collaborative environment, where our professionals have the freedom to innovate which promotes curiosity, learning and communication.

Responsibilities:

• Design, develop, and maintain efficient and reliable data pipelines using modern ELT tools like DBT, Fivetran, Matillion, Talend, or Ab Initio.

• Implement data transformations and cleansing processes to ensure data quality and accuracy.

• Build and optimize data models for cloud data warehouses like Databricks, Snowflake, or Redshift.

• Write complex SQL queries for data extraction, transformation, and loading.

• Develop and maintain shell or Python scripts for automation and data processing.

• Monitor and troubleshoot data pipelines to ensure optimal performance and stability.

• Collaborate with data scientists and analysts to understand their data needs and provide support.

• Stay up-to-date with the latest data engineering trends and technologies.

• Contribute to the development of data engineering best practices and standards.

• Participate in code reviews and ensure code quality.

• Work closely with the infrastructure team to deploy and manage data pipelines.

• [Optional: Include specific domain experience, e.g., Experience with e-commerce data, financial data, etc.]

Requirements:

• 15+ years of experience in data engineering or a related field.

• Strong proficiency in SQL.

• Experience with one or more modern ELT tools (e.g., DBT, Fivetran, Matillion, Talend, Ab Initio).

• Experience with cloud data warehouses (e.g., Databricks, Snowflake, Redshift).

• Strong scripting skills in shell or Python.

• Understanding of data warehousing concepts and dimensional modeling.

• Experience with data integration and ETL processes.

• Excellent problem-solving and analytical skills.

• Strong communication1 and collaboration skills.

• Ability to work independently and as part of a team.2

Preferred Skills (Good to Have):

• Experience with data orchestration tools (e.g., Airflow, Prefect).

• Experience with cloud platforms (e.g., AWS, Azure, GCP).

• Experience with data streaming technologies (e.g., Kafka, Spark Streaming).

• Experience with data governance and security best practices.

• Experience with Agile development methodologies.

• Familiarity with data visualization tools (e.g., Tableau, Power BI).

Qualification:

Bachelors in Engineering, computer science preferred.

Certification in cloud platform or relevant data platforms.

#LI-JK1

*

Ankura is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability. Equal Employment Opportunity Posters, if you have a disability and believe you need a reasonable accommodation to search for a job opening, submit an online application, or participate in an interview/assessment, please email [email protected] or call toll-free +1.312-583-2122. This email and phone number are created exclusively to assist disabled job seekers whose disability prevents them from being able to apply online. Only messages left for this purpose will be returned. Messages left for other purposes, such as following up on an application or technical issues unrelated to a disability, will not receive a response.