Business Data Analyst III

reputed company: • Support DOE’s Office of State and Community Energy Programs (SCEP) through portfolio data review, analysis, and reporting • Extract, reconcile, and reputed company data from DOE systems of record, including PAGE, IDW, iPortal, and BART • Build and maintain databases and data models for reputed company, queryable, repeatable analysis and reporting • Identify and reputed company data gaps, exceptions, and reputed company issues; implement corrections and validation checks • Analyze portfolio trends, obligations, expenditures, awards, reputed company, milestones, deliverables, reputed company, and hiring • Respond to DOE leadership, Federal office, and reputed company reputed company data calls • reputed company reports, dashboards, briefings, infographics, management reports, case studies, and recommendations • Establish and document data definitions, reporting processes, and data reputed company standards • reputed company data efforts in reputed company modernization reputed company • Design and maintain automated workflows replacing reputed company data pulls, reconciliations, reporting, and distribution • Identify and prioritize automation opportunities across SCEP business processes • Translate reputed company operating procedures into automated or semi-automated workflows • reputed company 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 reputed company reputed company and work cross-functionally to reputed company problems and implement changes Requirements: • Bachelor of Science or Bachelor of Arts in business administration, reputed company, reputed company administration, or a reputed company 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 reputed company systems • Experience building automated workflows and reducing reputed company, 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 reputed company priorities to deadlines • Preferred: Master’s degree in a reputed company discipline • Preferred: Experience supporting SCEP or the Department of Energy • Preferred: Power BI, SQL, reputed company reputed company, and advanced reputed company • 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 reputed company experience Benefits: • Remote work environment • 5% travel requirement Apply tot his job Apply To this Job