Senior Data Analytics Consultant, Power BI Federal Financial Data

DHS Suitability Required

Aretum is a mission-driven organization committed to delivering innovative technology-enabled solutions to our customers across defense civilian and homeland security sectors. Our teams work at the intersection of strategy technology and transformation helping agencies solve their most critical challenges. We believe in investing in our people and creating a culture where collaboration inclusion and professional growth are at the forefront.

Aretum is seeking a Senior Data Analytics Consultant to support a DHS CISA program. This role will focus on developing maintaining and enhancing data analytics reporting and visualization solutions that provide leadership and stakeholders with clear actionable insights. The ideal candidate will have strong experience with Power BI SQL data modeling data transformation and dashboard development with the ability to translate complex data into meaningful reporting for both technical and non-technical audiences.

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

• Create maintain and enhance interactive Power BI dashboards and reports for business and technical stakeholders.
• Develop reusable project dashboards that provide real-time visibility into project status progress risks key metrics and technical milestones.
• Use Power BI and related tools to analyze project data identify trends and generate actionable insights to support project planning and execution.
• Design and implement data visualization and reporting solutions that 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 such as 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.

• Bachelors 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.
• Experience with Power BI Desktop and Power BI Service.
• 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.
• Experience designing 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.
• Proficiency in data cleaning merging transformation and validation to support data quality and reliability.
• 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.

• Experience working with federal financial budget or procurement data.
• Experience working with budget spend plans financial reporting or procurement-related datasets.
• 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.

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

Aretum is committed to fostering a workplace rooted in excellence integrity and equal opportunity for all. We adhere to merit-based hiring practices ensuring that all employment decisions are made based on qualifications skills and ability to perform the job without preference or consideration of factors unrelated to job performance.

As an Equal Opportunity Employer Aretum complies with all applicable federal state and local employment laws.

We are proud to support our nations veterans and military families providing career opportunities that honor their service and experience.

If you require reasonable accommodation during the hiring process due to a disability please contact for assistance.

Equal Opportunity Employer/Veterans/Disabled

Required Experience:

Senior IC