Database analyst/Programmer

Reuben Cooley Inc

Chillicothe, IL

JOB DETAILS
JOB TYPE
Full-time
SKILLS
Analysis Skills, Automation, C++ Programming Language, Calibration, Caterpillar Equipment, Computer Programming, Computer Science, Cross-Functional, Database Analysis, Database Programming, Documentation, Finance, Java, Maintain Compliance, Microsoft Access Database, Microsoft C# (C Sharp), Microsoft Visual Basic for Applications (VBA), Microsoft Visual Basic.NET, Object Oriented Programming (OOP), Oracle Database, Power BI, Presentation/Verbal Skills, Problem Solving Skills, Python Programming/Scripting Language, Query Optimization, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Software Engineering, Testing, Time Management, Validation Testing, Writing Skills
LOCATION
Chillicothe, IL
POSTED
30+ days ago
Required Education • Associate's degree in computer programming or a relevant field. Preferred Education: • Bachelor's degree in computer science, software engineering, or a related field. Required Skills: • Advanced Microsoft Access (Query Designer, VBA). • Strong SQL (querying, optimization). • Basic OOP (C#, C++, VB.NET, Java, or Rust). • Excel (macros, formulas for automation). Preferred Skills: • Python (scripting/automation). • Power BI (or other visualization tools). • Experience with Oracle databases. Job Responsibilities • Modify/test databases (SQL, Access) for Caterpillar's service tools (e.g., Remote Troubleshoot). • Implement calibration data and service procedures for annual software releases (A/B/C cycles). • Resolve data errors with Application Engineers and document changes. • Automate workflows (Excel macros, scripts) to reduce technical debt. • Develop/maintain internal tools (e.g., OIP Information Services). • Work with cross-functional teams (Finance, Engineers) to align data solutions with business needs. • Clarify requirements with stakeholders for ambiguous requests. • Run validation checks on configuration changes. • Ensure compliance with engineering controls. Soft Skills: • Written/verbal communication (documentation-heavy role). • Analytical problem-solving (root-cause analysis). • Independent time management.

About the Company

R

Reuben Cooley Inc