Senior Data Engineer
Rockwell Automation4 days ago
Pune, India +2 moreSenior
Responsibilities
- Design, develop, and maintain relational and canonical data models in Azure SQL Database, including tables, views, stored procedures, functions, keys, constraints, and indexes.
- Develop and optimize T-SQL code through query tuning, indexing strategies, dependency analysis, and controlled schema management.
- Design, build, test, and maintain enterprise data acquisition, integration, and transformation pipelines using Microsoft Azure PaaS services.
- Architect scalable data structures and pipelines that enable Data as a Service capabilities across business units.
- Define data contracts, database interfaces, and enterprise integration patterns with integration teams.
- Evolve the enterprise CDM/CDL platform using Azure Databricks, Delta Lake, Azure Data Lake Storage, Microsoft Fabric, Azure Data Factory, and Azure Integration Services.
- Manage CI/CD pipelines, release processes, and deployment automation using Azure DevOps and Git-based workflows.
- Support containerization and cloud deployment practices for scalable and resilient platform operations.
- Collaborate with analysts, product owners, architects, integration teams, and business stakeholders to deliver enterprise data solutions.
- Support data governance, data quality, metadata management, enterprise architecture, and platform modernization initiatives.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Engineering, or a related field, or equivalent relevant work experience.
- Strong experience with Azure SQL Database, SQL Server, T-SQL programming, relational database design, and data modeling.
- Experience designing and implementing enterprise-scale data integration and transformation solutions.
- Experience across the full software development lifecycle and Agile delivery methodologies.
- Experience with Azure DevOps, Git, CI/CD pipelines, and deployment automation.
- Strong understanding of database performance tuning, schema versioning, and platform engineering best practices.
- Ability to make architectural trade-offs and deliver scalable solutions for evolving business needs.
- Preferred: 8+ years of experience in Data Engineering, Data Platform Engineering, Software Engineering, or related disciplines.
- Preferred experience with Azure Databricks, Delta Lake, Azure Data Lake Storage, Azure Data Factory, Microsoft Fabric, and Azure Integration Services.
- Preferred experience building enterprise common data models, canonical data models, or master data solutions.
- Preferred familiarity with Data as a Service, data governance, data quality, metadata management, containerization, and cloud-native deployment architectures.
- Preferred experience translating business requirements into scalable data solutions and working in global, cross-functional enterprise teams.
- Preferred exposure to enterprise architecture frameworks and large-scale platform modernization initiatives.
Benefits
- Comprehensive mindfulness program with a premium Calm membership.
- Volunteer paid time off available after six months of employment.
- Company volunteer and donation matching program.
- Employee Assistance Program.
- Personalized wellbeing program through the OnTrack program.
- On-demand digital course library for professional development.
- Hybrid work arrangement with employees expected to work at a Rockwell location on Mondays, Tuesdays, and Thursdays unless they have an off-site business obligation.
- Additional local benefits may apply.
About Rockwell Automation
Rockwell Automation builds industrial control hardware and factory software for manufacturers, and sells services and systems to design, operate, and maintain automated plants. Its Allen-Bradley controllers, drives, and safety products pair with FactoryTalk software and MES to support discrete and process industries. Founded in 1903 and headquartered in Milwaukee, it is a public company on the NYSE (ROK) with global sales, partners, and OEM customers.