IT Software Engineer

Hi,

We have an opening for : IT Software Engineer
Work Mode: Onsite
Location: Chillicothe, IL
Work Auth: All Visas (No h1 and NO Fake Profiles)

Position Description

Required Education
• Minimum: Associate's degree in computer programming or a relevant field.
• Preferred: Bachelor's degree.
• Internship Experience: Accepted if skills can be clearly demonstrated.

Required Skills
• Snowflake Database Administration – implementing, debugging/troubleshooting/tracing, and issue resolution.
• Data Governance and Architecture – design, implementation, and documentation.
• Strong SQL – query/view authoring, troubleshooting, and performance tuning.
• Data Pipeline / ETL Development – building and maintaining pipelines and job orchestration (including cloud scheduling like AWS Lambda).
• Python – scripting and automation.
• Role-based Access Controls – administering user access and permissions.
• Version Control Systems – using Git and participating in code review processes.
• Documentation – of architecture and program specific flows.

Technical Skills (Desired)
• BI tooling – Power BI and/or Tableau.
• SAS familiarity.
• Non Snowflake source integration – DB2, Oracle, Teradata, SQL Server, NAS, SharePoint.
• Snowflake cost and storage optimization – warehouse sizing, compute/storage tuning.
• GitHub Copilot / Agentic AI experience.
• LeanIX – architecture and dependency cataloging.

Soft Skills (Required)
• Strong verbal and written communication.
• Customer service and stakeholder orientation.
• Independent time management and self direction.
• Cross team collaboration and joint planning.
• Attention to detail.

Soft Skills (Desired)
• Comfort with ambiguity during transition and modernization.
• Ownership mindset.
• Documentation and knowledge transfer discipline.
• Mentoring and peer support skills.

The main function of this role is to coordinate changes to computer databases (specifically Snowflake), test and implement database changes, and apply knowledge of database management systems. The role involves planning, coordinating, and implementing security measures to safeguard the database.

Key Responsibilities
• Test programs or databases, correct errors, and make necessary modifications.
• Modify existing databases and database management systems.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Write and code logical and physical database descriptions and specify identifiers to the management system.
• Review project requests describing user needs to estimate time and cost required to accomplish the project.
• Fill the Database Administrator (DBA) role for a small analytics team (team of 6), maintaining the intended data architecture, implementing data governance, creating and managing database objects, and documenting architecture and program specific flows.
• Own end to end user access management – triage access requests, obtain approvals/denials, communicate results, grant access, and administer role based access controls to keep users accountable and compliant.
• Serve as the Data/Product Owner for multiple analytics programs and datasets, collaborating continuously with the team to ensure consistent architecture and user experience.
• Support the Analytics team's modernization initiative, migrating from a legacy SAS central platform to a modern reporting framework.
• Coordinate, test, and implement changes to Snowflake databases, correcting errors and modifying databases/DBMS as needed.
• Author, troubleshoot, and performance tune SQL views and queries, and build/maintain data pipelines (ETL) and job orchestration (including cloud scheduling such as AWS Lambda).
• Build and improve data sets and reporting for owned programs, and support customer inquiries on available data, enhancements, and general support.
• Advise and support the data needs of Data Specialists/Scientists and report builders, and perform joint planning to avoid duplicative or conflicting outputs.
• Part of the Strategic Procurement and Planning Division (SPPD), which has re organized to highlight the importance of Data Services.
• The Digital Business Insights team is modernizing its technology stack to develop a sustainable, high velocity platform for Business Insights.
• This role is pivotal to the design, implementation, and sustainable management of that platform, which will shape the BI efforts of Supply Chain and Procurement.