Data-Driven Business Systems Analyst (Hybrid)

Spectrum; Overland Park (KS); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Spectrum is seeking a data and analytics professional to transform business systems and deliver insights that drive fraud prevention and operational excellence. The role blends SQL, dashboard development, and stakeholder collaboration in an office with a hybrid schedule, and up to one remote day per week.

You'll partner with stakeholders to define requirements, build dashboards in MicroStrategy/Tableau/Power BI/Looker, and translate business needs into technical specs while ensuring data quality

Qualifications

• Bachelor’s degree or equivalent experience required.
• 2+ years business systems or IT-related experience.
• Ability to read, write, speak and understand English.
• 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.

Responsibilities

• Partner with stakeholders to gather requirements and translate into metrics 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 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 elevate data issues to improve accuracy and reliability of fraud reporting.

Skills

English communication

SQL for data analysis

Dashboard reporting

Requirements gathering

Stakeholder management

Data quality assurance

Independent and collaborative work

Analytical mindset

Problem solving

Attention to detail

Education

Bachelor’s degree or equivalent experience

Tools

MicroStrategy

Tableau

Power BI

Looker

Excel

Word

Job description

Spectrum is seeking a data and analytics professional to transform business systems and deliver insights that drive fraud prevention and operational excellence. The role blends SQL, dashboard development, and stakeholder collaboration in an office with a hybrid schedule, and up to one remote day per week.

You'll partner with stakeholders to define requirements, build dashboards in MicroStrategy/Tableau/Power BI/Looker, and translate business needs into technical specs while ensuring data quality