Key Responsibilities

● Design, develop, and maintain scalable data transformation pipelines using SQL, dbt, and Jinja

templating.

● Build and optimize dimensional data models in dbt to support analytics, reporting, and BI

consumption.

● Collaborate with Product, Analytics, and BI teams to translate business requirements into robust

analytical data models.

● Perform exploratory data analysis (EDA) using SQL, Excel, and other analytical tools to validate

business requirements and uncover insights.

● Enhance and maintain analytics engineering codebases, including dbt models, macros, packages,

tests, and documentation.

● Implement data quality frameworks, automated testing, and governance-aligned transformation

logic.

● Optimize SQL workloads and analytical queries through partitioning, clustering, materialization

strategies, and performance tuning techniques.

● Ensure consistency of business metrics, semantic definitions, and data logic across dashboards

and reporting platforms.

● Apply software engineering best practices, including version control, code reviews, CI/CD

pipelines, and automated deployments.

● Participate in Agile development processes and collaborate effectively with global and offshore

teams to ensure high-quality delivery.