Business Data Analyst

Company Description Krasan Consulting Services is a Chicago boutique management consulting and technology solutions integrator. As a certified BEP WBE with the State of Illinois and a certified WBE, MBE, and DBE recognized by the City of Chicago, Krasan provides complex technology solutions and services for clients in the Public and Commercial sectors. With decades of experience, Krasan specializes in end-to-end technology solutions, integration, and implementation services and is proud to enable the success of our customers. Role Title: Senior Business Data Analyst Type of contract: W2 Note: This is a W-2 employee position on our payroll. Unfortunately, 1099/C2C/C2H are not allowed at this time. Job Description: Client is seeking a seasoned and highly motivated Senior Business Data Analyst to support a high-impact Data & Analytics Support initiative, with a focus on enhancing outcomes in Child Protection and Child Welfare domains. This position requires a dynamic professional who combines deep analytical expertise with strong domain knowledge, exceptional soft skills, and technical proficiency to bridge the gap between business needs and analytical capabilities. The ideal candidate will serve as a strategic liaison between cross-functional stakeholders, ensuring the effective translation of complex business requirements into actionable data solutions. They will play a critical role in uncovering insights, designing data products, and enabling evidence-based decision-making that advances the mission of safeguarding children and supporting vulnerable populations. Key Responsibilities Business Analysis & Stakeholder Engagement • Lead the end-to-end requirements gathering process by engaging stakeholders across child welfare operations, D&A teams, and IT departments. • Translate non-technical business needs into detailed, technical reporting requirements, ensuring alignment with data platform capabilities. • Facilitate workshops, interviews, and collaborative sessions to capture objectives, pain points, and performance indicators from various business units. • Create comprehensive business requirement documents (BRDs), user stories, and acceptance criteria to support product and analytics development. Data & Analytics Design • Design & support development of conceptual and logical data models to support diagnostic, descriptive, predictive, and prescriptive analytics use cases. • Collaborate with data engineers, data scientists, and BI developers to design, build, and validate data pipelines, dashboards, and models. • Identify opportunities for automation, optimization, and reuse of data assets across programs and initiatives. Visualization & Storytelling • Design and deliver engaging, visually intuitive dashboards using Microsoft Power BI, integrating narrative storytelling to enhance stakeholder understanding and actionability. • Present complex data insights to business and executive audiences, tailoring communication to varying levels of data literacy. • Foster a culture of data-driven decision-making by promoting best practices in data visualization and usage. Data Governance & Quality • Support data governance practices including data quality assessments, data stewardship, and metadata documentation. • Participate in the implementation of Master Data Management (MDM) and data integrity protocols to ensure consistent and reliable data usage. • Assist in maintaining compliance with data privacy and security policies, particularly in handling sensitive child welfare data. Cross-functional Collaboration • Act as a trusted advisor to internal and external stakeholders, including program managers, policy analysts, IT teams, and service providers. • Work closely with solution architects and developers to ensure technical feasibility and operational alignment of data solutions. • Champion continuous improvement by proactively identifying gaps, proposing innovative solutions, and monitoring product performance analytics. Domain Knowledge & Preferred Experience • Strongly Preferred: Direct experience or comprehensive knowledge of Child Protection and Child Welfare policies, programs, and operational procedures. • Familiarity with public sector agencies, human services workflows, and legislative compliance requirements is highly desirable. • Prior work with data in highly regulated industry or complex case management settings, including healthcare, will be considered a significant asset. Required Soft Skills The candidate must demonstrate advanced proficiency in the following interpersonal and professional competencies: • Communication Excellence: Articulate complex technical and analytical concepts clearly across both technical and non-technical audiences. • Facilitation Mastery: Lead productive working sessions, brainstorming activities, and cross-functional collaboration meetings with clarity and structure. • Creative & Strategic Thinking: Frame innovative approaches to data challenges, enabling the co-creation of high-value analytics products. • Collaboration & Teamwork: Engage collaboratively with diverse teams to promote mutual understanding, shared ownership, and cohesive delivery. • Relationship Building: Develop and sustain trust-based relationships with key stakeholders and partners, demonstrating emotional intelligence and adaptability. • Narrative Storytelling: Construct coherent storylines that link analytical findings to actionable business strategies and policy improvements. • Influence & Advocacy: Effectively advocate for data-driven solutions, securing buy-in from decision-makers and overcoming organizational inertia. • Presentation Skills: Confidently deliver executive-level presentations, leveraging visual aids and data summaries to communicate impact and value. • Analytical Elicitation: Skillfully extract business intelligence needs through targeted inquiry, translating them into structured and measurable data deliverables. Technical Proficiency & Analytical Expertise Candidates must possess advanced-level knowledge and hands-on experience in the following areas: • Data Visualization & BI Tools: Expertise in Microsoft Power BI with ability to develop interactive, scalable dashboards and analytics reports. • SQL & Data Querying: Strong proficiency in SQL for querying, joining, and aggregating large datasets across relational databases. • Data Modeling & Management: Familiarity with data integration tools (ETL), metadata frameworks, and enterprise data management practices. • Data Architecture Concepts: Understanding of architecture such as Data Warehouses, Data Lakes, and Data Hubs, and their respective use cases. • Data Structures: Ability to work with structured, semi-structured, and unstructured data across multiple source systems. • Advanced Analytics & AI: Exposure to or understanding of machine learning, natural language processing, and graph analytics techniques. • Data Governance: Knowledge of Master Data Management (MDM), data quality frameworks, and data stewardship responsibilities. • Excel Expertise: Advanced Excel capabilities for data manipulation, validation, and supplementary visualization. Qualifications & Experience • Bachelor’s or master’s degree in Data Analytics, Computer Science, Information Systems, Public Administration, Finance, Business Administration, or a related field. • Minimum of 5-7 years of experience as a Business Data Analyst or similar role within enterprise or government settings. • Demonstrated success in delivering data-driven solutions that support organizational or public service goals.