Data Analytics Consultant SME

About Aretum

DHS Suitability Required

Aretumis 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.

Job Summary

Aretum is seeking a Data Analytics Consultant - SME with experience in Power BI including advanced DAX Power Query and the development of complex data models to support scalable reporting solutions. Strong expertise in SQL data transformation and dashboard design with a proven ability to translate complex data into actionable insights while leveraging Excel and cloud-based data platforms.

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

• Gather and report meaningful metrics.
• Maintain Quarterly dashboard development timelines and keep up with additional work requirements.
• Validate and replace currently captured metrics with more meaningful metrics across operational teams on a regular routine basis at least bi-annually.
• Ensure that as metrics work products and outputs mature and change over time that definitions are updated on a routine basis from the Measures and Metrics (M&M) lexicon within current dashboard.
• Incorporate additional available metric sources (Malware Next Generation (MNG) Customer engagement data from CISA public releases and others).
• Consolidate and align data sources to streamline the overall M&M data structure on a repeatable and routine basis to ensure that as data sources change the underlying framework remains efficient and trustworthy.
• Consistently and regularly enhance our relational data model and compartmentalize datasets to strengthen governance improve data capture and ensure long-term scalability and maintainability.
• Build and maintain predictive analytics and insights around current data holdings to enable decision making.
• Build and maintain Performance Measure Definition Forms for metrics and measures currently captured.
• Define how each measure is calculated what fields are used what systems they come from to ensure consistency and accuracy of measurement.
• Integrate and establish repeatable workflows and data sharing with new Performance Management Working Group (PMWG).
• Assist with standardizing and streamlining performance measurements across external organizations to include performance measure development tracking reporting and management.

• Bachelors degree and 10 () years with Data Analytics or related experience.
• Extensive experience with Power BI Desktop and Power BI Service.
• Advanced knowledge of DAX (Data Analysis Expressions) for calculations and data modeling.
• Proficient in Power Query (M language) for data transformation and preparation.
• Demonstrated ability to build maintain and optimize complex data models.
• Strong SQL skills for data extraction manipulation and integration from various sources.
• Experience writing efficient queries and optimizing database interactions.
• Expertise in designing intuitive interactive dashboards and reports.
• Ability to translate complex metrics and data into actionable insights for stakeholders.
• Familiarity with data visualization best practices and user experience principles.
• Proficient in data cleaning merging and transformation techniques to ensure data quality and reliability.
• Experience preparing data from multiple sources for analysis and reporting.
• Advanced proficiency in Microsoft Excel including PivotTables and data modeling.
• Experience with SQL Server Azure or cloud-based data solutions is highly desirable.

Preferred

• Familiarity with Python or R for data analysis is a plus

Travel Requirements

This is a remote position; however occasional travel may berequiredbased on project needs client meetings team collaboration events or training is expected to be less than 10% and will be communicated in advance whenever possible.

EEO Statement

Aretumis 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 EmployerAretumcomplies withall applicable federal state and local employment laws.

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

If you require reasonable accommodation during the hiring process due to a disability please contactforassistance.

Equal Opportunity Employer/Veterans/Disabled

U.S. Work Authorization

Due to federal contract requirements only U.S. citizens are eligible for this position. This position supports a federal government contract and requires the ability to obtain andmaintaina Public Trust or Suitability Determination depending on the agencys background investigation requirements.

• 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

Required Experience:

Contract