Sr. Business Analyst (Data Warehouse)

Key Responsibilities

• Review and assess existing data sources and data source systems across the agency
• Identify and document threats to data validity and reliability (excluding data security threats)
• Analyze structured and unstructured data from multiple systems and repositories
• Conduct stakeholder and subject matter expert interviews
• Review system and data source training materials
• Shadow end users to understand real-world data entry and usage processes
• Perform source system and table-level analysis
• Synthesize, prioritize, and document identified data threats
• Develop and present actionable, practical recommendations to mitigate data quality risks
• Collaborate with divisions including:
  • Division of Community Services
  • Division of Clinical and Quality Management
  • Division of Administration
  • IT and business stakeholders
• Participate in onboarding and training activities, including daily check-ins as required
• Communicate complex technical and data-related concepts clearly to non-technical audiences

Required Skills & Experience

• 5+ years of Business Analyst experience supporting IT software or application projects
• Strong experience in:
  • Data analysis and data quality assessment
  • Business and system process evaluation
  • Requirements gathering and documentation
  • Designing, testing, and validating standards and solutions
• Hands-on experience with:
  • MS Excel, including advanced functions
  • Power Query
  • Data warehouse concepts and capabilities
• Proven ability to analyze system issues and evaluate procedures and processes
• Experience working with both structured and unstructured data

Education Requirements

• Master's degree in Business Administration with a concentration in Information Technology
  OR
• Bachelor's degree in Computer and Information Technology or a related field plus 5 years of relevant experience