Lead Software Engineer
On-site · Chennai, Tamil Nadu, India
Job Summary
Lead Software Engineer to own and evolve Caterpillar's data platform. Design, implement, and maintain high-availability OLTP/OLAP databases; plan capacity, upgrades, backups, and disaster recovery. Build and optimize complex SQL for ETL/ELT, reporting, and services; advance data models (3NF/BCNF, star/snowflake, SCDs) and enforce standards. Drive observability and performance with indexing, partitioning, statistics, and query plans; implement RBAC/ABAC, data masking, encryption at rest/in transit, auditing, and compliance guardrails. Mentor engineers, conduct design reviews, and shape technical roadmaps; lead CI/CD for database changes and runbooks. Collaborate with Marketing, MarTech, and Analytics to translate business needs into robust data solutions; ensure data quality SLAs and lineage. Lead root-cause analysis for data incidents and champion preventive controls. Onsite five days a week in Chennai with relocation available. Postings also note experience with AWS data services, dbt, Airflow, and BI/Analytics tools as part of the broader ecosystem. For this role, the description emphasizes hands-on data engineering leadership across database design, security, performance, and governance within a marketing analytics context.
Required Qualifications
- 10+ years in software engineering or data engineering
- 5+ years focused on databases as a DBA/Database Engineer/Lead
- Expert SQL skills with track record of performance tuning (PostgreSQL, MySQL, SQL Server, Oracle, Snowflake, BigQuery)
- DBA depth: indexing/partitioning, vacuum/analyze/auto-stats, query plans, replication, backup/restore, PITR, high availability
- Data modeling mastery: normalization/denormalization tradeoffs, dimensional modeling (Kimball/Inmon), SCD types, surrogate keys, and evolution strategies
- Data quality & governance: experience with validation frameworks, constraints, lineage, and documentation; comfortable defining SLAs/SLOs for data
- Security/compliance: experience implementing least privilege, encryption, auditing, and compliance-aware design
- Leadership: proven experience mentoring engineers and leading technical initiatives end-to-end
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.