Data Modeler

• Work with the Dealer Data Strategy (DDS) team, internal Caterpillar groups, and Caterpillar dealers to identify, understand, and document use cases and business requirements for dealer, enterprise, and industry data that will deliver significant business value to the enterprise. Develop value stories and empower and coach Caterpillar and dealer leaders to tell the story of the value of data they are delivering to their business using the GD-CDM • Collaborate with Caterpillar groups, Caterpillar dealers, and third-party vendors to identify and build analytics, applications, and integrations on top of the GD-CDM that deliver significant business value. • Collaborate with the DDS team to design logical and physical data models to deliver data that will create significant business value. Work with Caterpillar counterparts to map data from the GD-CDM to the Caterpillar internal data repository. Create and maintain documentation for the data dictionary, data interfaces, data governance, dealer data flows, and more. Help build the GD-CDM knowledge repository. • Work with the DDS team, along with the Caterpillar Data Governance Office, to define, document, and implement data governance and change management standards and processes and work with dealers and Caterpillar teams to ensure all parties understand and are in alignment with those standards. Facilitate the use of a common language and understanding of the data between dealers and Caterpillar teams. • Define data best practices and governance standards including validation approaches to create, monitor, and maintain data quality. Create SQL queries, analyze the results, and review and resolve any concerns with dealers to validate the data between source and target databases to ensure data quality. Execute maturity assessments of the data quality on a defined frequency. Identify missing or incorrect data and data standards. Work at an enterprise level of interaction with responsibilities of providing data to multiple consuming systems where the actions taken must be very well defined to not impact revenue generating business activities or manage data volumes at extremely high levels where the process and quality are more complex due to the nature of the volume or data. • Work with the DDS team, along with the Caterpillar Data Governance Office, to define, document, and implement data governance and change management standards and processes and work with dealers and Caterpillar teams to ensure all parties understand and are in alignment with those standards. • Refine the data management strategy and define continuous improvement goals of data quality, governance, and processes. Provide consultation on use of data from other groups. Collaborate with the Caterpillar Data Governance team to define a single source of truth for customer, equipment, and other enterprise data. • Participate in requirements for any technical implementations or enhancements to the data management systems. Create metrics reporting on data management activities as defined. Monitor and act on any workflow requests for new, changed, or removal of data. Interact with people from multiple business areas to determine the correct actions for data changes. This may require scheduling meetings or escalating questions or concerns appropriately. Help create leadership presentations and interact with leaders in setting direction for data management needs.