Data Integration Engineer

Job Description:

The Data Integration Engineer will have a strong background in ETL development, automation, and process optimization, with expertise in SSIS creation and troubleshooting, API connectivity, Error notification management, process definition and solution implementation. The Senior Technology System Engineer must be a problem-solver who can analyze complex systems, design efficient workflows, and implement robust solutions to support data integration and operational needs as well as mentor and guide others towards designing sustainable technology solutions.

Some things you can expect to do:

• SSIS and API Development & Troubleshooting: Design, develop, optimize, and maintain SQL Server Integration Services (SSIS) packages for efficient ETL workflows.

• ETL & Scripting: Utilize scripting, API connectivity, error management and other ETL tools to automate data transformation, extraction, and loading processes.

• Data migration Engineering: Manage and support enterprise-wide tools for data migration including managed file transfers and robotic processing (GCP, Azure, AWS)

• Process Definition & Solution Engineering: Collaborate with stakeholders to analyze business needs, define processes, and translate them into scalable technical solutions.

• Data Integration & Workflow Automation: Implement automated processes for data flow, error handling, and performance tuning across enterprise systems.

• System Performance & Optimization: Troubleshoot performance issues, optimize ETL pipelines, and enhance system reliability.

• Technical Documentation: Maintain clear documentation of processes, workflows, and configurations to support operational excellence and knowledge sharing.

• Cross-functional Collaboration: Work closely with developers, database administrators, business analysts, and other IT teams to deliver integrated solutions.

• Security & Compliance: Ensure that all solutions comply with security, data governance, and compliance standards.

To be successful in this role you must have:

• 10 years of experience as a Technology Systems Engineer, Data Engineer, or similar role.

• Demonstrative proficiency in SSIS development, API connectivity, and other scripting languages for automation and ETL processing (onprem and cloud).

• Strong experience with connecting external and internal data sources to create a holistic integration (GCP, Azure)

• Experience with enterprise managed file transfer solutions and robotic processing technologies (UIPath, GoAnywhere, etc.).

• Strong expertise in building process definitions from incomplete requirements and translating them into scalable technology solutions.

• Strong analytical, problem-solving, and debugging skills across infrastructure and application technology stacks.

• Familiarity with enterprise data architecture and integration patterns.

• Experience with monitoring tools and logging frameworks for system health tracking.

• Knowledge of CI/CD pipelines, ITSM and DevOps practices including source control management.

• *Ability to work independently and collaboratively in a fast-paced environment.

• *Excellent verbal and written communication skills.

Compensation:

The base pay range is $91,800-$137,600/Annually. The salary may vary within the anticipated range based on factors such as the ultimate location of the position and the selected candidate's knowledge, skills, and abilities. Position may be eligible for additional compensation that may include commission and/or an incentive program.

Eligibility:

• Positions require verification of employment eligibility to work in the U.S.

Ryan Companies is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Non-Solicitation Notice to Recruitment Agencies:

Ryan Companies kindly requests that recruitment agencies and third-party recruiters do not submit unsolicited resumes or candidate information to any Ryan Companies employee or office. Ryan Companies will not be responsible for any fees or expenses associated with unsolicited submissions. If recruitment services are required, we will reach out directly to agencies on our approved vendor list. We appreciate your understanding and cooperation.