The API Developer role at Ryan Companies is focused on solving complex data integration and operational challenges through the design, development, and optimization of ETL workflows and API connectivity. The goal is to create robust, scalable, and efficient technical solutions that support data integration needs and ensure operational excellence.
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.
- Work closely with developers, database administrators, business analysts, and other IT teams to deliver integrated solutions.
- Ensure that all solutions comply with security, data governance, and compliance standards.
- Ability to work independently and collaboratively in a fast-paced environment.
- Excellent verbal and written communication skills.
