Data Engineer II - Apartments.com - Irvine, CA

We need to output only HTML fragment, no html/body tags, no markdown fences. Use

for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections if posting has real specific content. We need to parse the job description. We need to include sections: About the role (maybe description), Responsibilities, Requirements (basic qualifications), Qualifications (maybe preferred?), Skills? The instructions: Use headings for those categories. We need to decide which sections to include. We have content: job description includes overview about CoStar, Apartments.com, role description. That could be "About the role". Then "Responsibilities" list. Then "Basic Qualifications" could be "Requirements". Then "Preferred Qualifications" could be "Qualifications" or "Skills"? The instruction says use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can map: - About the role: overview paragraph(s). - Responsibilities: list of responsibilities. - Requirements: basic qualifications. - Qualifications: preferred qualifications? Or maybe "Qualifications" could be both basic and preferred? But we have separate basic and preferred. Could put basic under Requirements, preferred under Qualifications. - Skills: maybe not explicitly listed; but we could infer from qualifications? However we should not create a section if no specific content. The posting does list skills like Python, PySpark, SQL, etc. Those are in basic qualifications. Could we create a Skills section? Might be redundant. Better to not create Skills if not explicitly a separate section. The instruction: "Prefer a few substantive sections over many thin ones." So we can combine skills into Requirements or Qualifications. Probably we will not include Skills section. - Benefits: there is a "What's In It For You?" and "Our Benefits Package Includes". So we can include Benefits section. - Pay: there is base compensation range. So include Pay. - Schedule: there is schedule Monday-Thursday in office, work from home Fridays. So include Schedule. We must not repeat job title as heading. Do not put Job ID/requisition numbers as headings. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning, duplicated lines, application instructions. At end there is EEO statement etc. Remove that. We must preserve all substantive information; do not invent or summarize away detail. So we need to keep details. We need to format using

for headings,

• for any list of duties/requirements/benefits, and

  for prose. We need to ensure we don't include filler like "commensurate with experience". Not present. We need to output only HTML fragment. Let's extract content. About the role: The description before responsibilities: "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, 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 to our customers, our employees, and investors. By equipping the brightest minds with the best resources available, we provide an invaluable edge in real estate. Apartments.com is the nation’s #1 rental marketplace for owners, property managers and consumers. Apartments.com is the network that millions of renters every year rely on to find their new place, is continuing to grow our industry-leading sales force. We provide apartment Property Managers and Owners with a platform to market their property listings and the industry’s most comprehensive virtual tools to attract the most and highest-quality renters. The Apartments.com Network includes Apartments.com, ForRent.com, ApartmentFinder.com, ApartmentHomeLiving.com, and eight other leading rental sites. Our suite of services includes digital advertising, social and reputation management, and market analytic solutions which delivers innovative tools for our customers. Learn more about Apartments.com. Apartments.com is growing quickly and we’re looking for a Data Engineer II to help accelerate our growth. This role will be responsible for helping build out sitewide tracking architecture on Apartments.com and then feeding that data into user-friendly KPI dashboards which track site performance and product usage and provide day-to-day insights into consumer behavior. This individual will help build and deliver the data engineering architecture for Apartments.com and work across all departments to provide analysis and insights for future growth. You will be part of various aspects of our data management, ranging from designing and maintaining automated data infrastructure and delivering Data engineering and Analytics solutions to facilitating data access and analysis for key company teams. CoStar is investing heavily in artificial intelligence to accelerate software delivery, improve platform observability, automate research and business workflows, enhance product experiences through intelligent agents and skills, and improve data quality across enterprise systems. Successful candidates will demonstrate a willingness to learn, adopt, and apply AI technologies responsibly to solve complex business and engineering challenges. This position is located in Irvine, CA and offers a schedule of Monday to Thursday in the office and work from home on Fridays." We could split About the role into maybe two paragraphs: company overview and role specifics. But we can keep as one

  with all that text. However it's long; but okay. Responsibilities: list bullet points after "Responsibilities". Let's extract them: - Design and Oversee implementation of dimensional modeling, database design, and cloud data platform structures (e.g., Databricks, Snowflake, BigQuery) - Develop data platform framework to build secure data warehouses and data lakehouses applying principles of Medallion Architecture - Design, develop, and maintain scalable data pipelines and ETL processes using Databricks, Snowflake, and other AWS services - Implement and optimize Spark jobs, data transformations, and data processing workflows in Databricks - Building and deploying AI/ML models: Integrate Machine Learning into data pipelines, leverage Databricks ML and AWS ML to develop predictive models and drive business insights - Define and Apply AI-assisted software development practices to improve engineering productivity and code quality - Understand various data domains and be able to translate them through data transformations to suit various business needs - Oversee automated data infrastructure: Collaborate with software engineering and product teams to streamline data tracking in our products - Ability to integrate data from disparate sources via cross domain data stitch into existing data model - Implement data governance, lineage tracking, testing, and monitoring frameworks to guarantee data integrity - Hands-on data optimization and query performance - Liaise with key company teams (DBA, DevOps, SecOps…) for data accessibility and analysis - Mentor and manage engineers and analysts in the normal execution of their responsibilities. - Successfully implement software development projects to specification and within scheduled timelines and budget parameters - Leverage AWS DevOps and CI/CD best practices to automate the deployment, through terraform, and management of data pipelines and infrastructure. We need to ensure each bullet is a

• . Requirements (Basic Qualifications): list: - Bachelor's degree required from an accredited, not-for-profit, in-person college/university - A track record of commitment to prior employers - 3+ years of hands-on experience in software development, delivering high-quality solutions - Strength in Data Engineering, with strong proficiency in Python, PySpark, and SQL - Solid foundation in Object-Oriented Programming principles and best practices - Demonstrated success in building and launching data-driven products operating at terabyte scale - Proven record of designing and implementing Enterprise Level secure, and accurate Data platform - Ability to translate technical requirements into robust architecture, data models, and ETL strategies - Practical experience with cloud-based databases, including both relational and non-relational systems - Knowledge of business intelligence software (i.e. Power BI or similar tools) - Understanding of AI technologies and hands-on experience leveraging AI tooling in development (Claude Code, GitHub Copilot, Cursor, Gemini, Grok) - Ability to retrieve, synthesize, and present critical data in structures that is immediately useful to answering specific ad-hoc questions - Hands-on data experience on optimization, data quality checks, data accuracy and query performance improvement We need to keep each as
• . Qualifications (Preferred Qualifications): list: - Hands-on experience or familiarity with big data platforms such as Databricks or Snowflake - Proficiency with cloud platforms, including AWS or Azure - Experience working with NoSQL databases (e.g., DynamoDB) and object storage systems (e.g., Amazon S3, GCS, etc.) - Practical knowledge of event streaming technologies, especially Kafka - Experience leveraging AWS compute and container services for scalable solutions - Familiarity with large language models (LLMs), prompt engineering, or agent-based architectures - Great analytical and problem-solving skills, with the ability to tackle complex technical challenges - Strong Ability to understand technical challenges and complex designs, and communicate into simple business ideas, or solutions with senior management/stakeholders Note there is a typo "Strong Ability". We'll keep as is. Benefits: from "What's In It For You?" and "Our Benefits Package Includes". Let's extract: - 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 and tuition reimbursement. - 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 need to keep as list items. The introductory sentences could be prose

  before the list. But instruction: Use

  • for any list of duties/requirements/benefits, and

    for prose. So we can have a

    for the intro sentences, then

    • for the benefits list. Pay: "The final salary or hourly rate offered for this role will fall within the range set forth below based on a variety of factors, including but not limited to, geographic location, skills, and competencies. Base Compensation: $103,000-$153,000 Annually". We can put as

      . Schedule: "This position is located in Irvine, CA and offers a schedule of Monday to Thursday in the office and work from home on Fridays." Actually schedule mention appears earlier in About the role. But we can still have a Schedule section with that sentence. However we must not duplicate content. The instruction: Preserve ALL substantive information; do NOT invent or summarize away detail. If we already included schedule in About the role, we might duplicate if we also put in Schedule section. Better to not duplicate. We could either move schedule detail to Schedule section and remove from About the role, or keep in About the role and not have Schedule section. Since the instruction says include a section ONLY when the posting has real, specific content for it — never emit a heading followed by filler/placeholder text. The posting does have schedule info, so we could