Data Analyst - Frederick, MD

Responsibilities

• Gather data from various sources (databases, APIs, spreadsheets, etc.)
• Clean, validate, and transform data to ensure accuracy and consistency
• Maintain and update data repositories
• Conduct exploratory data analysis to identify trends and patterns
• Develop and apply statistical models and techniques to analyze data
• Interpret data and present findings and recommendations to stakeholders in a clear and concise manner
• Create dashboards and reports to track key performance indicators (KPIs)
• Visualize data using charts, graphs, and other visual aids
• Collaborate with leadership to understand their data needs
• Collaborate with other data professionals to share knowledge and best practices
• Perform data analysis and develop ad hoc reporting to support management activities as necessary for briefing materials, reports, taskers, memos, procedures, etc.
• Support the development of all Programmatic Reviews and activity involving project requirements
• Support the development and integration of changed user/project requirements into the project baseline(s) and support the development and enhancement of all programmatic review and activity involving project requirements
• Work directly with the business operations team to aid in the creation of inter-office procedures providing feedback to allow for measurable data points for performance metrics
• Oversee the management and handling of data and assist in the establishment of processes and/or procedures for data governance best practices and provide quality assurance for adherence
• Aid in establishing and management of data reporting and presentation standards
• Assist in conducting market research and preparing Analysis of Alternatives (AoA) and Market Research reports

Qualifications

• Bachelor's Degree with a minimum of five (5) years of professional experience and at least three (3) years supporting IT or related disciplines
• Proficiency in MS Access and Access SQL language for data querying and manipulation
• Proficiency with Power BI data visualizations and DAX language for measures
• Proficiency in MS Excel and M-Query Language
• Proficiency in Adobe and Adobe JavaScript
• Strong understanding of statistical concepts and methods
• Strong understanding and automation abilities using Microsoft 365 and MS Power Platform products
• Experience with a programming language for data analysis (e.g., R-script)
• Experience with MS Visio, MS Excel VBA, and MS Project
• Excellent analytical and problem-solving skills
• Effective communication and presentation skills
• Ability to work independently and as part of a team
• Ability to manage multiple projects and prioritize tasks
• Strong attention to detail
• ISO 27001 and CMMI-DEV (development) Maturity Level 3 certifications or equivalents desired
• Must have a Public Trust clearance or be a U.S. Citizen capable of obtaining a Public Trust clearance