Mid-Level Business Intelligence Developer

Fusion Technology•Washington, DC

21h•Onsite

About The Position

Fusion Technology is seeking a Business Intelligence Developer for a position located in Washington, DC. The developer will work on a combined IT Business Intelligence (ITBI) development and data science team to integrate business intelligence reporting capabilities, with a focus on IT, cybersecurity, and finance business data. The role builds, maintains, and improves products, primarily using the Power Platform, to collect data end to end, turn raw data into actionable insights through statistical analysis, KPI development, Power BI dashboards, and machine-learning methods, and automate common data-processing tasks. The developer also proposes, implements, and applies AI and machine-learning solutions to advance the Agency’s business intelligence capabilities. The developer develops analysis, queries, aggregations, visualizations, ETL processes, complex statements, scripts, stored procedures, and triggers, and implements business intelligence and data warehousing solutions. The role includes building and improving dashboards, applications, automations, service request portals, and visualizations in Power BI, Power Automate, Power Apps, SharePoint, and InfoPath. It also involves connecting to data through APIs, system-to-system connections, and manual transfers; developing predictive risk models; and applying AI and machine learning to extract insights from unstructured documentation, automate processes, and integrate with other applications. The developer carries out full-service data calls, including creating collection applications and forms, normalizing and cleansing data, and visualizing results. They produce analysis and visualizations for senior management, IT system owners, and Division and Field Office leaders; develop and improve methods and tools for assessing cybersecurity, financial, and strategic risk; research and recommend data storage and integration solutions; and develop user guides and product documentation. Work also includes regular and ad hoc data collection, maintaining Power Automations, integrating AI/ML into BI reporting, curating BI datasets, and developing or redeveloping quantitative risk assessment tools. Fusion Technology describes its compensation approach as comprehensive and tailored to employee needs. Its competitive package includes a matching 401(k), healthcare through Cigna, an employer contribution to a health savings account, vision and dental plans, life insurance, short- and long-term disability, personal leave, and paid certifications and training.

Requirements

An active TS clearance is required.
Bachelor’s degree from an accredited college or university in Cybersecurity, Information Technology, Computer Science, or a related field.
At least 5 years of experience supporting projects of similar size and scope.
Strong proficiency with the Power Platform, SharePoint, and InfoPath tool suite.
Familiarity with Oracle, SQL Server, Cognos, Tableau, and data science and business intelligence tools conventional to IT.
Certifications or past work may be used to demonstrate the required level of experience in lieu of years of experience.

Nice To Haves

Experience connecting to and extracting or manipulating data from Asset Management System (AMS), BigFix, Enterprise Process Automation System (EPAS), Facilities Integration Tool (FIT), Joint Cybersecurity Authorization and Management (JCAM), HR Source/HR Reports, Sentinel, Tenable, Unified Finance Management System (UFMS), Xacta, Microsoft Defender for Enterprise, JIRA, JIRA Service Manager, and CrowdStrike.

Responsibilities

Develop business intelligence solutions for IT, cybersecurity, and finance data as part of an ITBI development and data science team.
Build, maintain, and improve products in the Power Platform to collect data, produce business insights, and automate data-processing tasks.
Develop statistical analyses, KPIs, Power BI dashboards, queries, aggregations, visualizations, ETL processes, statements, scripts, stored procedures, and triggers.
Implement business intelligence and data warehousing solutions.
Build and improve dashboards, applications, and automations using Power BI, Power Automate, Power Apps, SharePoint, and InfoPath.
Connect to and integrate data using APIs, system-to-system connections, and manual data transfers.
Develop predictive risk models using statistical analysis and support data-driven solutions.
Identify and apply AI and machine-learning uses to analyze unstructured system documentation, automate processes, and integrate with other applications.
Conduct full-service data calls, including creating collection applications and forms, normalizing and cleansing data, and creating visualizations.
Create business intelligence analyses and visualizations for senior management, IT system owners, and Division and Field Office leaders.
Develop and improve methodologies and tools for assessing cybersecurity, financial, and strategic risk at system, division, branch, and enterprise levels.
Research and recommend business data storage and integration solutions for the IT environment.
Develop user guides and documentation for business intelligence products.
Collect data for regular and ad hoc data calls for internal and external customers.
Develop and enhance service request portals, dashboards, and visualizations that integrate data from SharePoint, applications, files, and internal and external sources.
Create and maintain Power Automations supporting multiple business processes; integrate AI/ML into BI reporting; cleanse and curate BI datasets; redevelop a quantitative cybersecurity risk assessment tool; and develop additional quantitative risk assessment tools.