Business Systems Analyst

Spectrum · Overland Park, KS · 1 mo ago

On-siteInformation TechnologyFull-time

We need to output HTML fragment with sections: About the role, Responsibilities, Requirements, etc. Must not repeat job title. Must include only sections with real content. Must not include boilerplate like EEO, legal, etc. Must preserve substantive info. Let's parse the posting. Content: - "This role requires the ability to work lawfully in the U.S. without employment-based immigration sponsorship, now or in the future." This is a requirement (work authorization). Could be part of Requirements. - "Transform Business Systems at Spectrum: Define and design innovative solutions that streamline processes and drive meaningful change. By leveraging your analytical skills and technical expertise, you’ll deliver systems that elevate business outcomes and ensure seamless performance across the organization. Leave a lasting impression by advancing Spectrum’s mission through impactful technology solutions." This is about the role. - "This position is in an office environment with a hybrid work schedule. Eligible employees can work from home up to one day each week." This is schedule info. - "How You’ll Make An Impact" then bullet list (actually sentences separated by semicolons). We'll treat as list. List items: - Partner with stakeholders to gather requirements; translate into clear metrics, definitions, and wireframes. - Build, optimize, and maintain dashboards in MicroStrategy (or Tableau/Power BI/Looker), including filters, drill paths, and role-based access. - Build reports linking operational metrics to fraud outcomes (losses, false positives, dispute cycle times) to identify bottlenecks and improvement opportunities. - Analyzing complex business partners’ operations to understand their strengths and weaknesses to determine opportunities to automate processes, functions, and systems - Providing technical expertise in identifying, evaluating, and developing systems and procedures that are cost effective and meet user requirements - Prepare clear summaries for stakeholders (weekly updates, incident recaps). - Maintain data quality: validate report inputs, reconcile discrepancies across systems, and escalate data issues to improve accuracy and reliability of fraud reporting. - "Required Qualifications What You’ll Bring to Spectrum Education Bachelor’s degree or equivalent experience Experience 2+ years business systems or IT-related experience Skills Ability to read, write, speak and understand English Ability to prioritize, organize and manage multiple projects and priorities simultaneously Advanced Knowledge of SQL for data analysis, reporting, and troubleshooting Ability to build, maintain, and enhance dashboards and reports to support business analysis and decision-making Ability to translate business needs into technical specifications Proficiency with requirement gathering, gap analysis, and stakeholder management Strong problem-solving skills and attention to detail Ability to work both independently and collaboratively Ability to analyze and interpret data Ability to quickly identify business problems and opportunities Effective oral and written communication skills with all levels of management Knowledge of software applications such as Word and Excel Knowledge of applicable systems Collaborate in a dynamic team environment and work independently as needed" - Then "BSY310 2026-82467 BSY310 2026" maybe job ID; we drop. - Then "Here, our employees don’t just have jobs, they're building careers. That’s why we offer a comprehensive pay and benefits package that rewards employees for their contributions to our success, supporting all aspects of their well-being at every stage of life." This is benefits/pay mention but not specific numbers. We cannot create Pay/Benefits sections unless posting actually states them. It mentions comprehensive pay and benefits package but no specifics. According to rule: never create Pay/Schedule/Benefits sections unless the posting actually states them. It states they offer a comprehensive pay and benefits package, but not specifics. Is that enough? The rule says: "never create Pay/Schedule/Benefits sections unless the posting actually states them." It does state they offer a comprehensive pay and benefits package. That is a statement about benefits/pay. However we need to avoid filler like "commensurate with experience". This is a generic statement but still states they offer a package. Could include a Benefits section with that sentence. But we need to see if we should include Pay section separately? There's no explicit pay numbers. The rule says prefer a few substantive sections over many thin ones. Might combine Benefits and Pay? But we have separate headings for Pay, Benefits, Schedule. Since we have schedule info (hybrid work schedule, up to one day WFH). That's specific enough for Schedule section. For Benefits, we have statement about comprehensive pay and benefits package. Could include Benefits section with that sentence. For Pay, we have no specific pay info, so we should not create Pay section. - Then "A qualified applicant’s criminal history, if any, will be considered in a manner consistent with applicable laws, including local ordinances." This is EEO/legal boilerplate; we should remove. - Then "Get to Know Us Charter Communications provides superior communication and entertainment products for residential and business customers through the Spectrum brand..." This is company description; could be part of About the role or maybe a separate About the company? Not required headings; we could include under About the role or maybe a separate "About Spectrum". But headings list only includes About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we should fit company description under About the role maybe. - Then "Watch this video to learn more." is boilerplate; remove. - Then "Grow Your Career Here We’re committed to growing a workforce that reflects the customers and communities we serve – providing opportunities for employment and advancement to all team members. Spectrum is an Equal Opportunity Employer, including job seekers with disabilities and veterans. Learn about Life at Spectrum." This is EEO/boilerplate; remove. Thus we need sections: About the role, Responsibilities, Requirements (maybe Qualifications/Skills). The posting separates Required Qualifications and Skills list. We could combine into Requirements and Skills sections. But we need to decide. We have Education, Experience, Skills list. Could put under Requirements (education+experience) and Skills separate. Let's extract: Education: Bachelor’s degree or equivalent experience Experience: 2+ years business systems or IT-related experience Skills list: many items. We could make a Requirements section with Education and Experience, and a Skills section with the list. Alternatively combine into one Requirements section with all. But better to follow typical: Requirements (education+experience) and Skills. Now Responsibilities: the bullet list under How You’ll Make An Impact. About the role: the introductory paragraphs about Transform Business Systems, plus maybe company description. Schedule: hybrid work schedule, up to one day WFH. Benefits: statement about comprehensive pay and benefits package. We must not include Pay section. Now produce HTML:

About the role

...

Responsibilities

Requirements

Education: Bachelor’s degree or equivalent experience

Experience: 2+ years business systems or IT-related experience

Skills

Ability to read, write, speak and understand English

Schedule

This position is in an office environment with a hybrid work schedule. Eligible employees can work from home up to one day each week.

Benefits

Eligible employees receive a comprehensive pay and benefits package that rewards contributions to the company’s success and supports well‑being at every stage of life.

as we interpreted. Let's list them: - Partner with stakeholders to gather requirements; translate into clear metrics, definitions, and wireframes. - Build, optimize, and maintain dashboards in MicroStrategy (or Tableau/Power BI/Looker), including filters, drill paths, and role-based access. - Build reports linking operational metrics to fraud outcomes (losses, false positives, dispute cycle times) to identify bottlenecks and improvement opportunities. - Analyzing complex business partners’ operations to understand their strengths and weaknesses to determine opportunities to automate processes, functions, and systems - Providing technical expertise in identifying, evaluating, and developing systems and procedures that are cost effective and meet user requirements - Prepare clear summaries for stakeholders (weekly updates, incident recaps). - Maintain data quality: validate report inputs, reconcile discrepancies across systems, and escalate data issues to improve accuracy and reliability of fraud reporting. Check grammar: some start with verb forms; keep as is. Now Requirements: Education and Experience plus work authorization. We could format as
Education: Bachelor’s degree or equivalent experience
Experience: 2+ years business systems or IT-related experience
Must be able to work lawfully in the U.S. without employment‑based immigration sponsorship, now or in the future.
Now Skills list: extract each skill from the long sentence. Original: "Ability to read, write, speak and understand EnglishAbility to prioritize, organize and manage multiple projects and priorities simultaneouslyAdvanced Knowledge of SQL for data analysis, reporting, and troubleshootingAbility to build, maintain, and enhance dashboards and reports to support business analysis and decision-makingAbility to translate business needs into technical specificationsProficiency with requirement gathering, gap analysis, and stakeholder managementStrong problem-solving skills and attention to detailAbility to work both independently and collaborativelyAbility to analyze and interpret dataAbility to quickly identify business problems and opportunitiesEffective oral and written communication skills with all levels of managementKnowledge of software applications such as Word and ExcelKnowledge of applicable systemsCollaborate in a dynamic team environment and work independently as needed" We need to split into sensible items. Let's separate by capital letters after a lowercase? We'll manually list: - Ability to read, write, speak and understand English - Ability to prioritize, organize and manage multiple projects and priorities simultaneously - Advanced Knowledge of SQL for data