Business System Analyst

Position Title: Business Systems Analyst (BSA)
Location: Chicago, IL
Work Model: Hybrid (2 days onsite per week)
Duration: ASAP – September 2026
Hours: Standard business hours

We are seeking a highly analytical and technically skilled Business Systems Analyst (BSA) to support the delivery of data-driven and AI-enabled solutions. The successful candidate will bridge business requirements with modern data, cloud, and automation technologies.

• Collaborate with stakeholders to gather, analyze, and document business and system requirements
• Translate business needs into technical solutions leveraging data and cloud platforms
• Perform data analysis, data profiling, and source-to-target mapping
• Design and support data workflows and pipelines using Python, SQL, and Azure services
• Work with Azure Databricks to build, optimize, and maintain scalable data solutions
• Develop dashboards, reports, and insights to support decision-making (Power BI)
• Create and maintain requirements documentation, including SRDs
• Communicate effectively with both technical and non-technical stakeholders
• Leverage AI tools (e.g., Copilot) to automate reporting, workflows, and business processes
• Develop and utilize prompt templates for AI-driven solutions

• Bachelor's degree in Computer Science, Information Systems, Business, or related field
• 5–7 years of experience as a Business Systems Analyst or in a similar role
• Strong proficiency in:
  • Python (data manipulation, scripting, automation)
  • SQL (advanced queries, data modeling)
  • Data modeling, data profiling, and source-to-target mapping
  • JIRA
  • Power BI
  • Microsoft Azure (Data Factory, Synapse, or related services)
  • Azure Databricks (data engineering, Spark, notebooks)
• Experience with AI tools such as Microsoft Copilot or similar platforms
• Knowledge of prompt engineering and AI-assisted workflows
• Experience integrating tools within Microsoft Teams
• Strong analytical, problem-solving, and communication skills

• Business analysis & requirements gathering
• Data analysis and data modeling
• Data profiling & mapping
• AI automation and prompt engineering
• Cloud data architecture
• Stakeholder communication
• Process optimization

• Automating report generation using Copilot and Python scripts
• Building Databricks pipelines for real-time analytics
• Creating AI-driven Teams bots and workflows
• Using AI to summarize business data and generate insights

AI tools may be utilized during the screening and evaluation process to obtain basic candidate information, detect plagiarism, identify inconsistencies such as false employment history or references, categorize skills, and perform an initial match against the job requirements.