Excel Data Analyst Jobs in Washington, DC (NOW HIRING)

A leader in cutting-edge research and technology in the cyber arena, CPMG focuses on using business drivers to guide cybersecurity activities and manage risk. CPMG offers flexible, integrative solutions for Department of Defense (DoD) contractors, among others, and specializes in cybersecurity, information and operational technology, electronic security surveillance, and support services.

Summary:

This Data Analyst position is located within the Bureau of Consular Affairs, Resource Management Unit (RMU). RMU serves as the primary strategic planning and oversight body for bureau-level resource management. It is responsible for developing and maintaining the bureau’s strategic plan, establishing regulations, and prioritizing resources to align with mission objectives. RMU generates requirements, conducts cost of service modeling, and negotiates with interagency service requesters and intradepartmental service providers to secure necessary resources and services. Additionally, the RMU ensures transparency and accountability in resource allocation by coordinating with other bureaus and offices to align with Department-wide policies and standards. Through its strategic focus, the RMU provides the framework for effective resource management, enabling the bureau to meet its operational and strategic goals efficiently.

Essential Job Functions:

• Serves as a data analyst responsible for supporting a broad range of data analysis and visualization through the application of data science disciplines and advisory services that support the planning and execution of RMU programs.
• Accessing data sources, establishing data connections, and pre-processing data for analysis.
• Implementation, maintenance, and oversight of the data management standards, practices, process, and technologies within RMU.
• Utilizes knowledge of a broad range of qualitative and quantitative methods to analyze, conceptualize, and visualize the data generated by a wide range of software and applications.
• Designing and developing data visualizations and dashboard solutions to provide required analytics insights and BI.
• Utilizing analytics tools and artificial intelligence (AI) for data visualization and business intelligence (BI), such as Power BI.
• Assists in the coordination of project planning with other members of the data team and other stakeholders to develop project plans, work to be done, scope, and deadlines. Otherwise, s/he is responsible for planning and organizing projects, coordinating with staff if needed, conducting all phases of projects.
• Advises on data integration and its impact on RMU’s analytical toolsets, platforms, and products.
• Leading data driven analytic activities involving the identification of key indicators for compliance and effective performance critical to mission/business success.
• Designing data modeling processes, creating algorithms and predictive models, and performing ad hoc/exploratory data analysis to support data-driven decision making, including use of advanced analytics techniques such as predictive modeling and machine learning.
• Integrates data and automation from other Departmental teams, primarily elsewhere in CA and in CGFS.
• Ensures that periodic sampling of process/performance data is accomplished to identify data anomalies, i.e., missing input, dates inconsistent with data, numbers too large or small to be consistent with the data.
• Provides data analysis and data integrity advice on program issues and systems to data owners/managers to solve problems involving mission, policies, organization, processes, procedures, and methods.
• Operate successfully on remote projects.
• Other duties as required by the team and/or assigned by RMU leadership.

Necessary Skills and Knowledge:

• Intermediate/Expert knowledge/experience of Excel, PowerBI, Power Automate, and PowerApps and demonstrated proficiency with Microsoft Office applications (MS Word, PowerPoint and Excel).
• Must possess excellent verbal and written skills.
• Must possess a customer service approach, to include but not limited to people-first attitude, problem-solving and maintaining highest standards of personal/professional ethics.
• Knowledge of and skill in use of various virtual meeting platforms to include Microsoft Teams, Webex, and Zoom with the ability to adapt to using other various remote work tools.
• Knowledge of and skill in applying analytical and evaluative techniques in order to plan, schedule, and conduct studies and analyses of management functions or programs.

Minimum Qualifications:

• Must be a U.S. citizen with a valid U.S. passport and possess or obtain/maintain a minimum SECRET clearance.
• Bachelor's degree
• Four (4) years of experience
• Previous experience in a project or program management role.
• Prior experience applying process management techniques, process improvement implementation, and automation.
• Experience with data analysis and data visualization.
• Experience with financial data and processes.

Pay and Benefits

The salary range for this position is $90,000.00 to $102,000.00 annually. 

At Goldbelt, we value and reward our team's dedication and hard work. We provide a competitive base salary commensurate with your qualifications and experience. As an employee, you'll enjoy a comprehensive benefits package, including medical, dental, and vision insurance, a 401(k) plan with company matching, tax-deferred savings options, supplementary benefits, paid time off, and professional development opportunities.

Necessary Skills and Knowledge:

• Intermediate/Expert knowledge/experience of Excel, PowerBI, Power Automate, and PowerApps and demonstrated proficiency with Microsoft Office applications (MS Word, PowerPoint and Excel).
• Must possess excellent verbal and written skills.
• Must possess a customer service approach, to include but not limited to people-first attitude, problem-solving and maintaining highest standards of personal/professional ethics.
• Knowledge of and skill in use of various virtual meeting platforms to include Microsoft Teams, Webex, and Zoom with the ability to adapt to using other various remote work tools.
• Knowledge of and skill in applying analytical and evaluative techniques in order to plan, schedule, and conduct studies and analyses of management functions or programs.

Minimum Qualifications:

• Must be a U.S. citizen with a valid U.S. passport and possess or obtain/maintain a minimum SECRET clearance.
• Bachelor's degree
• Four (4) years of experience
• Previous experience in a project or program management role.
• Prior experience applying process management techniques, process improvement implementation, and automation.
• Experience with data analysis and data visualization.
• Experience with financial data and processes.

Pay and Benefits

The salary range for this position is $90,000.00 to $102,000.00 annually. 

At Goldbelt, we value and reward our team's dedication and hard work. We provide a competitive base salary commensurate with your qualifications and experience. As an employee, you'll enjoy a comprehensive benefits package, including medical, dental, and vision insurance, a 401(k) plan with company matching, tax-deferred savings options, supplementary benefits, paid time off, and professional development opportunities.