Data Engineer

Servicetitan Glendale , AZ 85301

Posted 3 months ago

ServiceTitan is looking for a Data Engineer to join our data team. Strong candidates will have solid command of the SQL, ETL operations, and SSIS packages in addition to very 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. It also includes support of existing, and development of new automated import methods. The candidate will work closely with cross departmental resources to ensure on time delivery of transferred data for customers adoption of ServiceTitan.

Our Data Engineers 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.

What you'll do

  • Map data from various legacy databases into the ServiceTitan platform, subsequently developing SQL scripts that will extract the information efficiently and accurately

  • Develop automated scripts to validate legacy database values and identify previously unmapped fields prior to loading them into the ServiceTitan platform

  • Receive and incorporate feedback from customers and internal stakeholders on data import quality into previously developed extraction scripts

  • Identify opportunities to leverage information from legacy databases into the implementation process to avoid inquiring for additional information from customers

  • Given the experimental nature of this job, we will require very tight compliance when it comes to data - we need to focus on learning

  • Establish quality working relationships with internal stakeholders

  • Contribute material input to go/no-go/continue decisions upon test completion

What you'll need

  • 2-5 years of experience with SQL Server 2008/2012/2014/2016

  • Advanced knowledge and experience in T-SQL, complex ETL tools and operations, and SSIS

  • Expert level understanding of database and data model concepts

  • Vertical SaaS experience is highly desirable

  • Results and solution oriented - we want to know how we can win, not why we can't

  • Ability to work independently and cross functionally

About ServiceTitan

ServiceTitan is a mobile, cloud-based software platform that helps home services companies streamline operations, improve customer service, and grow their business. ServiceTitan's end-to-end solution for the multi-billion dollar residential home services industry includes CRM, intelligent dispatch, custom reporting, marketing automation, mobile solution for field techs, and accounting integration with Intacct and QuickBooks. ServiceTitan brings a fully operational modern SaaS infrastructure to an industry traditionally underserved by software. ServiceTitan is the preferred software for hundreds of the world's most successful plumbing, HVAC, and electrical companies. For more information about ServiceTitan, visit

Los Angeles Business Journal Best Places to Work 2018

Inc 5000 Best Workplaces 2018

Inc 5000 America's Fastest Growing Companies 2018

Mogul Top 1000 Companies Worldwide for Millennial Women 2018

Glassdoor/Battery Ventures Cloud Computing Companies 2018

Forbes Next Billion Dollar Startup 2017

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Development Oprations Engineer

Redflex Traffic Systems

Posted Yesterday

VIEW JOBS 12/15/2018 12:00:00 AM 2019-03-15T00:00 <p>At Redflex Engineers are part of a community that design and create leading edge solutions that make our cities and our lives more green, safer and smarter.</p><p>We take a whole team approach to software quality, following Agile principles, working in a mix of Scrum, Kanban and anything else that works for us. We collaborate, we help each other, and we jump in on any task that needs doing. Our Developers are a true part of our community, helping to set priorities and solve problems, not the “development team” off in a corner.</p><p>The “advancement” you get on our team is the chance to continually learn, experiment, try new technologies and techniques, collaborate to solve business and technical problems.</p><p><br></p><p><strong><em>Please no solicitation from recruitment agencies, contractors or employees of contractors. </em></strong></p><p><strong><em>This position does not sponsor H1B visa's</em></strong><br></p><p><br></p><p><strong>Role Objectives &amp; Purpose</strong></p> <p>The Engineer (DevOps) is responsible for building and shape product excellence by ensuring applications are designed to be built and deployed continuously to maximize Redflex and customer quality satisfaction.</p><p><br></p> <p><strong>Accountabilities</strong></p> <ul> <li><strong>Understanding, implementing, and updating the Continuous Delivery Strategy</strong></li> <li><strong>Building quality in, delivering value to customers, and automating manual steps to avoid any manual intervention</strong></li> <li><strong>Collaborate with team to suggest application design to promote Continuous Delivery.</strong></li> <li><strong>Ensuring proper use of DevOps tools</strong></li> <li><strong>Scripting environment creation and promote Infrastructure as Code</strong></li> <li><strong>Working with the team to continuously improve</strong></li> <li><strong>Coaching other team members in DevOps</strong></li> <li><strong>Setup tools (eg. CloudWatch, Splunk, New Relic) to measure key metrics and alert stakeholders</strong></li> <li><strong>Ensuring the appropriate DevOps tasks are scheduled during release and sprint planning</strong></li> <li><strong>Actively collaborate with team to clarify requirements, especially in terms of design, ops requirements</strong></li> <li><strong>Participating proactively in daily stand-up meetings, story grooming sessions, team retrospectives, suggesting and implementing improvements</strong></li> </ul><p><strong>Requirements</strong></p><ul> <li><strong>8+ Years of enterprise software testing skills.</strong></li> <li><strong>Experience building and automating the deployment process</strong></li> <li><strong>BA/BS or advanced degree in Computer Science or equivalent preferred but not required.</strong></li> <li><strong>AWS certified Professional</strong></li> <li><strong>Skilled in test-driven development, test automation &amp; continuous delivery</strong></li> <li><strong>Strong technical skills demonstrated by experience with programming or scripting languages</strong></li> <li><strong>Skilled with ELK, Artifactory/Nexus, Git, Bash, Java, Ant, Maven, Bamboo/Jenkins, Docker</strong></li> <li> <strong>Familiar with DevOps tools like Cloud formation, Chef, Puppet, Ansible, Docker, Helm, Terraform</strong> </li> </ul><ul> <li><strong>In depth knowledge in networking and load balancing</strong></li> <li><strong>Promote DevOps culture</strong></li> <li><strong>Skilled in setting it up continuous delivery pipeline from scratch</strong></li> <li><strong>Comfortable in *nix environment.</strong></li> <li><strong>Understand IT Security in the Cloud and implement</strong></li> <li><strong>To show a commitment to ongoing professional development through self-learning, professional training, participation in open source projects, attending conferences etc.</strong></li> <li><strong>Skilled in setting up web servers like nginx and httpd</strong></li> </ul><p><strong>Benefits</strong></p><p>Health / Dental / Vision </p><p>401K</p><p>Vacation / Sick / Personal Day</p><p>LifeMart Employee Discount Program</p><p>EAP</p><p>Health &amp; Wellness committee</p> Redflex Traffic Systems Glendale AZ

Data Engineer