SQL Developer - Accounting

November 26, 2024

Apply Now

Receive Emails with Similar Jobs

ServiceTitan

WebsiteLinkedInAll Job Openings

SaaS • Mobile • FinTech

1001 - 5000 employees

Founded 2012

☁️ SaaS

⚡ Productivity

🏢 Enterprise

Description

• Develop: Create and modify custom reports being conscious of GAAP. • Improve: Enhance and maintain existing automated custom reports to ensure they’re GAAP compliant. • 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 reports, changes, and queries as well as prepare reports on utilization. • 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.

Requirements

• 1-2 years of experience with MS SQL Server • Advanced knowledge and experience in T-SQL and complex ETL tools • Advanced knowledge of GAAP • Expert level understanding of database and data model concepts • Bachelor’s degree in Computer Science, Information Technology, Accounting or a related field. • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. • Ability to solve problems creatively and effectively. • Excellent verbal and written communication skills. • Ability to work well in a team-oriented, collaborative environment. • Familiarity with programming languages such as C#, Python, Apache Spark, Java, or TypeScript are beneficial. • Construction Accounting experience is highly desirable. • Vertical SaaS experience is highly desirable. • Experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) is a plus.

Benefits

• Flexible time off with ample learning and development opportunities to continue growing your career. • 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. • Company-paid medical, dental, and vision (with 100% employer paid options and 90% coverage for dependents), FSA and HSA, 401k match, and telehealth options including memberships to Headspace, Galileo, One Medical, Ginger and more. • Parental leave and support, up to $20k in adoption reimbursement, on demand maternity support through Maven Maternity, free breast milk shipping through Maven Milk, pet insurance, legal advisory services, financial planning tools, and more.