Data Engineer

Location: Monterrey, Nuevo Leon, Mexico, Bogota, Colombia

Remote Type: Hybrid

Time Type: Full time

Job Description

Rockwell Automation is a global technology leader focused on helping the world’s manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers - amazing companies that help feed the world, provide life-saving medicine on a global scale, and focus on clean water and green mobility - our people are energized problem solvers that take pride in how the work we do changes the world for the better.

We welcome all makers, forward thinkers, and problem solvers who are looking for a place to do their best work. And if that’s you we would love to have you join us!

Job Description

Position Summary

The LCS Data Engineer is responsible for designing, building, maintaining, and optimizing the data platforms, pipelines, and integration frameworks that power Business Intelligence, analytics, AI, and operational reporting across Lifecycle Services (LCS).

Reporting into the LCS Business Intelligence & Data Governance Manager, this role serves as a critical bridge between business stakeholders, BI developers, analysts, IT, and digital teams, ensuring that LCS data is accurate, accessible, secure, scalable, and ready to support data-driven decision making.

Your Responsibilities:

• Data Architecture & Engineering

  • Design, develop, and maintain scalable data pipelines that integrate information from ERP, CRM, service management, financial, operational, and other enterprise systems.

  • Build and optimize data models, data warehouses, data marts, and semantic layers that support reporting and analytics requirements.

  • Develop and maintain ELT/ETL processes to ensure reliable and efficient movement of data across platforms.

  • Support cloud-based and enterprise data architectures with a focus on scalability, performance, and maintainability.

  • Partner with enterprise IT teams to align LCS data solutions with corporate standards and technology roadmaps.

• Business Intelligence Enablement

  • Provide high-quality, trusted datasets for Power BI dashboards, operational reports, and self-service analytics.

  • Collaborate with BI developers and analysts to understand reporting requirements and translate them into robust data solutions.

  • Improve data availability, refresh performance, and reliability across key business intelligence platforms.

  • Support development of KPI definitions and standardized business metrics.

• Data Quality & Governance

  • Establish and maintain processes to improve data quality, consistency, integrity, and completeness.

  • Partner with business and functional leaders to define data standards, ownership, and governance procedures.

  • Implement monitoring, validation, and automated quality controls to ensure trusted business insights.

  • Support compliance with enterprise data management, privacy, cybersecurity, and governance requirements.

• AI & Advanced Analytics Readiness

  • Develop data structures that support predictive analytics, automation, and AI-enabled solutions.

  • Collaborate with IT, automation, and AI teams to ensure data readiness for emerging technologies.

  • Support creation of reusable, governed data assets that enable future Copilot, AI, and advanced analytics initiatives.

  • Drive continuous improvement of analytics infrastructure and data engineering practices.

• Stakeholder Partnership

  • Act as a technical advisor on data architecture, integration approaches, and analytics enablement opportunities.

  • Translate complex technical concepts into clear business language for non-technical audiences.

  • Contribute to strategic initiatives that increase productivity, operational visibility, and business performance.

The Essentials - You Will Have:

• Technical Expertise

  • Strong experience in data engineering, data architecture, and enterprise analytics environments.

  • Advanced knowledge of SQL and relational database design.

  • Experience building and maintaining ETL/ELT pipelines.

  • Experience with Azure Data Platform technologies such as:

    • Azure Data Factory

    • Azure Synapse

    • Azure Databricks

    • Microsoft Fabric

    • Dataverse

    • Azure SQL

  • Experience supporting Power BI, tabular models, and semantic data layers.

  • Understanding of API integrations, enterprise applications, and data interoperability patterns.

  • Familiarity with modern DevOps practices, version control, and automated deployment methods.

• Preferred Experience

  • Bachelor’s or Associate Degree in Information Technology, Computer Science, Business Administration, or a related field (completed or in the final stages of completion), or equivalent professional experience.

  • Experience supporting service, manufacturing, industrial automation, engineering, or technology organizations.

  • Familiarity with ERP, CRM, service management, and financial systems.

  • Experience with AI, advanced analytics, or automation platforms.

  • Knowledge of Agile delivery methodologies and product-based delivery models.

• Key Soft Skills

  • Strategic Thinking - Understands business priorities and designs scalable data solutions that support long-term organizational goals.

  • Collaboration & Influence - Builds strong relationships across business, IT, and leadership teams. Effectively influences decisions without direct authority.

  • Problem Solving - Demonstrates strong analytical and troubleshooting skills. Able to identify root causes and implement sustainable solutions.

• Success Measures

  • Deliver trusted, scalable data assets that support LCS reporting and analytics.

  • Improve data quality, consistency, and governance across critical business processes.

  • Increase adoption and effectiveness of BI and self-service analytics solutions.

  • Enable AI-ready and future-focused data foundations.

  • Reduce manual reporting effort through automation and modern data engineering practices.

Modality: Hybrid

What We Offer

Our benefits package includes …

• Comprehensive mindfulness programs with a premium membership to Calm.

• Volunteer Paid Time off available after 6 months of employment for eligible employees.

• Company volunteer and donation matching program – Your volunteer hours or personal cash donations to an eligible charity can be matched with a charitable donation.

• Employee Assistance Program.

• Personalized wellbeing programs through our OnTrack program

• On-demand digital course library for professional development... and other local benefits!

Rockwell Automation's hybrid policy aligns that employees are expected to work at a Rockwell location at least Mondays, Tuesdays, and Thursdays unless they have a business obligation out of the office.

We believe that employee diversity is an important element of our common future. We provide opportunities for talent growth with the entire organization. We support equality by celebrating the individuality of every person, regardless of their origin and identity. We appreciate the unique cultural pattern and variety of experiences in each of us. We invite all who want to join and change the world of Our organization.

#LI-TB1

#LI-hybri

Rockwell Automation’s hybrid policy aligns that employees are expected to work at a Rockwell location at least Mondays, Tuesdays, and Thursdays unless they have a business obligation out of the office.