Lead Database Developer - Analytics
Job Description Lead Database Developer - Analytics OVERVIEW
CoStar delivers real-time, verified commercial real estate data that helps clients confidently spot great opportunities and make smart choices ahead of competitors. By combining the power of CoStar's independent research organization - the industry's largest - with global data delivery, software, and application solutions, clients can act on opportunities with confidence.
The Analytics team is responsible for the development of CoStar's customer-facing Real Estate Analytics products. We think big, creating innovative data-intensive applications that take the vast amount of data collected by our CoStar Research teams to create a fast, reliable and intuitive analytics platform for our customers. We are a collaborative group with a mix of big data, API/platform and front-end skills, and we are growing rapidly to help invent the future of Real Estate Analytics.
We are searching for an experienced Lead Database Developer to join our team and help us build the next generation of Analytics tools at CoStar. We have the industry's largest set of Commercial Real Estate property data, which lets us create innovative products while solving challenging data engineering problems, such as high-volume data ingestion, data cleansing, real-time modeling/publication and high-performance, high-availability consumption of all this information. RESPONSIBILITIES
- Designing, building, testing and deploying scalable, reusable and maintainable applications that handle large amounts of data.
- Taking full ownership of your work, developing solutions to complex problems from concept through delivery.
- Participating in setting architectural best practices and standards for our team
- Providing high-quality technical guidance and mentoring to other team members
- Deep understanding of the design and architecture of our systems, including documentation and architectural diagrams
- Collaborating with other engineering leads (on your team and across the broader organization) on larger, shared system architectures
- Collaborating with other product team members - Engineers, QA, Product Owners, etc.
- Gaining a deep understanding of the CoStar business, including the Analytic products.
- Bachelor's degree, preferably in Computer Science/Engineering.
- 10+ 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 with:
PREFERRED QUALIFICATIONS AND SKILLS
- SQL Server Availability Groups
- Columnstore design, loading, and analysis
- Replication and bulk data propagation techniques
OVERVIEW OF COMPANY
- AWS or Azure Database Services
- Embedded Python and R scripting in SQL Server stored procedures
- Experience with Apache Spark
- Experience with data science workflow and tools ( SciKit , Numpy , Tensorflow )
Founded in 1987, CoStar Group is the leading provider of commercial real estate information, analytics, and online marketplaces. Our suite of online services enables clients to analyze, interpret and gain unmatc hed insight on commercial property values, market conditions and current availability. Behind some of the most well-known brands in the industry, CoStar Group includes CoStar, the largest provider of CRE research and real-time data; LoopNet, the most heavily trafficked mobile and online real estate marketplace; Apartments.com, the premier rental home resource for renters, property managers and owners; STR, the leading provider of performance benchmarking and comparative analytics to the hotel industry; BizBuySell , the largest online marketplace for businesses-for-sales; and Lands of America, the leading operator of online marketplaces for rural real estate.
Headquartered in Washington, DC, CoStar Group maintains offices throughout the U.S. and in Europe, Canada, and Asia with a staff of over 4,300 worldwide. WHAT'S IN IT FOR YOU
Working at CoStar Group means you'll enjoy a culture of collaboration and innovation that attracts the best and brightest across a broad range of disciplines. In addition to generous compensation and performance-based incentives, you'll be supported in both 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
- Commuter and parking benefits
- 401(K) retirement plan with matching contributions
- Employee stock purchase plan
- Paid time off
- Tuition reimbursement
- Complimentary gourmet coffee, tea, hot chocolate, prepared foods, fresh fruit, and other healthy snacks
Be part of a team of professionals enjoying the opportunity to learn, do, and grow in a rewarding atmosphere. But don't just take our word for it -- see why our team chose to work at and stay at CoStar Group: https://www.youtube.com/watch?v=CVbJRnJ2sX0
We welcome all qualified candidates who are currently eligible to work full-time in the United States to apply. However, please note that CoStar is not able to provide visa sponsorship for this position.
CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing