Palco is seeking a Sr. ETL Developer to create, enhance, and administer ETL processes, ensuring seamless data integration across internal systems, implementation of billing processes using various EDI Tools and supporting various teams with reliable data solutions. This role is integral to the development of data-centric tools and processes.
Requirements
- 8+ years of experience working with relational databases and SQL.
- 5+ years of experience in EDI Billing implementation (270, 271, 834, 276, 277, 837 and 835) using various EDI tools.
- 8+ years of experience with ETL tools.
- 8+ years of experience using Excel for data manipulation and reporting.
- Experience with API testing tools and working with APIs for integrations.
- Familiarity with BI and reporting tools .
- Knowledge of cloud platforms and services (e.g., AWS, Azure, or Google Cloud).
Responsibilities
- Design, create, and enhance EDI processes using integration with various tools to support internal teams and business functions.
- Design, create, and enhance ETL processes to support internal teams and business functions.
- Administer and maintain the ETL ecosystem, ensuring data accuracy, integrity, and performance.
- Collaborate with key stakeholders to understand application business logic and deliver effective integration solutions.
- Generate reports and queries from various databases to support data-driven decision-making or business processes.
- Continuously improve and automate data workflows, identifying opportunities to enhance efficiency and reliability.
- Work with APIs and integration tools to facilitate data exchange between systems.
Other
- This is a fully remote, work-from-home position.
- Strong troubleshooting, problem-solving, and critical thinking skills.
- Ability to apply smart, effective solutions to unique data challenges.
- Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders.
- Experience working in a remote team environment.
