Description
- Build & Maintain Pipelines: Design and deploy robust ELT/ETL pipelines using Python and SQL to ingest data from internal applications, third-party APIs, and production databases.
- Data Modeling with dbt: Architect, write, and maintain modular, well-tested dbt models to transform raw data into structured analytics layers.
- Manage Cloud Infrastructure: Leverage the AWS ecosystem to store, process, and orchestrate large-scale datasets efficiently and securely.
- Optimize Performance: Monitor and tune complex SQL queries, dbt runs, and warehouse configurations to keep compute costs down and pipeline speeds high.
- Ensure Data Quality: Implement automated testing, documentation, and data validation rules (via dbt tests or custom scripts) to catch data anomalies before they impact the business.
- Cross-Functional Collaboration: Partner with Data Analysts, Product Managers, and Software Engineers to understand data requirements and deliver optimized schemas.
Requirements
- Experience: 4+ years of professional data engineering experience in a production environment.
- Expert SQL: Mastery of advanced SQL (CTEs, window functions, complex joins) and a deep understanding of data warehousing principles (e.g., Star Schema, Kimball methodology).
- Strong Python: Proficient in writing clean, reusable Python code for data extraction, manipulation, and pipeline orchestration.
- dbt Proficiency: Hands-on experience using dbt (Core or Cloud) for managing data transformations, testing frameworks, and documentation.
- AWS Cloud Stack: Practical experience with key AWS services, such as S3, Redshift (or Snowflake/Athena on AWS), Lambda, and EC2.
- Orchestration & Tools: Familiarity with data workflow tools (like Apache Airflow, Prefect, or Dagster) and robust version control using Git.
Job responsibilities
Key Responsibilities:
- Pipeline Development: Design, build, and maintain scalable, robust ELT/ETL pipelines using Python and SQL.
- Data Modeling & Transformation: Architect and implement clean data models within our cloud data warehouse using dbt, ensuring high performance, data quality, and documentation.
- Cloud Infrastructure: Leverage AWS services to storage, process, and orchestrate large-scale datasets efficiently.
- Performance Optimization: Optimize complex SQL queries, dbt models, and data pipelines to minimize latency and cloud compute costs.
- Data Governance & Quality: Implement automated testing (via dbt tests or custom Python frameworks) to ensure data integrity, consistency, and reliability.
- Collaboration: Partner with Data Analysts, Data Scientists, and product teams to understand their data needs and deliver production-ready data structures.
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.
