Data Engineer- DQME Core Layer

Caterpillar•Mossville, IL

About The Position

Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it. This position is on the Connectivity Enabled Solutions Team in Connectivity Department within the CAT Technology organization. This team has accountability for: Building common datasets to support Connectivity initiatives such as Connectivity Aftermarket Programs - TCRA, ARO and NRA. Streamline reporting of data through various sources, enhancing business logic to improve data reporting, and delivering visualize data in a consistent way for internal and external business users. Building solutions to monitor and improve telematics data quality.

Requirements

Decision Making and Critical Thinking: Applies an assigned technique for critical thinking in a decision-making process. Identifies, obtains, and organizes relevant data and ideas. Participates in documenting data, ideas, players, stakeholders, and processes. Recognizes, clarifies, and prioritizes concerns. Assists in assessing risks, benefits and consideration of alternatives.
Effective Communications: Delivers helpful feedback that focuses on behaviors without offending the recipient. Listens to feedback without defensiveness and uses it for own communication effectiveness. Makes oral presentations and writes reports needed for own work. Avoids technical jargon when inappropriate. Looks for and considers non-verbal cues from individuals and groups.
Software Development: Conducts walkthroughs and monitors effectiveness and quality of the development activities. Elaborates on multiple-development toolkits for traditional and web-based software. Has participated in development of multiple or large software products. Contrasts advantages and drawbacks of different development languages and tools.
Software Development Life Cycle: Describes similarities and differences of life cycle for new product development vs. new release. Identifies common issues, problems, and considerations for each phase of the life cycle. Works with a formal life cycle methodology. Explains phases, activities, dependencies, deliverables, and key decision points. Interprets product development plans and functional documentation.
Software Integration Engineering : Has experience with designing data exchange interfaces to and from software product. Describes tools and techniques for extraction, transformation and loading of electronic data. Cites examples of common linkage requirements for software products. Works with integrating software into the customer or partner framework and infrastructure. Participates in the development of technology interfaces and bridges.
Software Product Technical Knowledge : Maintains and utilizes data related to install base configurations and environments. Solicits customer feedback; reports and monitors bugs and implementation issues. Participates in defining and conducting technical acceptance tests. Participates in creating technical requirements for software development and deployment. Explains basic environment and product configuration options.
Software Product Testing : Participates in test readiness reviews, functional, volume, and load testing. Tests software components for compliance with functional requirements and design specifications. Explains procedures for documenting test activities and results (e.g. errors, non-conformance, etc.)
A four-year degree from an accredited college or university is required.

Nice To Haves

A master's degree in computer science or a related field is preferred.
Extensive experience in designing and developing software applications in Java or Python
Proven experience in SQL, relational databases such as MySQL, PostgreSQL, Snowflake, NoSQL database, etc.
Proven experience in database design, development, and administration.
Familiarity with database replication, clustering, and high availability solutions.
Hands-on experience in data modeling, ETL processes, Data pipeline development and data warehousing
Experience with cloud-based database services, particularly within AWS, Azure, or Google Cloud environments.
Experience with unit and system level testing
Proven experience designing, building, and integrating Rest API, SOAP API
Familiarity with design patterns is essential.
Demonstrates experience with the architecture and design of major or multiple products.
Participate in design reviews and walkthroughs.

Responsibilities

Contributes to design, development, code review, and deployment.
Understanding the business requirements for new features and working with business and business analysts for gathering & refining business requirements and to recommend any changes which could do business impact.
Competent to perform all programming, project management, and development assignments without close supervision; normally assigned the more complex aspects of systems work.
Preparing the technical design documents based on the business requirements.
Design & build new features leveraging out of the box components as well as extending/customizing where necessary to meet business needs.
Works directly on complex application/technical problem identification and resolution.
Development & unit/integration testing of new features for the scrum team.
Performing Code Reviews, Performance Assessments, Architecture discussions.
For newly released features, work with the support team for addressing critical production issues in a timely fashion.
Contributes to complex systems or infrastructure components that may be used by one or more systems.
Supports application development focused around delivering valuable business features.
Identifies and encourages areas for growth and improvement within the team.