Senior Data Analytics Consultant, Power BI / Federal Financial Data

About Aretum DHS Suitability Required

Aretum is a mission-driven organization dedicated to delivering innovative, technology-enabled solutions to defense, civilian, and homeland security sectors. Our teams bridge strategy, technology, and transformation, empowering agencies to tackle their most pressing challenges.

Job Summary

Aretum is seeking a Senior Data Analytics Consultant to support a DHS CISA program. This role involves developing, maintaining, and enhancing data analytics, reporting, and visualization solutions that provide clear, actionable insights to leadership and stakeholders. The ideal candidate should have extensive experience with Power BI, SQL, data modeling, and dashboard development, translating complex data into understandable reports for both technical and non-technical audiences.

Due to the nature of our work as a federal consulting organization, employees may be required to handle Controlled Unclassified Information (CUI) and must comply with safeguarding and compliance requirements.

Responsibilities

• Create, maintain, and enhance interactive Power BI dashboards and reports for business and technical stakeholders
• Develop reusable project dashboards for real-time visibility into project status, progress, risks, key metrics, and technical milestones
• Analyze project data using Power BI and related tools to identify trends and generate actionable insights for project planning and execution
• Design and implement data visualization and reporting solutions to improve transparency around process assessments, data integrity, and information governance initiatives
• Clean, transform, and model data from multiple sources to support analytics, reporting, and decision-making needs
• Collaborate with business users and stakeholders to gather requirements and translate them into effective data solutions
• Establish and maintain standardized reporting and visualization tools to support leadership visibility and informed decision-making
• Utilize tools like Power Automate to automate repetitive tasks, including status report generation, task reminders, and notifications for overdue items
• Communicate complex data findings in a clear, actionable manner to technical and non-technical audiences
• Present findings, trends, and recommendations to stakeholders in support of strategic planning and operational improvements
• Stay current with Power BI updates, data visualization practices, and industry trends to continuously improve reporting solutions

Requirements

• Bachelor's degree in Computer Science, Engineering, Data Analytics, Management Information Systems, or a related field
• 10+ years of relevant experience in data analytics, business intelligence, reporting, dashboard development, or related data-focused roles
• Advanced knowledge of DAX for calculations, reporting logic, and data modeling
• Proficiency with Power Query, including M language, for data transformation and preparation
• Demonstrated ability to build, maintain, and optimize complex data models
• Strong SQL skills for data extraction, manipulation, integration, and reporting
• Experience writing efficient queries and optimizing database interactions
• Ability to design intuitive, interactive dashboards and reports for business and technical audiences
• Ability to translate complex metrics and data into actionable insights for stakeholders
• Familiarity with data visualization best practices and user experience principles
• Experience preparing data from multiple sources for analysis and reporting
• Advanced proficiency in Microsoft Excel, including PivotTables and data modeling
• Ability to obtain and maintain Public Trust eligibility and/or client suitability
• U.S. citizenship or Green Card holder status with at least three years of U.S. residency, as required by the federal client

Preferred Qualifications

• Experience working with federal financial, budget, or procurement data
• Familiarity with FFMS or similar federal financial management systems
• Understanding of the congressional budget cycle
• Experience with SQL Server, Azure, or cloud-based data solutions
• Familiarity with Python or R for data analysis
• Prior experience supporting DHS, CISA, or other federal consulting environments

Benefits

• Health Care Plan (Medical, Dental & Vision)
• Retailment Plan (401k)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off
• Family Leave (Maternity, Paternity)
• Short Term & Long-Term Disability
• Training & Development