Homes.com - Senior Database Engineer (DynamoDB/SQL)Job DescriptionOverviewCoStar 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 realestate.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 atthe 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 aboutHomes.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.comUse 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 ProductEnsure systems are designed for scale and be able to test for load and analyze resultsParticipate in the quality assurance on the systems we build to keep our platform accurate and reliableWork well in small, tight knit agile teamsBasic QualificationsBachelor's Degree required from an accredited, not for profit university or collegeA track record of commitment to prior employers5+ years in SQL Server development in a large-scale enterprise application environment, including:Stored procedure and query developmentPerformance tuning, indexing techniques, and materialized viewsSchema designData integration using SQL Server Integration Services or equivalentExperience working with RDS, Snowflake, PostgreSQL and DynamoDBSQL Server Availability GroupsColumnstore design, loading, and analysisReplication and bulk data propagation techniquesSQL Server Reporting ServicesExpert level proficiency with T-SQLAdvanced skills and experience with ETL concepts and SSISAdvanced skills and experience with data modeling (Logical and Physical)Preferred QualificationsBusiness Intelligence and reporting experience (e.g., Spotfire) is a plusExperience with NoSQL databases (e.g., MongoDB) is a plusKnowledge of cloud solutions (eg., Amazon Redshift, Teradata cloud) is a plusWhat's in it for YouWhen 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 DrugLife, legal, and supplementary insuranceVirtual and in person mental health counseling services for individuals and familyCommuter and parking benefits401(K) retirement plan with matching contributionsEmployee stock purchase planPaid time offTuition reimbursementOn-site fitness center and/or reimbursed fitness center membership costs (location dependent), with yoga studio, Pelotons, personal training, group exercise classesAccess to CoStar Group's Diversity, Equity, & Inclusion Employee Resource GroupsComplimentary gourmet coffee, tea, hot chocolate, fresh fruit, and other healthy snacksWe 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-VP1CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing
