ETL DEVELOPER II

ETL DEVELOPER II We’re Palco. We provide the management, support, and systems behind self-directed programs—the services that help people hire, pay, and manage their own caregivers with confidence. With 25+ years of experience as a national provider operating in over 17 states, we keep people at the center of everything we do. Through innovative technology and decades of expertise, we help states and partners run stronger, more compliant, and efficient programs. Our mission is to challenge the status quo and build smarter, more human-centered solutions that put power back in people’s hands. Want to learn more about joining our team? Visit www.palcofirst.com to explore opportunities. We are seeking an ETL Developer II to join our growing team. This is a fully remote, work-from-home position. 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. Duties and Responsibilities • 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. Requirements • 3+ years of experience working with relational databases and SQL. • Bachelor’s degree in Computer Science, Information Systems, or related field. • 3+ years of experience with ETL tools (e.g., Talend, SSIS, Informatica, or similar). • 3+ 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. Preferred Qualifications • Familiarity with data governance and data quality best practices. • Knowledge of cloud platforms and services (e.g., AWS, Azure, or arenaflex Cloud). Join Us • This position is remote/work-from-home role. 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. • 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. • Great Work Environment: We are proud of our company culture of collaboration and the recognition we have received for our diversity efforts. Benefits package: • Employer shared Health Insurance arenaflex • Paid Time Off • Remote work environment • Paid holidays When you join Palco, you are engaged in creating the future - both our company’s, the people we serve, and your own. We understand that our success is directly related to the success of our team. We strive to create a culture where you can: • 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. 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. Apply tot his job

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...