The API Developer role at Ryan Companies is looking to solve the problem of efficient data integration and operational needs through automation, process optimization, and robust solution implementation for data migration and ETL workflows.
Requirements
- 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.
Responsibilities
- Design, develop, optimize, and maintain SQL Server Integration Services (SSIS) packages for efficient ETL workflows.
- Utilize scripting, API connectivity, error management and other ETL tools to automate data transformation, extraction, and loading processes.
- Manage and support enterprise-wide tools for data migration including managed file transfers and robotic processing (GCP, Azure, AWS)
- Collaborate with stakeholders to analyze business needs, define processes, and translate them into scalable technical solutions.
- Implement automated processes for data flow, error handling, and performance tuning across enterprise systems.
- Troubleshoot performance issues, optimize ETL pipelines, and enhance system reliability.
- Maintain clear documentation of processes, workflows, and configurations to support operational excellence and knowledge sharing.
Other
- 10+ years of experience as a Technology Systems Engineer, Data Engineer, or similar role.
- Ability to work independently and collaboratively in a fast-paced environment.
- Excellent verbal and written communication skills.
- Positions require verification of employment eligibility to work in the U.S.
