Aretum

Senior Data Analytics Consultant, Power BI / Federal Financial Data

Aretum • $100K — $130K *
Mclean, VA 22101In-Person
Education, Government & Non-Profit
8 - 10 years of experience
1 month ago
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Engineering, Data Analytics, or related field.
  • 10+ years in data analytics, business intelligence, or similar roles.
  • Experience with Power BI Desktop and Service.
  • Advanced knowledge of DAX for calculations and data modeling.
  • Proficient in SQL for data extraction and reporting.

Responsibilities

  • Create and enhance interactive Power BI dashboards for stakeholders.
  • Develop project dashboards to provide real-time visibility into project progress.
  • Analyze project data with Power BI to identify trends and generate insights.
  • Design visualization solutions for process assessments and data integrity.
  • Collaborate with stakeholders to gather requirements for data solutions.

Benefits

  • 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
Full Job Description
Job Summary

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.
Responsibilities
  • 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.

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.
  • 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.
Preferred Qualifications
  • 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.

Benefits
  • 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


About Aretum

ARETUM is a government contracting company specializing in technology-enabled mission support services for the Department of Defense, Department of Homeland Security, and Federal-Civilian customers.

Aretum Careers

Joining Aretum offers an unparalleled opportunity to become part of a leading team of professionals dedicated to pioneering innovation in their industry. Aretum, known for its commitment to excellence and leadership in technology, is actively seeking talented individuals eager to foster their careers in a dynamic and supportive environment.

Explore Job Opportunities

Aretum is continuously expanding, offering a variety of job opportunities that cater to professionals looking to advance their careers. From entry-level positions to senior roles, Aretum is committed to hiring and nurturing the most qualified candidates.

Experience Professional Growth and Development

At Aretum, career growth is a priority. The company supports professional development through comprehensive training programs, including leadership development and diversity training, ensuring every team member has the resources to thrive professionally. Aretum encourages a culture of learning and innovation, where skills enhancement and leadership capabilities are always in focus.

Internship Programs

Aretum’s internship programs provide invaluable industry experience, offering a stepping stone to full-time employment. Interns at Aretum gain hands-on experience, working alongside seasoned professionals and participating in projects that impact the company’s success.

Cultivating a Diverse and Inclusive Culture

Aretum is proud of its diverse workforce and inclusive culture. The company believes that diversity fuels innovation and enhances the team's ability to address complex challenges. Aretum’s commitment to an inclusive workplace is evident in its diverse hiring practices and its supportive network that values every individual’s contribution.

Benefits and Perks

Employees at Aretum enjoy a comprehensive benefits package that underscores the company’s commitment to their well-being and satisfaction. Benefits include health, dental, and vision insurance, retirement plans, and generous paid time off, among others. Aretum understands that the well-being of its team is crucial to the company’s success.

Join the Aretum Team

Aretum is looking for passionate, curious, and innovative team players. Explore open positions that match your skills and interests on the Aretum Jobs portal. Prepare your resume, refine your interview skills, and take the first step towards a rewarding career at Aretum.

Networking and Career Advancement

Aretum promotes a culture of networking and collaboration, providing numerous opportunities for employees to connect with industry leaders and peers. The company hosts regular networking events, encouraging team members to build relationships and share insights that drive personal and professional growth.

Stay Connected with Aretum Careers

Keep up to date with the latest career tips, industry insights, and employment trends all from the professionals at Aretum. Subscribe to Aretum’s Careers Blog and personalize your subscription to receive job alerts and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await at Aretum.

Apply Now

Ready to make a significant impact in your career? Search for current job openings at Aretum, tailor your application, and join a team that’s redefining the future of technology and innovation.
Learn more about Aretum
Size
501 employees
Industry
Enterprise Technology
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Aretum

More Education, Government & Non-Profit Jobs

Find similar Senior Data Analytics Consultant, Power BI / Federal Financial Data jobs:

NationwideMclean, VA