Senior IT Analyst

Career Area:

Job Description:

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.

What does it mean to live the Caterpillar Experience?

It means you play a part in building a better world. You contribute to a winning culture—a spirit of accountability—that has driven change on every continent for more than 90 years. To work with us is a commitment to improve sustainability, invent for the digital age and innovate in order to bring solutions to millions of people. Sure, you work for Caterpillar.

But more importantly, you work for the good of your career, your family, your community, and your world.

Job Summary:

This position works directly with application architects to tune infrastructure performance, review and execute architecture changes, and maintain data quality through export, ETL, and data modeling standards.

What You Will Do:

• Daily monitoring of Production Databases (Oracle Enterprise Manager) and Oracle infrastructure / OS level (Nagios, etc)

• Identification and optimization of long running queries

• Analysis of Journal Logs utilizing Siemens Journal Workbench

• Collaboration with Architects/Support on changes

  • Review prior to making changes

  • Tracking of impact to ongoing production performance metrics post changes

• Tuning / Engagement for development environments

• Development and optimization of custom python scripts to ingest data into Snowflake

• Data modeling and data transformation using SQL inside of Snowflake

• Lead an agency staff to execute data lake projects using engineering and compliance data

What You Have:

• Core Application Systems: Knowledge of major production application systems used for delivery of services to internal and external clients; ability to leverage major production application systems in diverse situations.

  • Level Extensive
    
    Experience:

    • Manages application-related issues, implications, and approaches with clients.

    • Evaluates key interfaces and interdependencies among core applications systems.

    • Explains features and benefits of core applications for consideration by business units.

    • Implements existing and planned application enhancements in major business units.

    • Tracks data flow between own applications and core applications in other business areas.

    • Plans enhancement, conversion, and retirement strategies for core applications.

• Problem Solving: Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply knowledge of problem solving appropriately to diverse situations.

  • Level Extensive
    
    Experience:

    • Ensures capture of lessons to be learned from a problem-solving effort.

    • Organizes potential problem solvers and leads problem resolution efforts.

    • Uses varying problem-solving approaches and techniques as appropriate.

    • Contributes to standard practices for problem-solving approaches, tools, and processes.

    • • Analyzes and synthesizes information and devises alternative resolution strategies.

    • Develops successful resolutions to critical or wide-impact problems.

• Application Design, Architecture: Knowledge of basic activities and deliverables of application design; ability to utilize application design methodologies, tools and techniques to convert business requirements and logical models into a technical application design.

  • Level Extensive
    
    Experience:

    • Facilitates application design reviews and walkthroughs.

    • Creates and evaluates technical alternatives for complex applications.

    • Interprets application services such as API; integrates them with technical design.

    • Develops various, distinct and multiple technical application designs.

    • Prepares technical design documents and blueprints for applications.

    • Explores and evaluates application design considerations for multiple technologies.

• System…