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

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

• 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

• 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!

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.