
Data Engineer
Rockwell Automation2 days ago
Pune, India +2 moreSenior
Responsibilities
- Design and maintain relational and canonical data models using Azure SQL Database, including tables, views, stored procedures, functions, keys, constraints, and indexes.
- Develop performant T-SQL and optimize database performance through query tuning, indexing, dependency analysis, and schema management.
- Design, build, test, and maintain data acquisition, integration, and transformation pipelines using Microsoft Azure platform 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 Common Data Model/Common Data Layer using Azure Databricks, Delta Lake, Azure Data Lake Storage, Microsoft Fabric, Azure Data Factory, and Azure Integration Services.
- Manage Azure DevOps release processes, deployment automation, and Git-based workflows.
- Support containerization, cloud deployment, data governance, data quality, metadata management, and enterprise architecture initiatives.
- Partner with technical leads, analysts, architects, product owners, and business stakeholders to translate requirements into enterprise data solutions.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Engineering, or a related field, or equivalent relevant work experience.
- 8+ years of experience in Data Engineering, Data Platform Engineering, Software Engineering, or related disciplines.
- 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 software development lifecycle and Agile delivery methodologies.
- Experience with Azure DevOps, Git, deployment automation, and database performance tuning.
- Understanding of schema versioning, platform engineering best practices, and architectural trade-offs.
- Preferred experience with Azure Databricks, Delta Lake, Azure Data Lake Storage, Azure Data Factory, Microsoft Fabric, Azure Integration Services, common or canonical data models, master data solutions, Data as a Service, data governance, data quality, metadata management, containerization, cloud-native deployment, enterprise architecture, and large-scale platform modernization.
- Ability to work with business stakeholders, explain complex technical concepts, solve problems, and collaborate in a global enterprise environment.
Benefits
- Hybrid work arrangement with employees expected to work at a Rockwell location on Mondays, Tuesdays, and Thursdays unless business obligations require otherwise.
- Comprehensive mindfulness program with premium Calm membership.
- Volunteer paid time off available after six months of employment.
- Employee volunteer and donation matching program.
- Employee Assistance Program.
- Personalized wellbeing program through OnTrack.
- On-demand digital course library for professional development.
- Other 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.