Data Engineer – Python DBT SQL IRC291765

Description We are seeking a seasoned Senior Data Engineer specializing in Python, dbt, and SQL to design, optimize, and scale our core data infrastructure. In this role, you will be the bridge between raw, disparate data sources and high-performance analytics, driving the architecture of our modern data stack. This is not a role for simple data moving; you will own the reliability, scalability, and quality of our data warehouse. You will write clean, modular dbt models, develop custom Python frameworks for complex ELT/ETL extractions, and optimize massive SQL queries to keep compute costs low and performance high. If you treat data infrastructure like software engineering—valuing testing, documentation, and automated deployment—you will thrive in this environment.

Requirements

• Experience: 6+ years of experience in data engineering, backend engineering, or a highly analytical data infrastructure role.
• SQL & Warehouse Mastery: Exceptional SQL skills with a deep understanding of database internals, query execution plans, and analytical performance tuning.
• dbt Expertise: Proven track record of deploying and managing dbt in production at scale, including experience with dbt packages, custom macros, and documentation generation.
• Software Engineering Mindset: Strong Python development skills, including writing reusable modules, handling APIs, using virtual environments, and implementing unit tests.
• Cloud-Native Fluency: Deep familiarity with cloud environments (AWS, GCP, or Azure) and containerized workflows (Docker).
• Communication Skills: Ability to clearly explain data architecture choices, trade-offs, and data lineages to both technical and non-technical stakeholders. Job responsibilities
• Data Pipeline Development: Design, build, and maintain scalable ELT/ETL pipelines using Python and SQL to ingest data from internal applications, production databases, and third-party APIs.
• Data Transformation Architecture: Own the dbt environment, establishing best practices for model layering (staging, intermediate, marts), macro development, and state management.
• Warehouse Optimization: Architect and optimize schemas within our cloud data warehouse, ensuring efficient indexing, partitioning, clustering, and cost-effective query execution.
• Data Quality & Testing: Implement rigorous data testing, observability, and monitoring frameworks (using dbt tests, Great Expectations, or similar tools) to ensure data trustworthiness and uptime.
• Workflow Orchestration: Schedule and monitor complex, dependency-aware data workflows using modern orchestrators (e.g., Airflow, Dagster).
• Collaboration & Enablement: Partner with Analytics Engineers, Data Scientists, and Product teams to translate complex business requirements into clean, well-documented data models. What we offer

Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.

Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!

Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.

Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.

Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.

Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!

About GlobalLogic GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.