Job Title: Data EngineerExperience: 1-2 yearsWork Mode: Work from OfficeLocations: Kolkata About TredenceTredence focuses on last-mile delivery of powerful insights into profitable actions by uniting its strengths in business analytics, data science, and software engineering. The largest companies across industries are engaging with us and deploying their prediction and optimization solutions at scale. Headquartered in the San Francisco Bay Area, we serve clients in the US, Canada, Europe, and Southeast Asia.Tredence is an equal opportunity employer. We celebrate and support diversity and are committed to creating an inclusive environment for all employees.Visit our website for more details: https://www.tredence.com Role OverviewWe are seeking a driven and hands-on Data Engineer with 12 to 20 months of experience to support modern data pipeline development and transformation initiatives. The role requires solid technical skills in SQL, Cloud Warehousing, Python, and PySpark, with exposure to cloud platforms such as GCP (GCS, GCC, BQ, Dataflow), dbt (cloud).As a Data Engineer at Tredence, you will work on migrating, ingesting, processing, and modeling large-scale data, implementing scalable data pipelines / topics / procedures / orchestration workflows, and applying foundational data warehousing principles. This role also includes direct collaboration with cross-functional teams and client stakeholders.Key ResponsibilitiesDevelop robust and scalable data pipelines using PySpark in cloud platforms like GCP Databricks Dataflow.Write optimized SQL queries for data transformation, analysis, and validation.Implement and support data warehouse models and principles, including:Fact and Dimension modelingStar and Snowflake schemasSlowly Changing Dimensions (SCD)Change Data Capture (CDC)Audit TrailsData Quality RulesMedallion ArchitectureMonitor, troubleshoot, and improve pipeline performance and data quality.Work with teams across analytics, business, and IT functions to deliver data-driven solutions.Communicate technical updates and contribute to sprint-level delivery. Mandatory SkillsStrong hands-on experience with SQL and PythonWorking knowledge of PySpark for data transformationExposure to GCP (GCS, GCC, BQ, Dataflow)Exposure to dbt (cloud / core)Good understanding of data engineering and warehousing fundamentalsGood understanding of SQL strategies: merge, append, CTEsExcellent debugging and problem-solving skillsStrong written and verbal communication skillsPreferred SkillsExperience working with GCP GCC (Airflow), dbtFamiliarity with data orchestration tools like Airflow (GCC)Exposure to CI/CD processes and version control (e.g., Git)Understanding of Agile/Scrum methodology and collaborative developmentBasic knowledge of handling structured and semi-structured data (JSON, Parquet, etc.) Role: Data Science & Analytics - Other,Industry Type: IT Services & Consulting,Department: Data Science & Analytics,Employment Type: Full Time, PermanentRole Category: Data Science & Analytics - OtherEducationUG: B.Tech / B.E. in Any Specialization