Senior Business Intelligence (BI) Developer

TheSenior BI Developer willbe 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).

The following reflects managements 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.

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:

• Bachelors degreefrom 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 andwritten communication and organizational and interpersonal skills.
• Experience working in a time-sensitive environment with a high-level of accountability.

Clearance Requirements: Must possessan active Secret security clearance and be eligible for immediate SCInomination 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.