Data Analyst, Metrics & Reporting

We need to produce HTML fragment with sections: About the role? Actually we need to use headings for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We must only include sections that have real specific content. The posting includes a job summary, description of role, responsibilities, qualifications, benefits, pay. No schedule info. So we can have sections: About the role (maybe from "THE ROLE" and "What This Role Will Do" etc). Responsibilities (list of duties). Requirements (maybe "What This Person Will Bring" includes experience, skills). Qualifications (maybe "Strongly Desired Qualifications"). Skills (maybe combine). Benefits (Benefits & Perks). Pay (Expected Compensation). No schedule. We must not repeat job title as heading. No Job ID. Remove boilerplate like EEO, etc. Also remove navigation, cookie, legal, etc. Also remove application instructions (none). Also remove duplicated lines. We need to preserve all substantive information. So we need to extract content. Let's parse the posting: - Intro: WHO ARE WE? description of Live Nation Entertainment. That's company overview, maybe part of About the role? Could be included in About the role section. - WHO ARE YOU? description of candidate traits. Could be part of About the role or maybe not needed? It's substantive but could be part of About the role. - THE ROLE: description. - What This Role Will Do: bullet list of duties. - What This Person Will Bring: qualifications/experience. - Strongly Desired Qualifications: list. - What Success In This Role Looks Like: maybe could be part of Responsibilities or separate? Could be considered as performance expectations; maybe we can include under Responsibilities or a separate section like "Success Metrics". But we only have allowed headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We could map: About the role: includes company overview, WHO ARE YOU?, THE ROLE description. Responsibilities: the bullet list under "What This Role Will Do". Requirements: maybe "What This Person Will Bring" (2-4 years experience, SQL, etc.) could be Requirements. Qualifications: "Strongly Desired Qualifications". Skills: maybe combine some skill specifics? Could be part of Requirements. But we can also have Skills section listing specific skills: SQL, Tableau, Power BI, Excel, etc. However we must not invent sections without content. We have content for skills: "Working knowledge of SQL... Experience building dashboards or reports in Tableau, Power BI, Domo, Looker, or a similar BI platform. Strong Excel skills...". That's skill content. Could be placed under Skills. Benefits: Benefits & Perks section. Pay: Expected Compensation. Schedule: none, so omit. We must not include headings with filler like "commensurate with experience". Not present. We need to output only HTML fragment, using

for section headings,

• for lists,

  for prose. We must preserve all substantive information; do not invent or summarize away detail. So we need to keep the details as they appear, but we can reformat into HTML. We need to be careful not to omit any details. Let's extract each piece. Company overview (WHO ARE WE?): "Live Nation Entertainment is the world’s leading live entertainment company, comprised of global market leaders: Ticketmaster, Live Nation Concerts, and Live Nation Media & Sponsorship. Ticketmaster is the global leader in event ticketing with over 620 million tickets sold annually and approximately 10,000 clients worldwide. Live Nation Concerts is the largest provider of live entertainment in the world promoting more than 50,000 events annually for nearly 7,000 artists in 40+ countries. These businesses allow Live Nation Media & Sponsorship to create strategic music marketing programs that connect more than 1,200 sponsors with the 145 million fans that attend Live Nation Entertainment events each year. For additional information, visit www.livenationentertainment.com." We need to keep that. WHO ARE YOU?: "Passionate and motivated. Driven, with an entrepreneurial spirit. Resourceful, innovative, forward thinking and committed. At Live Nation Entertainment, our people embrace these qualities, so if this sounds like you then please read on! You're early in your analytics career, but you bring strong curiosity, ownership, and attention to detail. You do not simply build what is asked without thinking through whether the data makes sense. You ask clarifying questions, check your work, document assumptions, and want to understand the business problem behind the report. You enjoy turning data into useful information. You are comfortable learning new tools, working with imperfect data, and receiving feedback. You care about accuracy and understand that dashboards are only valuable when the numbers are trusted and the story is clear." We can keep that as prose. THE ROLE: "As the Data Analyst for Cyber Security Metrics & Reporting, you will support the Strategy team by helping build, maintain, validate, and improve dashboards and reports used to understand Cyber Security performance, goals, risks, and operational trends. This role is hands-on and execution-focused, but it requires more than dashboard building. The Data Analyst will be expected to develop strong habits around data validation, quality checks, documentation, and insight development. This person will help ensure reporting outputs are accurate, clear, and connected to the operational questions the Cyber Security organization is trying to answer. The ideal candidate is not expected to be a senior analytics expert on day one. However, they must show strong analytical curiosity, a willingness to learn, accountability for quality, and the ability to explain what they see in the data. This role is remote and based in the United States." We keep that. What This Role Will Do: list of duties. Let's extract each bullet: - Build, update, and maintain dashboards, reports, and visualizations that support Cyber Security metrics and reporting needs. - Support recurring executive and operational reporting for Cyber Security goals, KPIs, risks, trends, and performance. - Gather and organize reporting requirements from stakeholders with guidance from the Strategy team. - Ask clarifying questions to understand the purpose of a report, the audience, and the decision the report is intended to support. - Use SQL and reporting tools to extract, clean, organize, and analyze data from multiple sources. - Perform basic data validation checks before sharing dashboards or reports, including checking totals, filters, joins, date ranges, duplicates, missing values, and metric logic. - Document assumptions, data sources, calculations, and known limitations in dashboards and reports. - Identify when data does not look right and escalate questions or concerns before publishing or presenting results. - Support exploratory analysis to identify trends, anomalies, patterns, and potential areas for follow-up. - Help translate data into simple summaries that explain what changed, where it changed, and why it may matter. - Partner with Cyber Security teams to better understand operational processes, source systems, and metric definitions. - Assist with data cleanup, reporting automation, and process improvement efforts. - Learn and apply best practices for dashboard design, data storytelling, quality control, and stakeholder communication. - Use AI-assisted tools responsibly where appropriate to support learning, documentation, SQL troubleshooting, and productivity, while validating outputs before use. We need to keep all. What This Person Will Bring: list: - 2-4 years of experience in data analytics, business intelligence, reporting, operations analytics, cybersecurity analytics, business analytics, or a related role. - Working knowledge of SQL, including joins, filtering, aggregations, and troubleshooting basic query issues. - Experience building dashboards or reports in Tableau, Power BI, Domo, Looker, or a similar BI platform. - Strong Excel skills, including pivot tables, formulas, data cleaning, and basic analysis. - Ability to review data carefully and identify inconsistencies, missing information, or results that do not make sense. - Strong attention to detail and willingness to check work before sharing it. - Ability to summarize findings clearly and concisely for non-technical audiences. - Ability to connect how the business operates and how data connects to real-world processes. - Strong communication skills and willingness to ask questions when requirements are unclear. - Ability to receive feedback, revise work, and improve over time. - Comfort working independently in a remote environment while keeping stakeholders informed. - Strong documentation habits, including documenting processes, tracking data sources, assumptions, logic, and open questions. Strongly Desired Qualifications: - Experience with Tableau. - Experience with Python for data cleaning, analysis, validation, or automation. - Familiarity with Databricks, Databricks SQL, notebooks, data lakes, or cloud analytics platforms. - Exposure to Cyber Security, risk, compliance, technology operations, incident management, change management, vulnerability management, or IT operations. - Familiarity with AI-assisted tools such as ChatGPT, GitHub Copilot, Databricks Assistant, or similar tools. - Experience creating written summaries, business insights, or dashboard narratives. - Experience working with multiple data sources or messy datasets. - Interest in developing toward a senior BI, analytics, or data storytelling role. What Success In This Role Looks Like: list: - Builds dashboards and reports that are clear, organized, and aligned to stakeholder needs. - Checks their work before sharing it. - Identifies when numbers do not make sense and raises concerns early. - Documents data sources, assumptions, calculations, and known limitations. - Asks thoughtful questions instead of waiting for every detail to be provided. - Improves the quality and reliability of reporting over time. - Begins developing simple insights and summaries, not just visuals. - Connects reporting outputs back to Cyber Security processes and operational context. - Takes feedback well and applies it to future work. - Demonstrates curiosity, accountability, and continuous learning. We could incorporate this as part of Responsibilities or maybe a separate section like "Expectations". But we only have allowed headings; we could put under Responsibilities as additional bullet points, or we could create a separate section like "Success Metrics" but not allowed. Better to merge into Responsibilities (since they are expectations). However we must not lose any detail. We can add them under Responsibilities as additional bullet points. Benefits & Perks: description: "Our motto is ‘Taking Care of Our Own’ through 6 pillars of benefits: HEALTH: Medical, vision, dental and mental health benefits for you and your family, with access to a health care concierge, and Flexible or Health Savings Accounts (FSA or HSA) YOURSELF: Free concert tickets, generous paid time off including paid holidays, sick time, and personal days WEALTH: 401(k) program with company match, stock reimbursement program FAMILY: New parent programs including caregiver leave and baby bonuses, plus fertility, adoption, foster, or surrogacy support CAREER: Career and skill development programs with School of Live, tuition reimbursement, and student loan repayment OTHERS: Volunteer time off, crowdfunding match" We need to keep that as prose or maybe list. Could format as

  • each pillar. But the text includes colon-separated pillars. We could split into list items: HEALTH: ..., YOURSELF: ..., etc. That preserves detail. Pay: "The Expected Compensation For This Position Is $67,000.00 USD - $84,000.00 USD Pay is based on a number of factors including market location, qualifications, skills, and experience. Live Nation Entertainment will never request payment or equipment purchases as part of the hiring process. Recruiters will only contact candidates from official Live Nation or affiliated brand email domains." We need to keep that. Now we need to decide sections: - About the role: includes WHO ARE WE?, WHO ARE YOU?, THE ROLE description (maybe combine). Could be multiple paragraphs. - Responsibilities: list of duties (What This Role Will Do) plus maybe success expectations. - Requirements: What This Person Will Bring (experience, skills, etc.) - Qualifications: Strongly Desired Qualifications - Skills: maybe we could extract specific skill mentions from Requirements and Qualifications? But we already have them in Requirements and