Analytics Engineer

1 - 5 years

0 Lacs

Posted:2 days ago| Platform: Shine logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Role Overview: As an Analytics Engineer at our company, you will be responsible for building transformation layers on Google Cloud. Your main task will be to manage the ELT pipeline, ensuring the smooth transformation of raw data into analytics-ready datasets for our enterprise clients. You will primarily utilize tools such as Dataform or dbt with BigQuery to execute these tasks efficiently. Key Responsibilities: - Utilize Dataform for creating native BigQuery transformation workflows - Implement dbt-bigquery adapter for successful execution of transformation projects - Demonstrate proficiency in BigQuery SQL, including CTEs, window functions, MERGE, and scripting - Develop incremental models, snapshots, and slowly changing dimensions for effective data transformations - Implement Dataplex data quality rules and Data Catalog tagging for data governance - Utilize SQLX and JavaScript in Dataform to create reusable transformations - Implement various data modeling patterns such as staging, intermediate, and mart layers - Implement Git-based version control and CI/CD for managing transformation projects effectively Qualifications Required: - Minimum 3 years of experience in analytics/data engineering, with at least 1 year working specifically with BigQuery - Successful delivery of 2 or more Dataform or dbt projects with over 50 models in production - Strong communication skills to interact with clients effectively and provide technical documentation Note: No additional details about the company were provided in the job description. Role Overview: As an Analytics Engineer at our company, you will be responsible for building transformation layers on Google Cloud. Your main task will be to manage the ELT pipeline, ensuring the smooth transformation of raw data into analytics-ready datasets for our enterprise clients. You will primarily utilize tools such as Dataform or dbt with BigQuery to execute these tasks efficiently. Key Responsibilities: - Utilize Dataform for creating native BigQuery transformation workflows - Implement dbt-bigquery adapter for successful execution of transformation projects - Demonstrate proficiency in BigQuery SQL, including CTEs, window functions, MERGE, and scripting - Develop incremental models, snapshots, and slowly changing dimensions for effective data transformations - Implement Dataplex data quality rules and Data Catalog tagging for data governance - Utilize SQLX and JavaScript in Dataform to create reusable transformations - Implement various data modeling patterns such as staging, intermediate, and mart layers - Implement Git-based version control and CI/CD for managing transformation projects effectively Qualifications Required: - Minimum 3 years of experience in analytics/data engineering, with at least 1 year working specifically with BigQuery - Successful delivery of 2 or more Dataform or dbt projects with over 50 models in production - Strong communication skills to interact with clients effectively and provide technical documentation Note: No additional details about the company were provided in the job description.

Mock Interview

Practice Video Interview with JobPe AI

Start JavaScript Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Javascript Skills

Practice Javascript coding challenges to boost your skills

Start Practicing Javascript Now
Mastech Digital logo
Mastech Digital

Information Technology & Staffing Services

Pittsburgh

RecommendedJobs for You

bengaluru, karnataka, india