Junior SQL Developer

Job Description:

Our SQL Developers receive projects and deadlines from several departments. The ability to own tasks, clearly communicate requirements, delays, completion and prioritize a constantly shifting schedule of deadlines is paramount. This work is highly critical to successfully building our company. It is the lynchpin of the sales and onboarding process. Data concerns are a blocker for most of our customers, so delivering high-quality, highly accurate transfers is absolutely crucial and greatly appreciated by both our customers and our company.

ServiceTitan is looking for an Junior (Associate) SQL Developer to join our data team. Strong candidates will have a solid command of SQL, ETL operations, strong analytical and critical thinking skills. The most critical portion of the role is deconstructing and re-interpreting databases from other software to translate them into our database. The candidate will work closely with cross-departmental resources to ensure on-time delivery of transferred data for customers' adoption of ServiceTitan.

What You'll Do:

• Develop: Create and modify TSQL ETL scripts to transform, import and maintain customer data. 

• Improve:  Enhance and maintain existing automated ETL and validation scripts.

• Data Manipulation and Analysis: Use SQL to manipulate data and generate reports that support onboarding customer data and business decisions.

• Performance Tuning: Help optimize database queries to improve performance and response times.

• Troubleshooting: Assist in troubleshooting and resolving basic database issues by understanding the business requirements.

• Documentation: Document database schemas, changes, and queries as well as prepare reports on database health and status.

• Collaboration: Work closely with senior developers and database administrators to understand and implement complex SQL queries and database schemas.

• Learning and Development: Continuously learn and apply new SQL techniques and technologies to improve database efficiency and functionality.

What You'll Bring:

• Experience:  1-2 years of experience with MS SQL Server. Advanced knowledge and experience in T-SQL and complex ETL tools

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.

• Technical Skills:  Expert level understanding of database and data model concepts. Given the experimental nature of this job, we will require very tight compliance when it comes to data - we need to focus on learning

• Analytical Skills: Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

• Problem-Solving: Ability to solve problems creatively and effectively.

• Communication Skills: Excellent verbal and written communication skills.

• Teamwork: Ability to work well in a team-oriented, collaborative environment.

Preferred Skills:

• Familiarity with programming languages such as C#, Python, Apache Spark, Java, or typescript are beneficial.

• Vertical SaaS experience is highly desirable

• Experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) is a plus.

Be Human With Us:

Being human isn’t about checking every box on a list. It’s about the experiences we have, people we meet, and the perspectives we share. So, if you have the skills but are hesitant to apply because of your background, apply anyway. We need amazing people like you to help us challenge the conventional and think differently about the problems that we’re solving. We’re in this together. Come be human, with us. 

What We Offer:

When you join our team, you’re not just accepting a job. You’re making a career move. Here’s how we’ll support you in doing some of the most impactful work of your career:

• Flextime, recognition, and support for autonomous work: Flexible time off with ample learning and development opportunities to continue growing your career. We offer a comprehensive onboarding program, leadership training for Titans at all levels, and other programs and events. Great work is rewarded through Bonusly, peer-nominated awards, and more.

• Holistic health and wellness benefits: Company-paid medical, dental, and vision (available to employees and their dependents day 1), parent and siblings’ insurance, pet insurance, wellness benefit, office massage, etc.

• Support for Titans at all stages of life: Parental leave and support, on demand maternity support through Maven Maternity, financial planning tools, Employee Assistance Program services, and more

At ServiceTitan, we celebrate individuality and uniqueness. We believe that the convergence of fresh perspectives and experiences from all walks of life is what makes our product and culture so great. We strongly encourage people from underrepresented groups to apply. We do not discriminate against employees based on race, color, religion, sex, national origin, gender identity or expression, age, disability, pregnancy (including childbirth, breastfeeding, or related medical condition), genetic information, protected military or veteran status, sexual orientation, or any other characteristic protected by applicable federal, state or local laws.