Analytical Engineer

Optimum Solutions; Hyderabad, Chennai District, Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Optimum Solutions is seeking a GCP & Analytical Engineer to design, develop, and support analytical data solutions on Google Cloud Platform, with a focus on BigQuery, dbt, data quality, and SOX compliance. You will implement CI/CD, manage data lineage, and drive performance improvements while ensuring data governance and security standards are met.

The role requires strong SQL, data engineering mindset, and ability to work independently while collaborating with cross-functional teams to deliver

Qualifications

• Advanced SQL and data transformation expertise with an analytics mindset.
• Strong GCPBigQuery experience is required for data modeling and optimization.
• Hands-on dbt Cloud/Core knowledge and CI/CD for analytics pipelines.
• Experience designing dimensional data models and data marts.
• Ability to trace data lineage and perform root-cause analysis.
• Experience implementing CI/CD and deployment automation.
• Knowledge of data quality frameworks and governance controls.
• Awareness of PII handling, data privacy, and security norms.
• Familiarity with Git workflows and code reviews in analytics projects.

Responsibilities

• Build and maintain scalable data models and transformation pipelines.
• Translate business requirements into technical data solutions and models.
• Develop and test data models via CI/CD and document changes.
• Ensure models serve as a single source of truth for analytics.
• Perform data quality checks, lineage tracing, and issue resolution.
• Optimize query performance and manage cloud costs in BigQuery.
• Collaborate with stakeholders and mentoring team members.

Skills

Advanced SQL and complex queries

GCP and BigQuery expertise

dbt Cloud/Core

Dimensional modeling & data marts

Data lineage & root cause analysis

CI/CD & deployment automation

Data quality monitoring & governance

PII handling & data privacy

Git / branching & merge strategies

Agile data development lifecycles

Tools

dbt Cloud

Git

Tableau (BI)

BigQuery

Job description

Location: ~BANGALORE~KOLKATA~HYDERABAD~CHENNAI~PUNE~

Exp: 6 to 8 Years

The GCP & Analytical Engineer will design, develop, and support analytical data solutions on Google Cloud Platform (GCP), with strong focus on BigQuery, dbt, data quality, compliance, and engineering best practices. The role requires expertise in SQL, analytical engineering, CI/CD, data lineage analysis, SOX compliance, risk management, and continuous improvement initiatives.

Key Skill Sets

• Design, develop, and maintain scalable analytical data models and transformation pipelines using dbt Cloud/Core.
• Develop advanced SQL queries and optimize complex workloads within GCP BigQuery.
• Build and maintain dimensional models, data marts, and trusted analytical datasets.
• Trace end-to-end data lineage and resolve data flow, transformation, and reconciliation issues.
• Implement CI/CD pipelines and manage branching, merging, rebasing, and conflict resolution using Git-based workflows.
• Support data quality frameworks, validation controls, and PII handling standards.
• Translate business requirements into scalable technical solutions and present them to technical and non-technical stakeholders.
• Drive continuous improvement initiatives to improve performance, reliability, maintainability, and developer productivity.
• Support SOX controls, audit evidence collection, change management, and compliance activities.
• Identify and mitigate operational, compliance, and data risks through proactive governance.
• Knowledge of data modelling techniques and best practices.
• Familiarity with Agile methodologies and data development lifecycles.
• Exposure to BI tools(Tableau, etc) for understanding user needs.
• Performance tuning and knowledge of cost optimization in cloud.
• Ownership and accountability for deliveries
• Ability to work independently.
• Contributions to internal communities, forums or external meetups.
• Experience mentoring others.

Required Technical Skills

• Advanced SQL and complex query writing.
• Strong experience with Google Cloud Platform (GCP) and BigQuery.
• Strong dbt Cloud and dbt Core expertise.
• Dimensional data modeling and data mart design experience.
• Data lineage, root cause analysis, and data flow troubleshooting.
• Configuration management, Git, branching strategies, merging, conflict resolution, and rebasing.
• CI/CD pipeline implementation and deployment automation.
• Data quality monitoring, testing frameworks, and governance controls.
• Knowledge of PII handling, data privacy, and security standards.

Responsibilities

• Build and Maintain HighQuality Data Models.
  • Design and implement scalable business-layer models, marts, and OBTs used by the organization.
  • Choose correct modelling techniques (dimensional, OBT, etc.) based on business needs.
  • Ensure models serve as a reliable single source of truth.
• Own EndtoEnd Development Lifecycle.
  • Translate business requirements into technical solutions.
  • Develop, test, document, and deploy data models through CI/CD.
  • Follow softwareengineering standards for analytics code.
• Ensure Coding Standards and Best Practices.
  • Apply and enforce coding standards for SQL and DBT cloud.
  • Conduct quality code reviews focusing on logic, consistency, and documentation.
  • Produce clean, well-structured, maintainable code.
• Data Quality, PII Handling & Testing.
  • Add generic and custom tests to ensure accuracy of transformed data.
  • Handle PII safely (masking, hashing, accesscontrol).
  • Treat data quality issues as critical defects, not afterthoughts.
• Diagnose and Resolve Data Issues:
  • Investigate discrepancies across source transformation BI layers.
  • Debug failures and pipeline breaks using compiled SQL and lineage.
  • Work independently until issues are resolved.
• Improve and Optimize the Codebase:
  • Identify refactoring opportunities for older or inefficient models.
  • Optimize query performance and cost using Big Query tools.

SOX Compliance, Risk & Governance

• Ensure compliance with SOX controls, audit requirements, and internal governance standards.
• Maintain evidence for changes, approvals, deployments, and access reviews.
• Identify risks and drive remediation actions to improve operational resilience and compliance posture.