Senior It Solutions Analyst – Procurement & Data

Caterpillar Caterpillar · Industrial · East Peoria, IL +1

This role focuses on delivering IT solutions for a Direct Procurement applications portfolio and an Enterprise Procurement Data Platform. The candidate will partner with stakeholders to define requirements, leverage Azure DevOps for application delivery, and use Snowflake and Power BI for data analysis and visualization. Experience with cloud solutions, SQL, and data analysis is required, with a preference for experience in AI/ML solutions using tools like AWS Bedrock or Snowflake Cortex.

What you'd actually do

  1. Partner with Procurement and cross‑functional stakeholders to define problem statements, translate business requirements into technical requirements, and deliver comprehensive IT solutions aligned with business objectives.
  2. Leverage Azure DevOps to define user stories/requirements and drive the design, development, validation and deployment of applications (both SaaS and Custom) and integrations, leveraging ETL tools, APIs, and event‑driven patterns to deliver secure, scalable, and reliable solutions.
  3. Apply strong Snowflake data analysis and Power BI data visualization or data science skills to gather requirements, perform data profiling and validation, and use data to solve business problems.
  4. Evaluate business and technical requirements to recommend solution options (build/buy/enhance) and implement secure, maintainable designs, including enhancements to existing systems and cloud migrations where appropriate.
  5. Support end‑to‑end application delivery, including configuration, development, automated testing, CI/CD deployments, defect resolution, and post‑go‑live hyper care, ensuring operational readiness.

Skills

Required

  • Bachelor’s degree in a relevant field or equivalent experience
  • Experience building and supporting cloud solutions (AWS preferred)
  • Strong SQL and data analysis skills
  • Experience with Snowflake and PowerBI
  • Demonstrated ability to translate business processes and pain points into functional requirements, data requirements, and implementable technical solutions.
  • Strong verbal and written communication skills.
  • Demonstrated people skills and a collaborative working style.
  • A proactive mindset with a willingness to learn and implement innovative technologies.
  • Oversees core application systems by managing client-related issues, system interfaces, and interdependencies.
  • Applies structured problem‑solving methods, captures lessons learned, and develops resolutions for high‑impact issues.
  • Leads requirements analysis by eliciting, documenting, modeling, and maintaining detailed functional and data requirements, including source‑to‑target mappings for integrations and reports.
  • Conducts system testing to ensure transaction flow, system interoperability, and continued alignment with requirements.
  • Performs advanced technical troubleshooting and supports IT Service Management by promoting standardized IT service procedures.

Nice to have

  • Experience with integration middleware tools (ex: Snaplogic), ETL tools, Snowflake, Power BI, Python, APIs, and strong SQL for data analysis.
  • Developed and supported custom Java services and REST APIs, deployed on AWS (e.g., container or serverless patterns), to enable scalable integrations and automate data exchange across enterprise systems.
  • Familiarity with fundamental data quality principles, procedures, and best practices.
  • Hands-on familiarity with AWS services commonly used for custom applications and data solutions and CI/CD practices.
  • Experience in data analytics and reporting—defining KPIs, building datasets, performing data quality checks, and enabling dashboards (e.g., Power BI) for business users.
  • Experience implementing AI/ML solutions using data science tools, AWS Bedrock, or Snowflake Cortex.

What the JD emphasized

  • Experience implementing AI/ML solutions using data science tools, AWS Bedrock, or Snowflake Cortex