Today
Top Secret
Unspecified
Unspecified
IT - Data Science
Washington, DC (On-Site/Office)
TMC Technologies is in search of a Business Intelligence/ETL Developer to join our team in providing information technology (IT) support services to the Federal Bureau of Investigation (FBI), under the Office of The Chief Information Officer (OCIO). This is an active bid and contract award is expected in October 2025. The candidate must be a US citizen and possess a minimum of an active Top Secret clearance to start due to federal contract requirements.
The Business Intelligence/ETL Developer will have the following responsibilities:
- 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 FBI 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 FBI 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 11. 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.
Job Requirements
US Citizenship and active Top Secret clearance required
Minimum of 5 years' experience supporting project of similar size and scope required.
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 FBI 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.
We are equal opportunity/affirmative action employers, committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability, or protected veteran status, or any other protected characteristic under state or local law.
The Business Intelligence/ETL Developer will have the following responsibilities:
- 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 FBI 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 FBI 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 11. 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.
Job Requirements
US Citizenship and active Top Secret clearance required
Minimum of 5 years' experience supporting project of similar size and scope required.
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 FBI 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.
We are equal opportunity/affirmative action employers, committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability, or protected veteran status, or any other protected characteristic under state or local law.
group id: 10205365
