Senior Business Intelligence (BI) Developer

Overview

The Senior BI Developer will be responsible for transforming raw data into actionable business insights. They will lead the design, development, and deployment of end-to-end business intelligence solutions, utilizing expertise in data modeling, DAX, and Power Query for the Defense Threat Reduction Agency (DTRA).

Responsibilities

The following reflects management’s definition of essential functions for this job but does not restrict the tasks that may be assigned.  

• End-to-End Reporting: Design, develop, and maintain comprehensive Power BI reports and dashboards, managing the entire lifecycle from initial data connection to final visualization.
• Data Transformation: Utilize Power Query for advanced data cleaning and transformation, converting complex, unstructured data into clean, structured models.
• Data Modeling: Organize and connect different data sources efficiently so that reports load quickly and retrieve accurate information.
• Advanced Calculations: Write and maintain complex DAX and M-Query formulas, including calculated columns and measures, to support deep analytical requirements.
• Systems Integration: Manage data extraction and integration, with a specific focus on utilizing and pulling data from SharePoint Lists.
• Automation: Implement workflow automations using Power Automate to schedule data refreshes and trigger necessary alerts or notifications.
• Quality Assurance: Conduct rigorous validation checks to ensure absolute data accuracy, ensuring that dashboard metrics perfectly align with source files.
• Insight Generation: Analyze raw data sets to identify emerging trends, spot outliers, and deliver actionable insights to business stakeholders.

Qualifications

Skills/ Qualifications: 

• Power BI Mastery: Expert-level proficiency in building end-to-end reports and interactive visualizations.
• DAX & M-Query Language: Advanced proficiency in writing complex formulas, measures, and calculated columns.
• Data Modeling: Proven ability to structure and link data efficiently for optimal report performance.
• Expert Excel: Mastery of advanced Excel formulas and functions for data analysis and validation.
• SharePoint Lists: Specific expertise in creating, managing, and extracting data seamlessly from SharePoint environments.
• Data Analysis: Strong capability to examine raw data and synthesize it into clear trends, outliers, and actionable business intelligence.
• Data Accuracy: Meticulous attention to detail with a commitment to maintaining the highest standards of data integrity and consistency between dashboards and source systems.
• Power Automate: Working knowledge of Power Automate for automating data pipeline refreshes and notification triggers (Preferred).
• PL-300 or DA-100 Certification (Preferred). 

Education and Experience:

• Bachelor’s degree from an accredited college or university.
• A minimum of ten (10) years Federal Government experience as military, civilian, or contractor.
• Experience in Federal Government acquisition, financial management and/or audit readiness (Preferred).
• Power Query: Extensive experience in data cleaning, shaping, and transformation.
• Experience working with and briefing senior level DoD personnel; excellent verbal and written communication and organizational and interpersonal skills.
• Experience working in a time-sensitive environment with a high-level of accountability. 

Clearance Requirements: Must possess an active Secret security clearance and be eligible for immediate SCI nomination and indoctrination. Must be a U.S. Citizen. 

Physical Requirements: The ideal candidate must at a minimum be able to meet the following physical requirements of the job with or without a reasonable accommodation: 

• Ability to perform repetitive motions with the hands, wrists, and fingers. 
• Ability to engage in and follow audible communications in emergency situations. 
• Ability to sit for prolonged periods at a desk and working on a computer.