Data Engineer

Regal Rexnord; Hyderabad; Hybrid; INR 2,800,000 - 3,800,000; Full time

Job summary

Regal Rexnord is seeking a senior Data Management & MDM architect to own and publish the enterprise MDM data model, align architecture with delivery requirements, and mentor the team.

You will design scalable data pipelines for machine learning using Spark, Delta Lake, MLflow, and Databricks, evaluate new MDM/DQ technologies, and ensure security compliance while collaborating with security and database teams in a hybrid onsite role.

Qualifications

• Bachelor’s degree in Engineering, Computer/Data Science or equivalent experience.
• 6–10 years of hands-on experience in Data Management / Development.
• 5 years of experience in data modeling using CA Erwin or Embarcadero ER Studio.
• 5 years of experience in data warehousing.
• Proficient in Python, Scala, SQL, and other programming languages.

Responsibilities

• Owns, develops and publishes enterprise MDM data model.
• Aligns technical architecture framework with requirements defined by the Delivery team.
• Provides leadership and guidance with MDM/DQ best practices, governance, standards and conventions.
• Mentors MDM Modelers and leads data modeling/quality efforts.
• Design and implement scalable data pipelines for ML using Apache Spark, Delta Lake, MLflow, and Databricks services.

Skills

MDM

Databricks

Python

Scala

SQL

Data Modeling

ETL

Data Warehousing

Git

Docker

Kubernetes

Education

Bachelor's degree in Engineering, Computer/Data Science or equivalent experience

Tools

CA Erwin

Embarcadero ER Studio

Informatica MDM

Informatica IDQ

Oracle

Unix/Linux scripting

SSIS

JAMS

Rundeck/Control-M

Tableau

Databricks

Job description

Work Model: You’ll work in a hybrid model, onsite at your designated Regal Rexnord location, with flexibility to work remotely.

____________________

Essential Responsibilities and Duties:

• Owns, develops and publishes enterprise MDM data model
• Aligns technical architecture framework with requirements defined by the Delivery team
• Provides leadership and guidance with MDM/DQ best practices, governance, standards and conventions
• Partners with security resources to ensure compliance with data security and privacy mandates
• Manages MDM and Databricks deployment lifecycle
• Design and implement scalable and reliable data pipelines for machine learning using Apache Spark, Delta Lake, MLflow, and other Databricks services
• Evaluates and recommends new and emerging MDM/DQ technologies, methodologies and standards
• Ensures consistency and compatibility with all other system technology components
• Mentors MDM Modelers and leads data modeling/quality efforts
• Conducts technical design reviews
• Education: Bachelor’s degree in Engineering, Computer/Data Science or equivalent experience Responsibilities:
• Defines the MDM data model and architecture
• Utilizes a data modeling tool to develop "blueprints" for the Conceptual Data Model of the MDM architecture
• Develops enterprise conceptual models to integrate master data from diverse data sources into conformed, high quality, and referentially sound enterprise master data model
• Establishes and governs master data modeling standards that includes naming standards, data quality indicators, data categorization, ETL attribute usage, data consistency and reuse
• Designs logical master data models using the data modeling tool for all layers in the MDM technical architecture framework
• Mitigates performance implications of various data modeling and architecture decisions at the logical and physical layer as related to ETL, ad hoc query access, and static reporting
• Reviews and validates master data models with stakeholders and subject matter experts
• Collaborates with the Integration pillar to develop master data acquisition strategies and enterprise ETL design patterns aligned with the enterprise master data models
• Collaborates with database administrators to design and implement physical master data models including performance and quality controls such as indexing strategies, referential integrity constraints, versioning, release management and partitioning
• Resolves complex technical issues as they relate to master data architecture, performance, and various tools, working closely with other technical team members
• Creates master data and process flows to graphically depict the master data architecture component
• Provides technical leadership in evaluating, prototyping and evolving the MDM framework for emerging technologies related to enterprise analytics. These technologies may include unstructured "Big Data", data grids and cloud-based computing
• Effectively communicates MDM architecture and design details to team members, including Delivery, Architecture, Integration Governance, Operations, Support and Services and other Stake Holders EXPERIENCE:
• 6 - 10 years of hands‑on experience in Data Management / Development
• 5 years of experience in data modeling using CA Erwin or Embarcadero ER Studio
• 5 years of experience in data warehousing required
• 2 years as a technical lead
• 2 years of working experience with an MDM solution
• Experience implementing a Data Vault architecture preferred
• Working understanding of Tableau or similar in memory analysis tool
• Experience with Agile development methodologies and concepts required
• Experience with the following disciplines is required: Data Warehousing, EAI, Metadata Management, MDM, Data Quality Management, Relational Databases, Dimensional Databases, Semantics, Data Lifecycle Management, SQL, PL/SQL, UML, XML
• Proficient in Python, Scala, SQL, and other programming languages
• Experience with cloud platforms such as AWS, Azure, or GCP
• Experience with Databricks or similar platforms for machine learning
• Knowledge of machine learning concepts, techniques, and best practices
• Familiarity with DevOps tools and processes such as Git, CI/CD, Docker, Kubernetes, etc.
• Common Buy‑Side MDM product data implementation experience and familiarity with procedures utilized to carry out Business Systems
• Excellent written communication and meeting facilitation skills required Key Competencies Upon entry, intermediate level of understanding in:
• Data requirements
• Data quality and compliance e.g. scorecard management
• Data management principles
• Business process management
• Data stewardship, strategy and governance
• Data factory capabilities
• Data warehousing and business intelligence support
• Mandatory Technologies Strong experience with Informatica MDM, Good experience with Informatica IDQ Developer Technologies preferred Good experience with Informatica IDQ Analyst Experience with Oracle Experience with Unix or Linux Scripting Exposure to SSIS, MDS, JAMS, and Rundeck/ Control M Behavior:
• Organized analytical thinker
• Conscious of data quality
• Good communication skills
• Good teaming skills
• Creative and innovative

About Regal Rexnord

Regal Rexnord is a publicly held global industrial manufacturer with 30,000 associates around the world who help create a better tomorrow by providing sustainable solutions that power, transmit and control motion. The Company’s electric motors and air moving subsystems provide the power to create motion. A portfolio of highly engineered power transmission components and subsystems efficiently transmits motion to power industrial applications. The Company’s automation offering, comprised of controls, actuators, drives, and precision motors, controls motion in applications ranging from factory automation to precision control in surgical tools.

The Company’s end markets benefit from meaningful secular demand tailwinds, and include factory automation, food & beverage, aerospace, medical, data center, warehouse, alternative energy, residential and commercial buildings, general industrial, construction, metals and mining, and agriculture.

Regal Rexnord is comprised of three operating segments: Industrial Powertrain Solutions, Power Efficiency Solutions, and Automation & Motion Control. Regal Rexnord has offices and manufacturing, sales and service facilities worldwide. For more information, including a copy of our Sustainability Report, visit RegalRexnord.com.