Data Architect

DATA ARCHITECT

Competent to perform all programming and provide oversight for architecture assessment and design for development assignments without close supervision; normally assigned the more complex aspects of systems work.

Lead Architecture design of end-to-end enterprise integrations that serves multiple business functions.

Design and implement end-to-end near real-time data movement solutions that provide core capabilities for the enterprise.

Define the overall data architecture strategy aligned with business goals.

Establish data governance policies, standards, and compliance Drives application development focused around delivering business valuable features

Maintains high standards of software quality within the team by establishing good practices and security guardrails per Enterprise standards.

Knowledge of target architecture; ability to develop the IT blueprint and roadmap while aligning the architecture and processes with business strategies and objectives

Develop and maintain current, planned, and future state architecture blueprints. Lead in the identification and analysis of enterprise business drivers and requirements that drive the future state architecture.

Work with business analysts, data engineers, and stakeholders. Translate business requirements into technical data solutions

Communicate with end users and stake holders to help direct development, debugging, and testing of application software for accuracy, integrity, interoperability, and completeness.

Performs integrated testing and customer acceptance testing of components that requires careful planning and execution to ensure timely, quality results.

Typical customers include Caterpillar customers, dealers, other external companies who purchase services offered by Caterpillar as well as internal business unit and/or service centre groups.The position is challenged to quickly and correctly identify problems that may not be obvious. The incumbent solves problems by determining the best architecture, within departmental guidelines, from many existing solutions.

Basic qualifications:

Four-year bachelors degree from an accredited college or university in a Computer Science or Information Technology, or related field

12+ years or more of software development experience or at least 3 years of architecture experience with strong demonstrable experience.

5+ years or more of experience in designing conceptual, logical, and physical data models & data models support scalability, performance, and integration needs.

5+ years of Data Warehousing experience & optimizing database performance, indexing, and storage strategies

Expert in implementing security measures for data at rest and in transit and defining access control, encryption, and compliance frameworks

Strong in designing data integration solutions across systems ensuring smooth data flow between applications, APIs, and data warehouses

Top candidates will also have proven experience in many of the following,

Designing, developing, deploying and maintaining software at scale, with good understanding of concurrency.

Working experience in Python as an Object-Oriented programming language

In-Depth understanding of how Data pipelines work in Big Data & expert in designing architectures for cloud-based data platforms (AWS, Azure) for large-scale processing.

Expertise and experience in building Large Data Lakes and Data Warehouse (Snowflake Preferred).

Expertise in building end-to-end near real-time data pipelines for OLTP & OLAP.

Strong architecture exposure for building robust Data Platforms

Expertise in SQL and NO-SQL databases, Message brokers and other AWS services such as Kafka/Kinesis, AWS SQS, AWS SNS, Lambda, API Gateway, DynamoDB, Aurora, AWS RDS PostgreSQL.

Test driven development and behaviour driven development.

Ability to work under pressure and within time constraints.

Passion for technology and an eagerness to contribute to a team-oriented environment.

Demonstrated leadership on medium to large-scale projects impacting strategic priorities.

Strong understanding of AI concepts and latest developments (Gen AI, MCP, ATA, etc.).

Caterpillar is an Equal Opportunity Employer (EEO).