2 months ago
Bogotá, Colombia or Monterrey, MexicoSenior

Responsibilities

  • Design, develop, maintain, and optimize scalable data pipelines integrating enterprise systems.
  • Build and optimize data models, data warehouses, data marts, and semantic layers for reporting and analytics.
  • Develop and maintain reliable ETL and ELT processes across data platforms.
  • Support scalable, performant, and maintainable cloud-based and enterprise data architectures.
  • Provide trusted datasets for Power BI dashboards, operational reports, and self-service analytics.
  • Collaborate with BI developers, analysts, IT, automation, AI, and business teams to translate requirements into data solutions.
  • Implement data quality monitoring, validation, automated controls, standards, ownership, and governance procedures.
  • Support privacy, cybersecurity, enterprise data management, and governance requirements.
  • Develop data structures and reusable governed assets for predictive analytics, automation, and AI-enabled solutions.
  • Advise stakeholders on data architecture, integration approaches, and analytics enablement opportunities.

Requirements

  • Strong experience in data engineering, data architecture, and enterprise analytics environments.
  • Advanced knowledge of SQL and relational database design.
  • Experience building and maintaining ETL and ELT pipelines.
  • Experience with Azure Data Factory, Azure Synapse, Azure Databricks, Microsoft Fabric, Dataverse, and Azure SQL.
  • Experience supporting Power BI, tabular models, and semantic data layers.
  • Understanding of API integrations, enterprise applications, and data interoperability patterns.
  • Familiarity with DevOps practices, version control, and automated deployment methods.
  • 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 is preferred.
  • Familiarity with ERP, CRM, service management, and financial systems is preferred.
  • Experience with AI, advanced analytics, or automation platforms is preferred.
  • Knowledge of Agile delivery methodologies and product-based delivery models is preferred.
  • Strong strategic thinking, collaboration, influence, analytical, troubleshooting, and stakeholder communication skills.

Benefits

  • Hybrid work arrangement with expected attendance at a Rockwell location on Mondays, Tuesdays, and Thursdays unless business obligations require working elsewhere.
  • Comprehensive mindfulness programs with a premium Calm membership.
  • Volunteer paid time off available after six months of employment for eligible employees.
  • Company volunteer and donation matching program.
  • Employee Assistance Program.
  • Personalized wellbeing programs through the OnTrack program.
  • On-demand digital course library for professional development.
  • Opportunities for talent growth across the organization.

Tech Stack

DatabricksSQL

Categories

Data Engineering
Rockwell Automation

About Rockwell Automation

10,000+ employees

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.

Contact me