Junior ETL Developer

San Diego, California, United States

Applications have closed

AbacusNext

CARET brings the latest in technology and automation to legal and accounting firms. Explore our solutions today!

View company page

Location:: This role is remote and open to candidates nationwide in the United States.

Our Industry: Technology for Small and Medium Size Business (SMB):

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.

We provide purpose-built, cloud-based solutions for small and medium-sized Legal and Accounting firms to support a secure and cloud-enabled practice.

Our product portfolio includes case and practice management, payment processing, private cloud hosting, and document automation solutions designed to make work easier for more than 1 million global users.

Our highly differentiated cloud infrastructure puts customers’ business data and vital applications into a virtual workspace accessible anywhere, anytime, and from any device. www.abacusnext.com

Our Culture: Cutting-edge cloud technology with market needed capabilities:

We know that creativity doesn't happen on-demand. Developing cutting-edge cloud technology takes great minds and talented people working together in a collaborative environment. That is why we are committed to fostering an innovative, agile company culture. We encourage our teams to come together and experiment with new concepts, research new approaches and test out new technologies. We believe that being part of our team will make a difference in the world.

Our Mission: Technology and services for SMB customers to run their business:

To provide professionals in highly-regulated industries the technology and services they need to run their business—anytime, anywhere. We are with our customers every step of the way, helping them grow, evolve, and better serve their clients.

Your Mission:

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:

Responsibilities Include:

  • 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 is in the details and that’s why all your t’s are crossed, and your i’s are dotted to 100% accuracy

Requirements

  • Associates degree or equivalent technical experience, a Bachelor degree is preferred
  • Excellent computer skills
  • Strong experience with ETL and database technologies
  • Superior SQL knowledge (stored procedures, user defined functions, etc.) as well as an intimate understanding of database structure
  • In depth experience with MS SQL Server, incl. SQL Server Management Studio
  • Familiarity with an IDE and a version control management tool, preferably Visual Studio, Azure DevOps and Git
  • Familiarity with working in an agile SW development environment (Scrum, DevOps boards/sprints, etc.)
  • Knowledge of data modeling principles
  • Knowledge of various SQL/NoSQL data storage mechanisms
  • 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, or Python
  • Ability to adapt to a rapidly changing product and respond strategically to customer needs, and work in a fast pace environment
  • 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

Ideal candidates might also possess one or more of the following

  • Paralegal or equivalent legal experience
  • C# prior programming experience

Benefits

Benefits

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

Employee Perks:

  • Professional and Financial Growth
  • Great culture and environment
  • Social, Health, and Wellness Events (now all virtual)
  • Anniversary Gifts
  • Birthday Time Off
  • Employee Assistance Program
  • Employee discount program through TicketsAtWork
  • 15% Off Gunnar Optik Eyeware

Equal Employment Opportunity: AbacusNext is an Equal Opportunity, Affirmative Action Employer.

Tags: Agile Azure DevOps ETL Git MS SQL NoSQL Python Research Scrum SQL Testing

Perks/benefits: Career development Flex hours Flex vacation Health care Team events Wellness

Region: North America
Country: United States
Job stats:  17  7  0
Category: Engineering Jobs

More jobs like this

Explore more AI, ML, Data Science career opportunities

Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.