Mid-Level Business Intelligence Developer

Fusion Technology; Washington (District of Columbia); On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

401K matching

Health plan (Cigna)

Health savings account

Vision and dental

Life insurance

Short/long-term disability

Paid certifications

Job summary

Fusion Technology is seeking a security-cleared ITBI Developer to join a data-driven team in Washington, DC. The role focuses on building BI products using Power Platform, SharePoint, and InfoPath, integrating IT, cybersecurity, and finance data into actionable insights.

You will develop ETL processes, dashboards, and ML-powered analyses, while leveraging APIs and system connections to automate data workflows and support data-driven decision making.

Qualifications

• Bachelor's degree in cybersecurity/IT/CS or related field is required.

Responsibilities

• Develops ITBI solutions focusing on IT, cybersecurity, and finance data.
• Builds dashboards and automations in Power Platform, SharePoint, and InfoPath.
• Performs ETL, data modeling, and data cleansing for BI workloads.
• Develops predictive models and applies AI/ML to BI tasks.
• Creates documentation and guides for BI products.

Skills

Power Platform

SharePoint

InfoPath

Data analytics

Cybersecurity concepts

Education

Bachelor's Degree in Cybersecurity, IT, CS, or related field

Tools

Oracle

SQL Server

Tableau

Cognos

JIRA

CrowdStrike

JCAM

Job description

Who is Fusion Technology?

Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Investigation's Criminal Justice Information Services Division's Headquarters. Founded in 2007 by an Engineer-by-trade, Fusion Technology dedicates our valuable resources to providing comprehensive IT services and solutions to mission-critical US Government programs and the Intel Community.

Position Location: Washington, DC

Who are you?

Security-cleared Professional: An active TS Clearance is required to be considered for this position.

Education and Experience: You have a Bachelor's Degree from an accredited college or university in Cybersecurity, Information Technology, Computer Science, or a related field.

• 5+ years of experience supporting project of similar size and scope.
• Strong proficiency with the Power Platform, SharePoint, and Infopath tool suite required. Familiarity with Oracle, SQL Server, Cognos & Tableau and data science and business intelligence tools conventional to IT required.
• Experience connecting to and extracting/manipulating data from the following systems strongly preferred:
  • 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.
• In absence of years of experience, certifications or past work may be used to show the level of experience needed to perform at this level.

What you'll do:

This position develops solutions as part of a combined IT Business Intelligence (ITBI) development and data science team working to integrate business intelligence reporting capabilities, with a particular focus on IT, cybersecurity, and finance business data. The developer builds, maintains, and improves products, primarily in the Power Platform suite, that facilitates comprehensive end-to-end data collection, transforms raw data into actionable business insights through statistical analysis, KPI development, PowerBI dashboarding, and proven machine learning methods, and reduces or eliminate manual effort in data processing by automating common processes. Furthers, proposes, implements, and leverages AI and ML solutions to advance the Agency's business intelligence capabilities. Develops analysis, query, aggregation, visualization, Extract/Transform/Load, complex statements, scripts, stored procedures, triggers, and implements business intelligence and data warehousing solutions.

• Builds, maintains, and improves dashboards, applications, and automations within the Power Platform (PowerBI, Power Automate, and PowerApps), SharePoint, and InfoPath environments to reduce or eliminate manual effort in data processing by automating common processes.
• Connects and leverages application programming interfaces (APIs), system-to-system connections, and manual transfer of data as part of business intelligence extract, transform, and load (ETL).
• Builds predictive risk models backed by statistical analysis and support data-driven solutions.
• Identifies and applies usages of AI and ML to extract key insights from unstructured system documentation for analysis, to automate of processes, and to integrate with other applications.
• Develops and carries out full-service data calls, including creation of collection applications and forms, data normalization, data cleansing, and visualization.
• Creates insightful and impactful business intelligence analysis and visualizations to be consumed by senior management, IT system owners, and Division and Field Office leaders.
• Develops and improves methodologies and tools to assess cybersecurity, financial, and strategic risk at the information system, division, branch, and enterprise level.
• Researches and recommends business data storage and data integration solutions specific to the IT environment.
• Develops user guides and documentation for business intelligence products.
• Works on data collection for regular and ad-hoc data calls for internal and external customers.
• Develops and enhances service request portals, dashboards and visualizations integrating business data from SharePoint, applications, files, and internal and external data sources.
• Creating and maintaining Power Automations supporting multiple business processes, integration of AI/ML into BI reporting, cleansing, and curation of business intelligence datasets, re-development of a quantitative cybersecurity risk assessment tool, and development of additional quantitative risk assessment tools.

What matters to you matters to us.

Fusion Technology values its employees and works hard to ensure proper care for them and their families. We desire to compensate employees in a competitive, motivational, fair, and equitable way with other employers in the marketplace. Salary is only one component of employee compensation but an integral part of recruiting and retaining qualified employees. However, at Fusion Technology, we take a comprehensive approach and consider each employee's needs to tailor a compensation plan that provides financial security and peace of mind.

• a best-in-class matching 401K program
• a comprehensive healthcare plan through Cigna
• a competitive employer contribution to a health savings account
• vision and dental plans
• life insurance
• short- and long-term disability
• personal leave
• in addition to paid certifications and training.

Fusion Technology LLC is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce. Qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law.