Data Integration Specialist

Data Integration Specialist

Job Description

COSTAR GROUP -DATA ANALYST

OVERVIEW

CoStar Group has the largest proprietary multifamily database in the US and Canada providing the most comprehensive and current rents, occupancy rates and construction activity to our subscribers. Apartments.com is the leading online apartment rental listing website, offering property, commuter, and neighborhood information for more than 1,000,000 available units nationwide. The Apartments.com network reaches millions of renters worldwide, enabling both qualified traffic and highly engaged renters. It is the fastest growing site within the residential rental industry.

The CoStar Data Integration Specialist will be responsible for gathering and interpreting data to identify opportunities for improvement in data quality, coverage, and consistency. They will need to query data sources and databases to isolate data anomalies and provide recommendations for how those anomalies should be handled. To be successful in the role, multitasking and managing multiple systems individually or as part of a team will be required. This work includes leveraging various manual performance reporting monitors to determine if an issue exists and its severity, timely reporting of events and performance statistics.

RESPONSIBILITIES

• On-board new data feeds/conversions including data analysis, data mapping, testing and implementation
• Monitor daily feeds runs, evaluate feed failures to determine root cause
• Review site for data defects and identify ways to remediate the defects before data is in production
• Work with internal/external resources to resolve feed failures
• Notify internal team of feed performance issues and failures

• Understand applications and their interdependencies
• Perform Root Cause Analysis (RCA)
• Generate datasets and identify business metrics
• Maintain consistent and standardized use of metrics across all reports and dashboards
• Utilize a user group forum to share best practices around analytical findings based on the analysis conducted

• Communicate issue statuses and challenges to management

BASICQUALIFICATIONS& EXPERIENCE

• Bachelor's degree required
• 3+ years in a Business Analyst role
• Experience using ETL tools (Informatica, MapForce)

• Proficient in MS Office tools required
• Experience with Json, XML, XSLT 1.0 and 2.0, and XSD
• Experience with SQL Server databases, preferably Microsoft SQL Server, and creating SQL queries Experience in relational database, data analysis, and performance tuning; experience testing, and maintaining reporting processes
• Effectively interface with dynamic development teams
• Understand data elements in the data warehouse at a very detailed level to support any form of user needs from research to ad-hoc queries to managing large information projects.

• Strong interpersonal skills (e.g.,Conflict Resolution, Negotiation, etc.) when dealing with internal and/or external audiences
• Excellent problem-solving skills, with a technical aptitude
• Detail-oriented with strong organizational, written, and verbal skills
• Prioritize, organize and manage multiple projects
• Take initiative and work independently and in collaboration with peers

• Desire and ability to use technology to drive creativity
• Self-motivated with a strong work ethic and a passion for learning and problem solving

PREFERRED QUALIFICATIONS & EXPERIENCE

• Demonstrated knowledge of commercial real estate

• Preference given to candidates who possess a thorough understanding of multifamily real estate, including the marketing objectives of property owners
• Ability to plan and organize workloadand deliver resultsin a fast-paced environment
• Ability to be flexible and adapt to changing situations at a high growth company

We welcome all qualified candidates who are currently eligible to work full-time in theUnitedStates to apply. However, please note that CoStar is not able to provide visa sponsorship for this position.

#LI-Hybrid

#LI-SS4

#LI-BB2

CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing