Data Migration Specialist (San Diego, CA)

| San Diego, CA
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
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 an industry-leading vertical SaaS provider for the compliance-focused Professional Services market. 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 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

Organizations seeking growth rely on us to accelerate their digital transformation-whether Private cloud, Application cloud, Public cloud (SaaS), or on premise. More than 100,000 users worldwide benefit from the most complete product portfolio in the industry, including practice management and case management solutions, tailored cloud options, document automation, and payment processing. We deliver technology outcomes for our customers that help them grow, evolve, and better serve their clients.

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.

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.

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 SQL developer to design and implement ETL processes to inject customer data into our Products. We are looking for someone who is passionate about data, someone who enjoys looking and dissecting new data sets, and understanding the stories that they tell. Your main responsibility will be to leverage your SQL 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 SQL/ETL knowledge and experience, and ultimately transition their application data to AbacusNext systems.

Requirements

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;
  • Execute data assessments and migrations for customers assigned to you;
  • 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;
  • 2+ years of experience in data integrations;
  • 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

  • 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.
More Information on AbacusNext
AbacusNext operates in the Cloud industry. The company is located in San Diego, CA. AbacusNext was founded in 1983. It has 356 total employees. It offers perks and benefits such as Flexible Spending Account (FSA), Disability Insurance, Dental Benefits, Vision Benefits, Health Insurance Benefits and Life Insurance. To see all 27 open jobs at AbacusNext, click here.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Similar Jobs

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView AbacusNext's full profileFind similar jobs