Role Description 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. Qualifications - Bachelor's 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 be required based on project needs, client meetings, team collaboration events, or training sessions. Travel is expected to be less than 10% and will be communicated in advance whenever possible. 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 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 and maintain a Public Trust or Suitability Determination, depending on the agency’s background investigation requirements.

• Analyze, clean, validate, and transform client-provided data from diverse sources and formats before system upload • Execute SQL queries and Python scripts to process, reconcile, and validate large transactional datasets • Investigate data quality issues, exceptions, and inconsistencies to present findings to project managers for client resolution • Collaborate with internal teams and external stakeholders to resolve data-related issues and ensure accuracy • Review project manager requests to determine data processing requirements and deliver processed datasets • Recommend and implement process improvements that increase accuracy, consistency, and operational efficiency

• Datenanalyse mit SQL, Python und Power BI • Erstellung interaktiver Dashboards • Grundlagen der KI und agiles Projektmanagement • Online-Training im virtuellen Klassenzimmer

Role Description A Data Technician will support a delivery team to enter, report, and document data under the guidance of the team lead. This position is part of a team requiring daily interactions in a collaborative environment. 100% Remote Monday - Friday 800AM EST to 430PM EST. Qualifications - Experience with databases, specifically Oracle. - Experience with SQL. - Ability to manage time and prioritization of tasks at a high level. - Ability to communicate effectively with managers and customers. - Experience working within a team-oriented, collaborative, Agile environment. - Experience with tools such as ServiceNow, GitHub, Jira. Requirements - Data Entry and Processing: Entering, updating, and correcting data in databases, often handling high volumes of information. - Data Integrity and Quality: Verifying data accuracy, performing data cleaning, and ensuring consistency across systems. - Reporting and Analysis: Generating reports and extracting insights from data for operational use. - Documentation and Security: Maintaining data documentation (dictionaries/models) and adhering to data security policies. - Ability to prioritize and execute tasks. Company Description DPCG is an Equal Opportunity Employer committed to hiring and developing the most qualified individuals based on merit, experience, and business needs, without regard to any protected status under applicable law.