Python Data Engineer - DBT, Python, AWS, and SQL

Globallogic; Secunderabad; Hybrid; INR 1,200,000 - 2,500,000; Full time

Benefits offered by this job

Exciting Projects

Collaborative Environment

Work-Life Balance

Professional Development

Excellent Benefits

Fun Perks

Job summary

GlobalLogic Inc. is seeking a skilled Data Engineer to design, build, and scale a cloud data platform. You will create robust data pipelines and transformations using Python, SQL, and dbt, enabling analytics, dashboards, and ML workflows across the organization.

You will collaborate with analytics, product, and engineering teams to deliver clean, tested data models and reliable data assets that support data-driven decisions.

Qualifications

• Bachelor’s or Master’s degree in a technical field or equivalent practical experience.
• Proficiency in writing modular, Python data processing code.
• Expert SQL skills including window functions and complex joins.
• Experience with dbt Core or dbt Cloud.
• Strong understanding of data modeling and modern analytics engineering practices.

Responsibilities

• Architect, build, and maintain scalable batch and streaming data ingestion pipelines using Python and cloud-native services.
• Develop, test, and maintain modular data transformation models with dbt and SQL.
• Monitor, optimize, and tune cloud data warehouses (primarily BigQuery) for performance and cost.
• Establish automated data quality frameworks and documentation to ensure data accuracy and reliability.
• Implement robust orchestration DAGs (Airflow/Cloud Composer) with alerting and dependency management.
• Collaborate with data analysts, data scientists, and product engineers to translate requirements into production data assets.

Skills

Python

SQL

dbt

GCP

AWS

BigQuery

Airflow

CI/CD

Data modeling

PEP 8

Education

Bachelor’s or Master’s degree in Computer Science, Software Engineering, Information Systems, Mathematics, or a related technical discipline

Tools

dbt Core/Cloud

BigQuery

Cloud Composer

Google Cloud/AWS tooling

Job description

Description:

We are looking for a skilled Data Engineer to join our growing data team and help scale our cloud data platform. In this role, you will design, build, and optimize robust data pipelines and transformation workflows using GCP/AWS, Python, SQL, and dbt.

You will serve as the bridge between raw data sources and actionable analytics, working closely with cross-functional partners in analytics, product, and engineering. Your focus will be on delivering clean, well-tested, and performant data models that power business-critical dashboards, machine learning workflows, and data-driven decision-making across the organization.

Requirements:

4. Job Requirements

Education: Bachelor’s or Master’s degree in Computer Science, Software Engineering, Information Systems, Mathematics, or a related technical discipline (or equivalent practical experience).

Technical Proficiency:

Demonstrated proficiency in writing modular, PEP 8-compliant Python code for data processing and pipeline development.

Expert-level SQL skills (window functions, CTEs, complex joins, query plan analysis).

Direct production experience configuring and running dbt Core or dbt Cloud.

Proven track record designing dimensional models (Star schema, Snowflake schema, One Big Table approaches).

Engineering Standards: Strong grasp of software engineering fundamentals applied to data (CI/CD, code reviews, automated unit/integration testing, environment management).

Soft Skills:

Clear communication skills with the ability to explain complex technical concepts to non-technical stakeholders.

Strong problem-solving mindset and ownership of data reliability from ingestion to consumption.

Job Responsibilities:

3. Job Responsibilities

Pipeline Development & Maintenance: Architect, build, and maintain scalable, reliable batch and streaming data ingestion pipelines from diverse internal and third-party sources using Python and cloud-native services.

Data Transformation & Modeling: Develop, test, and maintain modular, version-controlled data transformation models using dbt and complex SQL, following modern analytics engineering best practices.

Data Warehouse Optimization: Monitor, fine-tune, and optimize cloud data warehouses (primarily Google BigQuery) for query speed, concurrency, storage efficiency, and cost management.

Data Quality & Governance: Establish automated data quality frameworks, testing suites, alerting mechanisms, and documentation (e.g., dbt tests, Great Expectations) to guarantee data accuracy, schema integrity, and pipeline uptime.

Orchestration & Workflow Automation: Implement and maintain robust orchestration DAGs (e.g., Apache Airflow / Cloud Composer) with proactive alerting and dependency management.

Cross-Functional Collaboration: Partner directly with data analysts, data scientists, and product engineers to translate technical and business requirements into production-ready data assets and clear data contracts.

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!