ETL Developer
Description
CARET brings the latest in technology and automation to over 10,000 legal and accounting firms, empowering highly skilled professionals to refocus their expertise on what truly matters. CARET harnesses powerful and secure practice management, document automation, and payment processing to take firms, professionals, and their clients further.
Our team-defined values guide how we show up for each other, for our partners, and for our customers:
- We succeed together
- We embrace progress
- We care big
- We create space
To join our remote-first, engage from anywhere team, visit getcaret.com/careers.
Requirements
- Associates degree or equivalent technical experience, a Bachelor degree is preferred
- Living in Canada
- 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-paced 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 candidate might also possess one or more of the following
- Paralegal or equivalent legal experience
- C# prior programming experience
Responsibilities
- 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 is in the details and that is why all your t’s are crossed, and your i’s are dotted to 100% accuracy
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: CARET is an Equal Opportunity, Affirmative Action Employer.
The compensation information below is provided in compliance with job posting disclosure requirements.
Pay range: $80,000 - $120,000. Actual base pay will depend on varying circumstances, including the position, location, individual qualifications, market finances, and other operations business needs.
Depending on the position, compensation may also include commission, bonuses, etc. Potential for bonuses is based on company performance and potential for merit increases is based on performance.
#LI-Remote
#LI-ST1
#ProductsTech