Data Build Tool(dbt) Developer with SQL/Python expertise

Role description

As a Data Build tool (DBT) senior developer you will work with team to help designing, building, and maintaining data pipelines and transformations using any cloud and the Data Build Tool (dbt).
This often includes using tools like different cloud tools, and requires strong SQL skills and knowledge of data warehousing concepts.
The role also involves ensuring data quality, performance optimization, and collaborating with cross-functional teams.

Role & responsibilities :
Designing, building, and maintaining ETL/ELT pipelines using dbt and any cloud service expertise
Creating and managing data models and transformations using dbt to ensure efficient and accurate data consumption for analytics and reporting.
Developing and maintaining a data quality framework, including automated testing and cross-dataset validation.
Writing and optimizing SQL queries for efficient data processing within BigQuery.
Working with data engineers, analysts, scientists, and business stakeholders to deliver data solutions.
Supporting day-to-day incident and ticket resolution related to data pipelines.
Creating and maintaining comprehensive documentation for data pipelines, configurations, and procedures.
Utilizing cloud services like Google/Azure/AWS/Snowflake.
Developing and maintaining SQL/Python scripts for data ingestion, transformation, and automation tasks.

Preferred candidate profile :
Requirements :
Overall requires 8~13 years of experience in data engineering or a related field.
Atleast 2+ years of relevant dbt Expertise :Proficiency in using dbt for data transformation, testing, and documentation.
SQL Proficiency :Advanced SQL skills for data modeling, performance optimization, and querying large datasets.
Data Warehousing : Understanding of data warehousing concepts, dimensional modeling, and star schema design.
ETL/ELT : Experience with ETL/ELT tools and frameworks, including Apache Beam, Cloud Dataflow, Data Fusion, or Airflow/Composer.

Skills

Years of expereince - Overall 8~13 Years of exp

Required Skills - DatabuildTool(dbt) Development (atleast 2+ Years), SQL, any cloud expertise

About Tredence
Welcome to Tredence! Since our founding in 2013, we have been dedicated to transforming data into actionable insights, helping over 50 Fortune 500 clients win in their respective industries. With our headquarters in San Jose and a presence in 5 countries, our mission is to be the world’s most indispensable analytics partner. At Tredence, we blend deep domain expertise with advanced AI and data science to drive unparalleled business value. We are excited to have you join us on this innovative journey.