Data Analytics Consultant, Journeyman - Financial Emphasis
Aretum · McLean, VA · 3 wk ago
RemoteRemoteInformation TechnologyFull-time
Responsibilities
- Create, maintain, and enhance interactive Power BI dashboards and reports for business, technical, and leadership stakeholders
- Design and implement data visualization and reporting solutions that improve transparency of process assessments, data integrity, and information governance initiatives
- Develop standardized project reporting and visualization tools, including Power BI dashboards, to provide real-time visibility into project progress, risks, key metrics, and technical milestones
- Use Power BI and related analytics tools to analyze project data, identify trends, and generate actionable insights that support project planning, execution, and decision-making
- Clean, transform, merge, and model data from multiple sources to support analytics, reporting, and dashboard development
- Utilize tools such as Power Automate to automate repetitive tasks, including status report generation, task reminders, notifications, and overdue task tracking
- Create and maintain reusable project dashboards that provide real-time insights into project status, progress, and key performance indicators
- Communicate complex data findings in a clear, actionable manner to technical and non-technical audiences
- Regularly present findings, reporting outputs, and actionable insights to stakeholders to support strategic planning and operational visibility
- Support continuous improvement of reporting processes, data quality, dashboard usability, and analytics practices
- Stay current with Power BI updates, reporting trends, and industry best practices to improve data solutions and visualization approaches
Requirements
- Bachelor's degree in Computer Science, Engineering, Data Analytics, Management Information Systems, or a related field
- 5 to 7 years of relevant experience in data analytics, business intelligence, reporting, data visualization, or related work
- Experience with Power BI Desktop and Power BI Service
- Knowledge of DAX for calculations, measures, and data modeling
- Proficiency in Power Query, including M language, for data transformation and preparation
- Experience building, maintaining, and optimizing complex data models
- Strong SQL skills for data extraction, manipulation, integration, and reporting from various data sources
- Experience writing efficient queries and optimizing database interactions
- Ability to design intuitive, interactive dashboards and reports for business and technical users
- Ability to translate complex metrics and datasets into actionable insights for stakeholders
- Experience cleaning, merging, transforming, and preparing data to ensure quality, consistency, and reliability
- Proficiency in Microsoft Excel, including PivotTables and data modeling
- Ability to clearly communicate data findings, trends, and recommendations to non-technical audiences
Qualifications
- Must be eligible to obtain and maintain Public Trust or client suitability requirements