Business Data Analyst III

Job not on LinkedIn

🔥 0 minutes ago

🏛️ District of Columbia, Washington – Remote

🏛️ District of Columbia – Remote ☕ Washington – Remote

💵 $120k - $170k / year

⏰ Full Time

🟠 Senior

🔴 Lead

📉 Data Analyst

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Cogent Security

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2010

🔐 Security

🎖️ Defense

🏛️ Government

Security • Defense • Government

Cogent Security is a U. S. -based national security services and solutions firm headquartered in Alexandria, VA. The company provides objective, interdisciplinary expertise to government customers, offering risk management and decision support; intelligence and counterintelligence; security operations, logistics, and training; security engineering and integration; technical surveillance countermeasures; program management and technical support; special access and clearance services; and cloud and products for advanced programs. Cogent positions itself as a contractor supporting sensitive federal national-security programs (e. g. , work with NNSA/Pantex is referenced) and emphasizes independent, mission-focused delivery for government clients.

📋 Description

• Support DOE’s Office of State and Community Energy Programs (SCEP) through portfolio data review, analysis, and reporting • Extract, reconcile, and integrate data from DOE systems of record, including PAGE, IDW, iPortal, and BART • Build and maintain databases and data models for structured, queryable, repeatable analysis and reporting • Identify and resolve data gaps, exceptions, and quality issues; implement corrections and validation checks • Analyze portfolio trends, obligations, expenditures, awards, projects, milestones, deliverables, staffing, and hiring • Respond to DOE leadership, Federal office, and external oversight data calls • Develop reports, dashboards, briefings, infographics, management reports, case studies, and recommendations • Establish and document data definitions, reporting processes, and data quality standards • Lead data efforts in system modernization projects • Design and maintain automated workflows replacing manual data pulls, reconciliations, reporting, and distribution • Identify and prioritize automation opportunities across SCEP business processes • Translate standard operating procedures into automated or semi-automated workflows • Develop and maintain SOPs for databases, reports, and workflows • Train and support SCEP staff on delivered databases, dashboards, and workflows • Support business and functional requirements for data and workflow tools • Manage multiple sensitive or complex projects and work cross-functionally to resolve problems and implement changes

🎯 Requirements

• Bachelor of Science or Bachelor of Arts in business administration, accounting, public administration, or a related discipline • Four years of relevant education/experience may substitute for the Bachelor’s degree • Minimum of ten years of relevant experience • A Master’s degree may substitute for two years • Demonstrated experience with DOE systems of record, including PAGE, IDW, iPortal, and BART, or comparable Federal grants, financial, and data warehouse systems • Experience extracting, cleaning, transforming, reconciling, and validating data across source systems • Experience building automated workflows and reducing manual, repetitive processes • Working knowledge of relational database concepts and query languages; ability to write and maintain queries independently • Experience developing dashboards and management reporting with visualizations, graphs, and charts • Ability to document processes and produce supportable SOPs • Strong written and verbal communication skills, including explaining data and analysis to non-technical audiences • Ability to work independently and manage concurrent priorities to deadlines • Preferred: Master’s degree in a related discipline • Preferred: Experience supporting SCEP or the Department of Energy • Preferred: Power BI, SQL, Microsoft Access, and advanced Excel • Preferred: Power Automate, Power Apps, or SharePoint workflow tools • Preferred: Python or comparable language for data pipelines • Preferred: Federal financial assistance data and award lifecycle knowledge • Preferred: Congressional, Inspector General, or Government Accountability Office data requests • Preferred: Common data model or shared reporting layer experience

🏖️ Benefits

• Remote work environment • 5% travel requirement