Software and Data Integration Engineer

Software and Data Integration Engineer

Duration: 6 Months

Location: Columbus Ohio 43211/Hybrid

Must have 10 years of experience. Local OH Candidates highly preferred

The Ohio Department of Aging (ODA) is looking for a skilled experienced and motivated Software Data Integration Engineer to play a crucial role in enterprisescale applications and technology platforms to share data securely work seamlessly.

Complete Description:

The Ohio Department of Aging (ODA) is looking for a skilled experienced and motivated Software and Data Integration Engineer to join the team. The candidate will support State projects enterprisescale applications and technology platforms that support the personnel who serve the aging community or the aging community at large. The ideal candidate will play a crucial role in ensuring that software systems and components work seamlessly together through participation in planning coordinating developing and implementing integrations using secure and costeffective strategies and provide post deployment support to end users.

Educational Requirements:

4 years college diploma or university degree in computer science or computer engineering with advanced study preferred or equivalent technical study.

Mandatory Skills and HandsOn Experience:

10 years direct experience creating enterpriselevel integrations across diverse technical environments and crossplatform technologies both internal and external systems ensuring data quality and privacy protection.

10 years of experience designing and building web services and API protocols and schemas such as SOAP and REST JSON and data integrations.

Direct handson experience with Microsoft SQL and/or Oracle automated integration tools.

Extensive knowledge of relational database design and management techniques especially with Microsoft SQL Server and Oracle Database.

Oracle or Microsoft SQL Server experience.

10 years of .NET Web Forms.

Desired Skills

• Excellent analytical skills attention to detail and problemsolving skills.
• Proven ability to handle multiple tasks and projects simultaneously.
• Good communication skills with both technical and nontechnical clients
• Must possess excellent written and oral communication skills.
• Strong experience in creating good solutions w/o mature detailed codified business requirements.
• Working experience in delivering expected results in unstructured environments.
• Works productively and effectively independently without significant management oversight.

Responsibilities:

This position will function as a highly skilled Software and Data Integration Engineer with specific responsibilities that include:

• Integration Planning: Collaborating with development and business unit teams to gather define and analyze integration requirements and objectives translate into technical specifications and system architecture and ensure that all systems are integrated to meet business and functional requirements.
• Systems Analysis: Analyze existing systems and understand their functionalities and data structures identify integration points and dependencies between different systems.
• Troubleshooting: Investigate and resolve integration issues including debugging code and analyzing log files collaborating with other teams to address crossfunctional integration challenges.
• Collaboration and Communication: Uses excellent written and verbal communication skills to produce technical and operational documentation that explains integrations to technical and nontechnical users; Collaborates with crossfunctional teams including developers system architects business analysts and business owners to communicate progress challenges and solutions.
• Deployment and Maintenance: Oversees the deployment of integration solutions into production environments providing ongoing support and maintenance for integrated systems.
• Continuous Improvement: Stays informed about new technologies and best practices in integration proactively identifies opportunities to improve existing integrations and proposes enhancements. Encourages diversity of thought and creative problem solving.
• Middleware Development: Design and develop middleware components (APIs) to facilitate communication between systems; implement data transformation and mapping logic to ensure compatibility between different data formats; Leverage database structure and optimize data storage and retrieval processes for efficient reporting and data management.
• Coding and Scripting: Write code or scripts to implement integration solutions using programming languages (ex: Java Python C#) or integration tools to build connectors and interfaces.
• Testing and Quality Assurance: Conduct thorough testing of integration solutions to identify and resolve issues ensure that integrated systems meet performance reliability scalability and security requirements and standards.
• Troubleshooting: Investigate and resolve integration issues including debugging code and analyzing log files collaborating with other teams to address crossfunctional integration challenges.
• Collaboration and Communication: Uses excellent written and verbal communication skills to produce technical and operational documentation that explains integrations to technical and nontechnical users; Collaborates with crossfunctional teams including developers system architects business analysts and business owners to communicate progress challenges and solutions.
• Deployment and Maintenance: Oversees the deployment of integration solutions into production environments providing ongoing support and maintenance for integrated systems.
• Continuous Improvement: Stays informed about new technologies and best practices in integration proactively identifies opportunities to improve existing integrations and proposes enhancements.
• Encourages diversity of thought and creative problem solving.

Skill Required / Desired Amount of Experience

Experience in designing and building web services and API protocols and schemas such as SOAP and REST JSON and data integrations

Direct handson experience with Microsoft SQL and/or Oracle automated integration tools. Required 4 Years