Data Analysis

Orcapod Consulting Services; Chennai; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Orcapod Consulting Services is seeking a data analytics professional to drive data-driven decisions. The role emphasizes advanced SQL, Python-based analysis, and robust BI dashboards to empower business insights.

You will work on data modeling, governance, and validation across the data platform, ensuring accurate metrics and reliable analytics for enterprise stakeholders. Collaboration with cross-functional teams is essential.

Qualifications

• Expert-level SQL with strong hands-on experience in BigQuery and PostgreSQL
• Strong Python experience for data analysis, exploration, automation, and validation
• Ability to independently perform exploratory data analysis, identify anomalies, trends, data inconsistencies, and root-cause analysis
• Hands-on BI tooling experience with Power BI or equivalent enterprise BI platform
• Dashboard design skills and KPI calculation logic
• Understanding of star schema, dimensional modeling, and analytical data models
• Experience with data catalog platforms (DataHub, GCP Dataplex) and data lineage
• Data governance: metadata management, ownership, data dictionary, and data quality rules
• Experience with GCP (BigQuery, GCS) and data orchestration (Airflow/Cloud Composer)

Responsibilities

• Collaborate with stakeholders to define and standardize metrics and KPIs
• Design and develop dashboards focused on decision-making
• Ensure data quality, lineage, and governance across analytics platforms

Job description

Data Analysis & Querying:

• Expert-level SQL with strong hands-on experience in BigQuery and/or PostgreSQL, including complex queries, window functions, joins, aggregations, query optimization, and dataset profiling.


• Strong Python experience for data analysis, exploration, automation, and validation.


• Ability to independently perform exploratory data analysis, identify anomalies, trends, data inconsistencies, and perform root-cause analysis.

Business Intelligence & Insight Generation:

Visualization & BI: Strong hands-on experience with Power BI or equivalent enterprise BI platform.

Dashboard Design: Ability to create meaningful dashboards focused on decision-making purpose.

Experience defining and standardizing business metrics, KPIs, and calculation logic.

Data Modeling & Analytics:

• Strong understanding of star schema, dimensional modeling, fact and dimension tables, normalization, denormalization, and analytical data models.


• Understanding of the journey from raw data to curated, analytics-ready datasets.

Data Governance & Trust:

• Hands-on experience with a data catalog platform such as DataHub, or GCP Dataplex, including dataset onboarding, discovery, metadata management, and ownership.


• Experience managing technical and business metadata, including dataset descriptions, ownership and data dictionary.


• Experience using automated data lineage (OpenLineage, Marquez, or BigQuery-native lineage) to perform impact analysis and investigate data-quality issues.


• Experience defining and validating data quality rules covering completeness, freshness, uniqueness, validity, consistency, and referential integrity.


• Understanding of data classification, including PII and sensitive data handling requirements.


• Working knowledge of data access governance, IAM, and role-based access concepts.

Data Platform & Technical Ecosystem:

• Strong experience with Google Cloud Platform, particularly BigQuery and GCS.


• Understanding of data ingestion, transformation, storage, and consumption patterns.


• Working knowledge of orchestration platforms such as Apache Airflow, Astronomer, or Cloud Composer, including dependencies, scheduling, failure handling, and data freshness.


• Strong understanding of how analytical datasets are produced and consumed across an enterprise data platform.

Nice to have:

• dbt for transformation documentation and lineage-as-code


• Experience with a data privacy or compliance framework such as GDPR or CCPA.


• Experience with data observability or monitoring capabilities.


• Exposure to statistical analysis, forecasting, or advanced analytics.


• Experience with AI-assisted analytics.


• Automotive, connected vehicle, vehicle telemetry, or high-volume event data domain experience.


• Experience working with streaming or near-real-time datasets.