BI Reporting & AI Analyst

Avum Inc.; Malibu (CA); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Avum, Inc. is seeking a skilled BI Engineer to design, build, and maintain interactive dashboards using Tableau and similar tools for government and internal stakeholders. You will develop data models, ETL processes, and AI-powered analytics to deliver actionable insights and automate recurring reports.

The role requires collaboration with program teams and ensuring data quality and security compliance. The ideal candidate will have 3+ years in BI, strong SQL skills, and experience with cloud BI

Qualifications

• Bachelor's degree in data analytics, information systems, computer science, statistics, or related.
• 3+ years of experience in BI development, data analytics, or reporting.
• Strong proficiency in Tableau or QuickSight with data modeling.
• Cloud BI platforms and data services (Databricks, Palantir Foundry, AWS QuickSight, Azure Synapse, Google Looker).
• SQL skills with complex queries (Redshift, Oracle, PostgreSQL, SQL Server).
• Experience designing star/snowflake schemas and scalable data models.
• Experience handling semi/unstructured data.
• Ability to translate business requirements into clear visualizations.
• Experience with machine learning, predictive analytics, and advanced analytics.
• U.S. citizenship required.
• Ability to obtain and maintain a Secret security clearance.

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.
• Develop and maintain ETL processes for multiple sources.
• Respond to ad hoc data calls and reporting requests with quick turnaround.
• Perform data quality assurance, validation, and reconciliation.
• Leverage AI-powered analytics features to enhance dashboards.
• Apply advanced analytic techniques to solve business problems.
• Identify opportunities to automate recurring reports and data workflows using AI/scripting/low-code.
• Collaborate with stakeholders to gather requirements and KPIs.
• Present visualizations and findings to stakeholders and program teams.
• Support data migration efforts, system integrations, and BI tool evaluations.
• Create and maintain documentation for reports, data sources, and SOPs.
• Monitor dashboard performance and implement continuous improvements.

Skills

Tableau

QuickSight

Data modeling

SQL queries

Data visualization

ML analytics

Education

Bachelor's degree in related field

Master's degree preferred

Tools

Databricks

Palantir Foundry

AWS Glue

SSIS

Informatica

Appian

Job description

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

Required Qualifications

• Bachelor's degree in data analytics, information systems, computer science, statistics, or related
• 3+ years of experience in BI development, data analytics, or reporting
• Strong proficiency in Tableau, Amazon QuickSight, or similar BI platforms, including data modeling and calculated field development
• Experience with cloud-based BI platforms and data services (Databricks, Palantir Foundry, AWS QuickSight, Azure Synapse, Google Looker)
• Solid SQL skills with experience writing complex queries against relational databases (e.g., Redshift, Oracle, PostgreSQL, SQL Server)
• Experience designing star/snowflake schemas and building scalable data models
• Experience handling semi-unstructured and unstructured data
• Demonstrated ability to translate business requirements into clear, impactful data visualizations
• Experience with machine learning, predictive analytics, and other advanced analytics capabilities
• U.S. citizenship required
• Ability to obtain and maintain a Secret security clearance

Preferred Qualifications

• Master's degree in data science, analytics, information systems, or related field
• Active Secret or Top Secret security clearance
• Experience with AI-enhanced analytics tools (e.g., Qlik Insight Advisor, Tableau AI, natural language query features)
• Python or R scripting skills for data manipulation, automation, or advanced analytics
• Familiarity with cutting edge standards for enterprise data architecture (e.g., Palantir Foundry Ontology, Appian data fabric)
• Tableau Desktop Specialist, Microsoft PL-300, or similar BI certification
• Experience with ETL tools or frameworks (SSIS, Informatica, AWS Glue, or custom pipelines)
• Familiarity with Appian, SharePoint, or other enterprise platforms
• Familiarity with DoD contract writing system data structures (Procurement Data Standard (PDS))
• Experience supporting federal government or DoD customers
• Knowledge of federal compliance frameworks (CMMC, NIST 800-171)
• Google Associate Cloud Engineer or similar cloud certification

Work Environment & Requirements

• Hybrid/remote work environment with potential on‑site requirements based on contract needs
• U.S. citizenship required
• Security clearance: Ability to obtain and maintain a Secret clearance (active clearance preferred)
• Background check required

Equal Employment Opportunity

Avum, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected class under federal, state, or local law. Avum is committed to compliance with Section 503 of the Rehabilitation Act and VEVRAA, and maintains an active Affimative Action Plan.