Tredence Analytics - Data Build Tool Developer - SQL

<p>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).<br/><br/>This often includes using tools like different cloud tools, and requires strong SQL skills and knowledge of data warehousing concepts.<br/><br/>The role also involves ensuring data quality, performance optimization, and collaborating with cross-functional teams.<br/><br/>Role & responsibilities :<br/><br/>- Designing, building, and maintaining ETL/ELT pipelines using dbt and any cloud service expertise<br/><br/>- Creating and managing data models and transformations using dbt to ensure efficient and accurate data consumption for analytics and reporting.<br/><br/>- Developing and maintaining a data quality framework, including automated testing and cross-dataset validation.<br/><br/>- Writing and optimizing SQL queries for efficient data processing within BigQuery.<br/><br/>- Working with data engineers, analysts, scientists, and business stakeholders to deliver data solutions.<br/><br/> -Supporting day-to-day incident and ticket resolution related to data pipelines.<br/><br/>- Creating and maintaining comprehensive documentation for data pipelines, configurations, and procedures.<br/><br/>- Utilizing GCP services like BigQuery, Cloud Composer, Cloud Functions, etc.<br/><br/>- Developing and maintaining SQL/Python scripts for data ingestion, transformation, and automation tasks.<br/><br/>Preferred candidate profile :<br/><br/>Requirements :<br/><br/>- Typically requires 8~12 years of experience in data engineering or a related field.<br/><br/><b>dbt Expertise :</b><b>Proficiency in using dbt for data transformation, testing, and documentation.</b><br/><br/><b>SQL Proficiency :</b><b>Advanced SQL skills for data modeling, performance optimization, and querying large datasets.</b><br/><br/>Data Warehousing : Understanding of data warehousing concepts, dimensional modeling, and star schema design.<br/><br/>ETL/ELT : Experience with ETL/ELT tools and frameworks, including Apache Beam, Cloud Dataflow, Data Fusion, or Airflow/Composer.</p> (ref:hirist.tech)