Business Intelligence / Systems Analyst

Vector Consulting is an IT Talent Acquisition Solutions firm seeking a Business Intelligence / Systems Analyst for a remote contract opportunity. The role involves serving as a senior Metadata Ingestion Analyst, connecting technical IT with non-technical staff, and enhancing data literacy and reporting through effective use of metadata and AI.

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