Data Migration Specialist
Location: This role is remote and open to candidates nationwide in the United States and Canada.
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
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
Benefits
- Flexible PTO
- Summer Fridays
- No meeting Fridays
- Medical, Dental, Paid Sick Days, Vision, and Supplemental Coverage
- Flexible Spending Account
- Health Savings Account
- 401(k) match
Equal Employment Opportunity: AbacusNext is an Equal Opportunity, Affirmative Action Employer.
#LI-Remote
#LI-KC1