Business Intelligence / Systems Analyst

Vector Consulting, Inc. is an IT Talent Acquisition Solutions firm seeking a Business Intelligence / Systems Analyst for a remote contract opportunity. This role will serve as a senior Metadata Ingestion Analyst, acting as a liaison between technical IT and non-technical staff while managing complex data sources to support agency reporting and decision-making.

Responsibilities:

• Strategic Liaison and Translation
• Work with program areas, project sponsor and system SMEs to connect EIM cataloging and lineage systems to source systems in IT
• Automate regular collection and updates to agency metadata for high value data assets
• Explain technical findings and data limitations in simple, non-technical language to end-users
• Data Reporting and Visualization
• Extract, integrate, and analyze metadata from multiple complex internal and external sources to support program needs
• Collaborate with end-users and performance analysts or IT internal leaders to create visualizations for enrichment progress and official reporting
• Provide subject matter expertise on validating output from AI, particularly with respect to identifying and mitigating hallucinations
• Ensure all data outputs adhere to agency reporting standards, data governance, and compliance regulations
• Data Literacy and Training
• Champion data glossary literacy across the organization by developing and conducting training sessions for non-technical staff
• Create clear, comprehensive documentation and tutorials on using glossary tools for data synthesis
• Promote a data-driven culture by enabling and empowering all employees to effectively utilize metadata and AI
• Collaboration and Problem-Solving
• Work closely with data engineering, IT, and Program teams to troubleshoot metadata-related issues and address inconsistencies and mitigation strategies
• Provide expert guidance to program staff on interpreting data trends and answering complex data questions
• Stay up to date on new AI and metadata analysis tools and techniques to continuously improve data glossaries, data quality and reporting
• AI Prompting and Data Synthesis
• Develop and refine effective AI prompts and query strategies to retrieve and synthesize metadata accurately from complex data domains
• Guide non-technical users in crafting precise prompts to get the glossary data they need, ensuring fidelity and accuracy
• Develop a library of standardized prompts and query templates for common reporting needs

Requirements:

• 8 Required Experience gathering business requirements and translating complex metadata acquisitions and operational requirements into clear, actionable access paths for data glossaries for complex analytics
• 8 Required Experience explaining technical findings and data limitations in simple, non-technical language to end-users and leadership
• 8 Required Experience in a complex data analysis, senior business/systems analyst, and/or data liaison role
• 8 Required Strong experience with SQL for data extraction, manipulation and enrichment
• 8 Required Experience collaborating with end-users and performance analysts or IT internal leaders to create and validate glossaries for analytics development and business data lineage analysis
• 8 Required Excellent communication, presentation, and interpersonal skills
• 5 Preferred Experience with Business Intelligence/Data Warehouse
• 5 Preferred Experience acting as the primary point of contact for program staff with metadata/glossary needs for analytics projects
• 5 Preferred Experience working in a health and human services or similarly regulated environment, with a strong understanding of agency metadata requirements
• 5 Preferred Experience with data governance and data quality principles
• 5 Preferred Experience with data glossary tools such as Informatica Enterprise Data Catalog (EDC and Axon Data Governance
• 2 Preferred Experience championing data literacy across the organization
• 2 Preferred Experience training and mentoring staff with varying levels of data literacy
• 1 Preferred Experience with AI prompt development