Mid-Level Business Intelligence Developer

Fusion Technology; Washington; On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

a best-in-class matching 401K program

a comprehensive healthcare plan

a competitive employer contribution to

vision and dental plans

life insurance

short- and long-term disability

personal leave

paid certifications and training

Job summary

Fusion Technology seeks a security-cleared professional to join our ITBI/Data Science team in Washington, DC. You will build and automate BI solutions using Power Platform, SharePoint, and InfoPath to transform data into actionable insights.

Responsibilities include dashboards, ETL, AI/ML integration, and data visualization for IT, cybersecurity, and finance data. A Bachelor's degree and 5+ years' experience are expected, along with a TS clearance.

Qualifications

• Active TS clearance required for consideration.
• Bachelor's degree in Cybersecurity, IT, CS or related field.
• 5+ years of experience supporting projects of similar size and scope.
• Strong proficiency with Power Platform, SharePoint, and InfoPath; familiarity with Oracle, SQL Server, Cognos & Tableau.
• Experience connecting to and extracting data from listed systems such as AMS, BigFix, EPAS, FIT, JCAM, HR reports, Sentinel, Tenable, UFMS, Xacta, Defender for Enterprise, JIRA, JIRA Service Manager, and CrowdStrike.
• Certifications or past work may substitute years of experience.

Responsibilities

• Develop BI solutions focusing on IT, cybersecurity, and finance data.
• Build, maintain and improve dashboards, apps, and automations in Power Platform, SharePoint, and InfoPath.
• Connect APIs and ETL processes to integrate data sources.
• Develop predictive risk models with statistical analysis.
• Apply AI/ML to extract insights from unstructured documents.
• Create data collection apps, forms, normalization and visualization.
• Produce BI analyses for senior management and IT owners.
• Develop data storage and integration methodologies for IT environments.
• Prepare user guides and documentation for BI products.
• Support data calls and visualization projects for internal/external customers.

Skills

Power Platform

SharePoint

InfoPath

Oracle

SQL Server

Cognos

Tableau

Data science tools

Education

Bachelor's degree in Cybersecurity, Information Technology, Computer Science, or related field

Tools

JIRA

JIRA Service Manager

CrowdStrike

BigFix

Xacta

UFMS

Sentinel

EPAS

FIT

JCAM

AMS

Microsoft Defender for Enterprise

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.