ETL Developer (Information Technology)

AbacusNext is a leading technology provider for legal, accounting, and compliance-focused professionals. We empower our customers to grow their businesses, better serve their clients, and operate at peak efficiency—all within a secure, cloud-enabled ecosystem.

WHAT WE DO

We serve clients at every level of their organization, in whatever capacity we can be most useful, whether as a trusted advisor to large firm executive management or as a hands-on coach for sole practitioners. Target verticals include lawyers, general counsel, accounting firms, CPAs, government, and other private professional service organizations. For every engagement, we propose a solution tailored to meet their unique business needs and provide the utmost care in the implementation process.

No matter the challenge, we focus on delivering practical and enduring results and equipping our clients to grow and lead. We partner with clients to put solution recommendations into practice and grow their businesses through the leverage of highly secure, compliant, and functional business systems. 

This role is a remote opportunity and open to individuals in North America.

THE POSITION

Data is everywhere. Data is essential to our customers. We need their data in our systems. That's where you come in. We are currently seeking an ETL developer to design and implement ETL processes to inject customer data into our Products. You will leverage your ETL expertise to feed data from heterogeneous sources into our systems. You will use your well-polished business and communication skills to work with customers to understand their data requirements, help them make data-related decisions using your ETL knowledge and experience, and ultimately transition their application data to AbacusNext systems.

The role will require you to learn new tools and technologies fast, and you should have in-depth database knowledge as well as basic programming and scripting skills. You will help to build efficient and stable ETLs scripts and methods that can be easily re-used in the future. Your expertise in the design, creation, management and business use of large datasets will help you:

• Engage with our clients to analyze their requirements;
• Design and document solution to address these requirements;
• Evaluate the level of effort required to develop solutions;
• Develop ETL scripts per client's expectations;
• Document your work as necessary;
• Diagnose and resolve problems using debugging tools;
• Provide quality assurance testing and provide detailed technical feedback for your and/or your peers;
• Work alongside your peers in the Professional Services, Customer Success, and Sales team;
• Positively contribute to the improvement of the team's quality, efficiency, and capability;
• Follow and contribute to your teams' processes, best practices, methodologies, and guidelines.

Most importantly, you enjoy working with data; you know the devil's in the details and that's why all your t's are crossed and your i's are dotted to 100% accuracy.

Desired Skills and Experience

• Associates degree or equivalent technical experience, a Bachelor degree is preferred;
• Excellent computer skills;
• 1+ years of experience in data integrations;
• Strong experience with ETL and database technologies;
• SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure;
• Knowledge of data modeling principles;
• Knowledge of at least one ETL tool (SSIS, Informatica, Talend, etc.);
• Knowledge of various SQL/NoSQL data storage mechanisms and Big Data technologies;
• Passionate about complex data structures and problem solving;
• Ability to pick up new data tools and concepts quickly;
• Proven expertise with SaaS solutions and Cloud technologies;
• Proven expertise with scripting and programming, including SQL, shell scripting, and Python;
• Ability to adapt to a rapidly changing product and respond strategically to customer needs;
• Ability to anticipate, prevent and solve problems both scrappily and holistically;
• Ability to perform detail-oriented work, independently as well as in a group;
• Excellent communication, written skills, and analytical skills;
• Experience with a scripting language preferred.

 Ideal candidates might also possess one or more of the following

• Paralegal or equivalent legal experience;
• PostgreSQL experience;
• Experience working with APIs, including API testing tools;
• Prior programming experience.

Benefits:

• Medical, Dental, Vision, and Life Insurance
• 401k
• Flexible PTO
• Sick Days

 

Employee Perks:

• Professional and Financial Growth
• Great culture and environment
• Social, Health, and Wellness Events
• Anniversary Gifts
• Birthday Time Off
• Employee Assistance Programs
• Employee discount program through TicketsAtWork
• 15% Off Gunnar Optik Eyeware
• Employee discount to 24 Hour Fitness
• Brand new full Onsite Gym (San Diego)
• Weekly onsite masseuse and chiropractor (San Diego)
• Ocean Views, Game Room, Volleyball Court, Outdoor Zen Relaxation Area, BBQ & Patio Area, Cafeteria (San Diego)