ETL Developer

Palco is a visionary company pioneering an emerging health-care movement that empowers people with disabilities and those aging to live independent and quality lives. Made possible by our amazing team, Palco provides technology and financial services to aid individuals and their families to thrive in their home and communities. Partnered with government agencies and fortune 500 managed care organizations across the country, we are dedicated to creating exceptional outcomes for our clients and the millions of people that count on them. We are a highly organized company that offers a solid work/life balance, autonomy, generous paid time off, bonus potential, and career advancement opportunities. Our staff make long-lasting impact on the lives of people every day.

Responsibilities

The ideal candidate will be responsible for creating, enhancing, and administering ETL processes, ensuring seamless data integration across internal systems, and supporting various teams with reliable data solutions
This role is integral to the development of data-centric tools and processes and will work closely with a small, remote team
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
Proactively identify and resolve issues in data pipelines, ensuring smooth operations

Skills

2+ years of experience working with relational databases and SQL
2+ years of experience with ETL tools (e.g., Talend, SSIS, Informatica, or similar)
2+ years of experience using Excel for data manipulation and reporting
Experience with API testing tools (e.g., Postman) and working with APIs for integrations
Familiarity with BI and reporting tools (e.g., Power BI, Tableau, or similar)
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

Benefits

💼 Enjoy the convenience of working from home and maximize your time by unplugging at the end of your workday
💰 Company benefits designed for you:
- Generous Paid time off
- Quarterly/Annual bonus potential
- Retirement Savings: We will support you as you save for your future
- Career Growth Opportunities: We help you thrive, so together, we can grow
- We provide opportunities to advance your career with a vast portfolio of businesses and a global footprint
- Paid Training: Earn while you learn, and continue to grow with access to internal and external learning opportunities
- Bring your authentic self to work
- Grow and thrive, both personally and professionally
- Make a difference with our clients, in our communities, and with the millions of people we support
- Experience work/life balance
- Feel value and a greater purpose through the work you do

Qualifications

Experience working in a remote team environment
Familiarity with data governance and data quality best practices
Knowledge of cloud platforms and services (e.g., AWS, Azure, or Google Cloud)

Palco, Inc. is an Equal Employment Opportunity (EEO) employer and does not discriminate in any employer/employee relations based on race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.