Caterpillar Inc. is looking to solve business/technical problems by developing data for reporting on Energy & Transportation (E&T) business and/or development, integration and implementation of data projects.
Requirements
- Extensive SQL development experience (typically 5+ years)
- Prior database experience
- Must be able to read and interrupt Python
- Prior experience using Snowflake
- Experience in transforming data using a visualization tool
- Experience building data models on databases
- Prior experience using SAS to read and translate ProcSQL from SAS to Procedures in Snowflake
Responsibilities
- Competent to perform all programming, project management, and development assignments without close supervision; normally assigned the more complex aspects of systems work.
- Acts as team leader for development and support groups; provides programming, database and application/technical leadership, guidance, and assistance to other team members.
- Works directly on complex application/technical problem identification and resolution.
- Works independently on complex systems or infrastructure components that may be used by one or more applications or reporting systems.
- Develops major system modules, programs or integrates new database components based on requirements gathered from our E&T partners.
- Performs integrated testing and customer acceptance testing of components that require careful planning and execution to ensure timely, quality results.
- Fully knowledgeable of the relevant programming languages, program design and specification development, programming logic, logic diagrams, system analysis techniques, testing, debugging, documentation standards, file design, storage and internal systems and cross platform infrastructure components; can provide training on these topics for others.
Other
- Requires a relevant degree, technical certification, or equivalent experience.
- Must be able to work independently
- VS Code, DevOps, and Github
- Requires the candidate to work full-time at the Peoria, IL office.
- Domestic relocation assistance is Not available for this position.
