prompt

Free

Act as a senior analytics engineer with this comprehensive role prompt.

FreeFree tier

Inputs: textOutputs: text

Type

Open Source

Visit Website GitHub (40 stars)

About prompt

This is a specialized prompt for an analytics engineer role, designed to guide an AI assistant in acting as a senior analytics engineer building production data pipelines and analytical systems. It defines the role as a bridge between data scientists and engineers, covering skills like data modeling, SQL mastery, pipeline architecture, data quality, cloud data warehouses, transformation frameworks (dbt, Spark SQL), monitoring, and governance. It outlines a structured process including requirements clarification, data architecture design, modeling optimization, quality assurance, and documentation. The prompt is part of the ai-boost/awesome-prompts repository on GitHub, a collection of role-specific prompts for various professional contexts. It is intended to be used with AI models like ChatGPT to generate context-aware responses for analytics engineering tasks.

Key Features

Defines analytics engineer role bridging data scientists and engineers

Covers data modeling (dimensional design, slowly-changing dimensions)

Includes SQL mastery (optimization, window functions, recursive queries)

Details pipeline architecture (batch vs streaming, idempotency, lineage)

Emphasizes data quality (schema validation, anomaly detection, dbt tests)

References cloud data warehouses (Snowflake, BigQuery, Redshift, Databricks)

Outlines transformation frameworks (dbt, Spark SQL, Dataflow)

Covers monitoring and governance (freshness, metadata, PII handling)

Provides structured process from requirements to documentation

Pros & Cons

Pros

Comprehensive and detailed role description
Covers full analytics engineering workflow
Includes specific technical skills and process steps
Open-source and freely available on GitHub
Structured for easy use with AI assistants

Cons

Single text prompt with no interactive tool or implementation
Requires an AI model to be effective (not standalone)
No visualization or hands-on features
May be too detailed for simple use cases

Best For

Using AI as an analytics engineer for data pipeline designGetting advice on dimensional modeling and star schemaWriting optimized SQL queries with CTEs and window functionsSetting up data quality tests and monitoringDesigning medallion architecture (Bronze/Silver/Gold)Documenting metrics definitions and data lineageLearning best practices for analytics engineering

FAQ

What is this prompt for?

This prompt is a specialized instruction for an AI assistant, such as ChatGPT, to act as a senior analytics engineer. It provides the AI with a detailed role description, skills, and a step-by-step process for handling analytics engineering tasks.

How should I use this prompt?

Copy the entire text and paste it at the beginning of a conversation with an AI model. Then ask your analytics engineering question. The AI will respond in the role defined by the prompt.

What topics does the prompt cover?

It covers data modeling, SQL optimization, pipeline architecture, data quality, cloud data warehouses (Snowflake, BigQuery, Redshift, Databricks), transformation frameworks (dbt, Spark SQL), monitoring, and governance.

Is this prompt free to use?

Yes, it is part of the open-source ai-boost/awesome-prompts repository on GitHub, licensed for free use.

Can I modify the prompt?

Yes, the prompt is provided as a text file in a public GitHub repository. You can fork, copy, and modify it as needed.