Data Engineer

Tech Mahindra offers technology consulting and digital solutions to global enterprises across industries, enabling transformative scale at unparalleled speed. With 150,000+ professionals across 90+ countries helping 1100+ clients, TechM provides a full spectrum of services including consulting, information technology, enterprise applications, business process services, engineering services, network services, customer experience & design services, AI & analytics, and cloud & infrastructure services. It is the first Indian company in the world to have been awarded the Sustainable Markets Initiative’s Terra Carta Seal, in recognition of actively leading the charge to create a climate and nature-positive future. Years of Experience: Min. 8+ Years Type of Hiring: Permanent Language: French – Fluent and English Fluent. Onsite/Offsite: Hybrid Remote. 3 days a week in office. 2 days remote Mandatory Skills: Advanced SQL (CTEs and window functions), AWS (Redshift, RDS, S3), Dbt (Dbt Core & Cloud, dbt Docs), Version controls(GitLab / GitHub) Job Description A mandatory requirement for working with customer is to be domiciled in Switzerland. Customer is seeking a hands‑on Data Engineer to design, build, and operate modern ELT/ETL workflows on AWS. The ideal candidate is exceptionally strong in SQL, data modeling (Data Vault, star/snowflake, 3NF, and data mesh concepts), and automation using DBT and shell scripting. You will collaborate with data analysts, architects, and business stakeholders to deliver reliable, governed data products that power analytics and reporting across Alternative Investments. Key Responsibilities Data Pipelines: Design, build, and maintain robust ELT/ETL pipelines on AWS (Redshift, RDS, S3), leveraging dbt (Core/Cloud; dbt Docs) and Informatica where applicable. SQL Excellence: Write advanced SQL (CTEs, window functions, complex joins) for transformations, data quality checks, and performance tuning, primarily targeting Redshift/RDS/Oracle/PostgreSQL. Version Control: Design, build, and maintain robust ELT/ETL pipelines on AWS (Redshift, RDS, S3), leveraging dbt (Core/Cloud; dbt Docs) and Informatica where applicable. Stakeholder Collaboration: Work closely with business and analytics teams (French/English) to translate requirements into scalable data products; provide clear documentation via dbt Docs. Must‑Have Qualifications Advanced SQL: Complex queries using CTEs and window functions. AWS: Redshift, RDS, S3. dbt: Core & Cloud, dbt Docs. Version Control: GitHub/GitLab Nice to Have Data migration experience (ideally to AWS) Bash/Shell Scripting AWS: Lambda, IAM Domain knowledge: Ideally experience in Alternative Investments (Private Assets and/or Hedge Funds) Less Priority APIs integration (REST / GraphQL) Python Power BI Microsoft Fabric Monitoring and alerting fundamentals How to Apply It's easy to apply online; you just need a copy of your up-to-date CV and to follow the step by step process. Don't worry if you need to make changes - you'll have the opportunity to review and edit your work on the final page, or you can also share resume directly to provided email address. We look forward to receiving your application Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions. Seniority Level Associate Employment Type Full-time Job Function Consulting Industries IT Services and IT Consulting Referrals increase your chances of interviewing at Tech Mahindra by 2x #J-18808-Ljbffr