Homes.com - Senior Database Engineer

Homes.com - Senior Database Engineer
Job Description
Overview
CoStar Group (NASDAQ: CSGP) is a leading global provider of commercial and residential real estate information, analytics, and online marketplaces. Included in the S&P 500 Index and the NASDAQ 100, CoStar Group is on a mission to digitize the world's real estate, empowering all people to discover properties, insights and connections that improve their businesses and lives. We have been living and breathing the world of real estate information and online marketplaces for over 35 years, giving us the perspective to create truly unique and valuable offerings to our customers. We've continually refined, transformed and perfected our approach to our business, creating a language that has become standard in our industry, for our customers, and even our competitors. We continue that effort today and are always working to improve and drive innovation. This is how we deliver for our customers, our employees, and investors. By equipping the brightest minds with the best resources available, we provide an invaluable edge in real estate.
Homes.com is already one of the fastest growing real estate portals in the industry, we are driven to be #1. Just ask Brad Bellflower, Chief Change Officer at Apartments.com. After its acquisition in 2014, Apartments.com quickly turned into the most popular place to find a place. Proven success at
the highest level - and we're doing it again with the new Homes.com. Homes.com is a CoStar Group company with 20+ years' experience in leading and growing digital marketplaces. We pride ourselves on continually improving, innovating, and setting the standard for property search and marketing experiences. With Homes.com we're building a brand on the cusp of defining the industry. We're looking for big thinkers, brave leaders, and creative advertising wizards ready to influence a new age of homebuying within a tried-and-true, award-winning company.
Learn more about Homes.com.
As part of a data company, Homes.com plays a strategic role in the design and implementation of the data that powers our consumer websites, customer portals, and countless other data products. Primary responsibilities include the design and implementation of management, reporting, portal, and other systems that support our consumer, customer, executive, sales, marketing, and research experiences. Additionally, they perform a vital role in our corporate integration projects. They will design, implement, and maintain complex database code in T-SQL and SSIS for transaction processing systems and data warehousing.
This position is located in Irvine, CA and offers a hybrid schedule of 3 days onsite, 2 days remote.
Responsibilities:

• Leverage your TSQL and SSIS skills in the development of our next generation data platforms that drives the data that is displayed on Homes.com
• Use your Data Warehouse experience to help design and develop Homes.com DW that's heavily used by internal customers for Business Intelligence, KPI monitoring, and driving Product
• Ensure systems are designed for scale and be able to test for load and analyze results
• Participate in the quality assurance on the systems we build to keep our platform accurate and reliable
• Work well in small, tight knit agile teams

Basic Qualifications

• Bachelor's Degree required from an accredited, not for profit university or college
• A track record of commitment to prior employers
• 5+ years in SQL Server development in a large-scale enterprise application environment, including:
  • Stored procedure and query development
  • Performance tuning, indexing techniques, and materialized views
  • Schema design
  • Data integration using SQL Server Integration Services or equivalent
  • Experience working with RDS, Snowflake, PostgreSQL and DynamoDB
  • SQL Server Availability Groups
  • Columnstore design, loading, and analysis
  • Replication and bulk data propagation techniques
  • SQL Server Reporting Services
  • Expert level proficiency with T-SQL
  • Advanced skills and experience with ETL concepts and SSIS
  • Advanced skills and experience with data modeling (Logical and Physical)

Preferred Qualifications
Business Intelligence and reporting experience (e.g., Spotfire) is a plus
Experience with NoSQL databases (e.g., MongoDB) is a plus
Knowledge of cloud solutions (eg., Amazon Redshift, Teradata cloud) is a plus
What's in it for You
When you join CoStar Group, you'll experience a collaborative and innovative culture working alongside the best and brightest to empower our people and customers to succeed.
We offer you generous compensation and performance-based incentives. CoStar Group also invests in your professional and academic growth with internal training, tuition reimbursement, and an inter-office exchange program.
Our benefits package includes (but is not limited to):

• Comprehensive healthcare coverage: Medical / Vision / Dental / Prescription Drug
• Life, legal, and supplementary insurance
• Virtual and in person mental health counseling services for individuals and family
• Commuter and parking benefits

• 401(K) retirement plan with matching contributions
• Employee stock purchase plan
• Paid time off
• Tuition reimbursement

• On-site fitness center and/or reimbursed fitness center membership costs (location dependent), with yoga studio, Pelotons, personal training, group exercise classes
• Access to CoStar Group's Diversity, Equity, & Inclusion Employee Resource Groups
• Complimentary gourmet coffee, tea, hot chocolate, fresh fruit, and other healthy snacks

We welcome all qualified candidates who are currently eligible to work full-time in the United States to apply. However, please note that CoStar Group is not able to provide visa sponsorship for this position.
This position offers a base salary range of $110,000.00 - 198,600.00, based on relevant skills and experience and includes a generous benefits plan.
#LI-Hybrid
#LI-VP1
CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing