SAS/Datamart Developer

SAS; Pune District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

SAS is seeking a DMA Developer within the Business Data & Analytics team to support enterprise data assets underpinning revenue, sales, analytics, and executive reporting. The role emphasizes hands-on development, data transformation, and production support across SAS 9.x, Viya 4, and Oracle platforms.

You will partner with senior developers, analysts, and business stakeholders to ensure data accuracy, reliability, and usability in audit-sensitive environments, while contributing to improvements

Qualifications

• Proven SAS 9 and SAS Viya development in enterprise data environments.
• Experience with Oracle SQL: views, procedures, packages, performance optimization.
• Experience with production data systems and regular release cycles.

Responsibilities

• Design, develop, and maintain SAS (9 and Viya) and Oracle SQL logic for data pipelines.
• Build reporting tables aligned to KPIs and business rules.
• Develop Oracle views, packages, procedures, and validation logic.
• Support SAS ETL/ELT workflows across data sources.
• Implement data quality checks and validation controls.
• Collaborate with data engineers, analysts, and business partners.
• Maintain technical documentation and metadata.
• Operate in an Agile environment using Jira with GitHub/VS Code.

Skills

SAS

SAS Viya

Oracle SQL

Data transformation

Production support

Validation checks

Agile / Jira

GitHub

VS Code

Data pipelines

Tools

VS Code

GitHub

Jira

Job description

Data Management & Analytics Developer

Business Data & Analytics

Role Summary

We are seeking aDMA Developerto support and evolve enterprise data assets that underpin revenue, sales, analytics, and executive reporting. This role focuses onhands‑on development,data transformation, andproduction supportacross SAS (9.x & Viya 4) and Oracle platforms.

The ideal candidate is a strong individual contributor who is comfortable working inrules‑driven, audit‑sensitive environments, partnering with senior developers, analysts, and business stakeholders to ensure data accuracy, reliability, and usability.

Key Responsibilities

Data Engineering & Development

• Design, develop, and maintainSAS (9 and Viya) and Oracle SQLlogic supporting data pipelines, transformations, and curated data assets.
• Build and maintainreporting tablesaligned to defined KPIs and business rules.
• Develop and enhanceOracle views, packages, procedures, and validation logicused across analytics and downstream integrations.
• Support SAS‑based ETL/ELT workflows that integrate data from Orion, GIDB, EDW, operational systems, and external sources.

Data Quality, Validation & Audit Support

• Implementdata quality checks, reconciliation logic, and validation controlsto ensure reporting accuracy.
• Support historical traceability and reproducibility of results for finance, sales, and audit use cases.
• Diagnose and remediate data issues raised by downstream consumers (Finance, Sales Ops).

Integration & Change Management

• Adapt SAS and Oracle logic to upstream data changes from platforms such as EDW, PDH, and third‑party sources.
• Implement defensive logic when upstream data is incomplete, inconsistent, or delayed.
• Partner with senior team members during release cycles to ensure integration stability.

Production & Operational Support

• Support scheduled releases, including pre‑release validation, production troubleshooting, and post‑deployment fixes.
• Investigate job failures, performance bottlenecks, and data inconsistencies.
• Contribute to operational improvements that reduce rework, technical debt, and manual intervention.

Collaboration & Documentation

• Work closely with data engineers, analysts, and business partners to clarify requirements and data definitions.
• Maintain technical documentation, metadata, and business logic descriptions.
• Work in an Agile environment using Jira.
• UseGitHub and VS Codeto manage source control, code reviews, and collaborative development.

Required Technical Skills

• Strong experience withSAS 9 and/or SAS Viyadevelopment in enterprise data environments.
• AdvancedOracle SQLexperience, including views, procedures, packages, and performance optimization.
• Strong understanding of implementingbusiness rules in data logic.
• Experience supportingproduction data systemswith regular release cycles.
• Practical experience usingVS Code and GitHubfor source control and team development.

Preferred / Nice‑to‑Have

• Exposure torevenue, pipeline, sales credit, or financial reportingdata.
• Familiarity withaudit‑or compliance‑driven data environments.
• Experience modernizing or refactoring legacy SAS or Oracle codebases.
• Knowledge of data lineage, historical tracking, or slowly changing dimensions.
• Exposure to AI‑assisted development tools (e.g., Copilot or similar).

What Success Looks Like in This Role

• You become productive quickly in an established SAS and Oracle codebase.
• You independently own well‑defined development and support work, reducing strain on senior engineers.
• You improve data reliability, performance, and confidence without redesigning the platform.
• You collaborate effectively, ask the right questions, and deliver accurate, reliable solutions in a complex environment.

Team & Environment

• Part of theBusiness Data & Analytics (DMA)organization supporting multiple enterprise stakeholders.
• Highly collaborative team of data engineers, analysts, and business partners.
• Strong emphasis ondata accuracy, auditability, and operational reliabilitythroughout the development life cycle.