AI-Driven BI Analyst: Dashboards, Data & Insights

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

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