BI Reporting & AI Analyst

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

Job summary

Avum Inc. designs, develops, and maintains business intelligence dashboards, reports, and data visualizations that support Avum's internal operations and government mission programs. Transforms complex data into actionable insights for program teams, leadership, and government customers.

Leverages AI-enabled analytics to enhance reporting workflows, data quality, and analytics delivery, in a hybrid work environment with security requirements.

Qualifications

• Bachelor's degree in data analytics, information systems, computer science, statistics, or related.
• 3+ years in BI development, data analytics, or reporting.
• Strong proficiency in Tableau or QuickSight, incl. data modeling and calculated fields.
• Experience with cloud BI platforms and data services (Databricks, Palantir Foundry, AWS QuickSight, Azure Synapse, Google Looker).
• Solid SQL skills with complex queries against Redshift, Oracle, PostgreSQL, SQL Server.

Responsibilities

• Design, build, and maintain interactive BI dashboards and reports.
• Develop paginated and ad hoc reports for programs, leadership, and government customers.
• Build and optimize data models and transformations for scalable reporting.
• Develop and maintain ETL processes from multiple sources.
• Respond to ad hoc data calls with quick turnaround.
• Perform data quality assurance, validation, and reconciliation.
• Leverage AI-powered analytics features to enhance dashboard capabilities.
• Collaborate with stakeholders to gather requirements and define KPIs.
• Present visualizations and findings to stakeholders and program teams.
• Support data migration, system integrations, and BI tool evaluations.
• Create and maintain documentation for reports and data sources.
• Monitor dashboard performance and implement continuous improvements.

Skills

Tableau

QuickSight

Data modeling

SQL

Unstructured data

Machine learning

Python

Education

Bachelor's degree

Master's degree

Tools

SSIS

Informatica

AWS Glue

Databricks

Palantir Foundry

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 Affirmative Action Plan.