Python Data Engineer – DBT, Python, AWS, and SQL IRC295760

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

Culture of caring. At GlobalLogic, we prioritize a culture of caring. Across every region and department, at every level, we consistently put people first. From day one, you’ll experience an inclusive culture of acceptance and belonging, where you’ll have the chance to build meaningful connections with collaborative teammates, supportive managers, and compassionate leaders. 

Learning and development. We are committed to your continuous learning and development. You’ll learn and grow daily in an environment with many opportunities to try new things, sharpen your skills, and advance your career at GlobalLogic. With our Career Navigator tool as just one example, GlobalLogic offers a rich array of programs, training curricula, and hands-on opportunities to grow personally and professionally.

Interesting & meaningful work. GlobalLogic is known for engineering impact for and with clients around the world. As part of our team, you’ll have the chance to work on projects that matter. Each is a unique opportunity to engage your curiosity and creative problem-solving skills as you help clients reimagine what’s possible and bring new solutions to market. In the process, you’ll have the privilege of working on some of the most cutting-edge and impactful solutions shaping the world today.

Balance and flexibility. We believe in the importance of balance and flexibility. With many functional career areas, roles, and work arrangements, you can explore ways of achieving the perfect balance between your work and life. Your life extends beyond the office, and we always do our best to help you integrate and balance the best of work and life, having fun along the way!

High-trust organization. We are a high-trust organization where integrity is key. By joining GlobalLogic, you’re placing your trust in a safe, reliable, and ethical global company. Integrity and trust are a cornerstone of our value proposition to our employees and clients. You will find truthfulness, candor, and integrity in everything we do.

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.