BI Reporting & AI Analyst
Position Summary
Designs, develops, and maintains business intelligence dashboards, reports, and data visualizations that support Avum's internal operations and government mission programs. Transforms complex data in various formats into datasets to create clear, actionable insights for program teams, leadership, and government customers. Leverages advanced analytics, emerging AI, and automation capabilities to enhance reporting workflows, improve data quality, and accelerate analytics delivery.
Key Responsibilities
- Design, build, and maintain interactive BI dashboards and reports using Tableau, QuickSight, Qlik, Appian or similar tools
- Develop and manage paginated and ad hoc reports for program teams, leadership, and government customers
- Build and optimize data models, calculated measures and data transformations to support accurate, scalable reporting
- Develop and maintain ETL processes for data extraction, cleansing, transformation, and loading from multiple sources
- Respond to ad hoc data calls and reporting requests from program teams and government customers with quick turnaround
- Perform data quality assurance, validation, and reconciliation to ensure reporting accuracy and data integrity
- Leverage AI-powered analytics features (e.g., AI-driven insights, natural language queries) to enhance dashboard capabilities and user experience
- Apply advanced analytic techniques to solve business problems and address needs
- Identify opportunities to automate recurring reports and data workflows using AI tools, scripting, or low-code platforms
- Collaborate with stakeholders to gather requirements, define KPIs, and translate business needs into effective data visualizations
- Present visualizations and findings to stakeholders and program teams
- Support data migration efforts, system integrations, and BI tool evaluation initiatives
- Create and maintain documentation for reports, data sources, data dictionaries, and standard operating procedures
- Monitor dashboard performance, troubleshoot data issues, and implement continuous improvements to reporting solutions