Johnson Controls banner

IT ServiceMax Lead Data Developer

Johnson Controls

The Role

Overview

Design, develop, and manage data integration between ServiceMax, Salesforce, and enterprise systems.

Key Responsibilities

  • data governance
  • data architecture
  • db scripts
  • data pipelines
  • data integration
  • performance monitoring

Tasks

-Ensure compliance with data governance, privacy, and security standards. -Collaborate with business stakeholders to understand data needs and provide technical solutions to enhance data quality in the ServiceMax platform. -Develop DB scripts to support specific Salesforce/ServiceMax data migration activities to meet business requirements. -Design and implement the data architecture for ServiceMax, ensuring data consistency, accuracy, and quality across systems. -Work closely with ServiceMax administrators, developers, and data analysts to align data systems with business objectives. -Implement data validation processes and ensure data integrity throughout the lifecycle of ServiceMax deployments. -Build data pipelines to support real-time and batch data processing for reporting and analytics. -Lead the design of data flows between ServiceMax, Salesforce, ERP, and other enterprise applications. -Monitor the performance of data workflows and integrations, proactively identifying bottlenecks or issues. -Manage and oversee the data integration process, ensuring that data from various sources is cleansed, transformed, and loaded correctly into the system. -Continuously optimize data processes to ensure fast, reliable access to field service data for reporting and analytics purposes. -Coordinate with IT and business teams to troubleshoot data-related issues and implement fixes in a timely manner. -Optimize and scale data workflows to handle large volumes of field service data while ensuring performance and data accuracy. -Work with cross-functional teams to define data models, sources, and transformations that support field service operations and reporting needs.

Requirements

  • servicemax
  • salesforce
  • sql
  • informatica
  • bachelor's
  • 5+ years

What You Bring

-Understanding of ServiceMax modules and how they integrate with Salesforce and other enterprise systems is a plus. -Salesforce/ServiceMax Certified Administrator is an added advantage -Any certification related to MySQL/Oracle -Bachelor’s degree in computer science, Information Systems, Engineering, or a related field. -Strong knowledge of data transformation, cleansing, and validation processes -Proficiency in programming languages like SQL along with data modelling, ETL processes -Strong experience with data integration tools (e.g., Informatica, DM Amp, Snowflake. BI tools) and APIs for connecting different systems. -Familiarity with field service management KPIs and operational reporting needs. -5+ years of experience in data activities, with a focus on Salesforce and/or ServiceMax platform. -Strong Experience with SQL and working with relational databases (e.g., MySQL, SQL Server). -Experience with advanced data processing technologies (e.g., Hadoop, Spark) or machine learning integration is a plus. -Knowledge of Agile/Scrum methodologies and tools (e.g., Jira, Confluence).

The Company

About Johnson Controls

-Pioneered the electric thermostat, launching the building controls industry. -Evolved into a global leader in smart building systems through over a century of innovation. -Typical projects range from HVAC installations to integrated smart systems in hospitals, airports, stadiums, and data centers using their OpenBlue digital platform. -Expertise covers HVAC, fire detection and suppression, security systems, energy management, and facility services. -Earned LEED Platinum certification for its North American headquarters and supplied smart systems to landmarks like Burj Khalifa and Taipei 101.

Sector Specialisms

Buildings

Commercial

Residential

Industrial

Energy

Infrastructure

Security

Safety

Fire Detection

HVAC

Controls

Smart Buildings

Sustainability

Operations

Maintenance

Repairs

System Modernisation

Carbon Reduction

Data Analytics

Facility Management