Senior Power BI Developer

Na Ali'i Consulting & Sales, LLC. • Fort Belvoir, VA

5h • $150,000 - $175,000 • Onsite

About The Position

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). This is a temporary 6-month position.

Requirements

• Expert-level proficiency in building end-to-end reports and interactive visualizations.
• Advanced proficiency in writing complex DAX and M-Query formulas, measures, and calculated columns.
• Proven ability to structure and link data efficiently for optimal report performance.
• Mastery of advanced Excel formulas and functions for data analysis and validation.
• Specific expertise in creating, managing, and extracting data seamlessly from SharePoint environments.
• Strong capability to examine raw data and synthesize it into clear trends, outliers, and actionable business intelligence.
• Meticulous attention to detail with a commitment to maintaining the highest standards of data integrity and consistency between dashboards and source systems.
• Bachelor’s degree from an accredited college or university.
• A minimum of ten (10) years Federal Government experience as military, civilian, or contractor.
• Extensive experience in data cleaning, shaping, and transformation using Power Query.
• 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.
• Must possess an active Secret security clearance.
• Must be a U.S. Citizen.

Nice To Haves

• Working knowledge of Power Automate for automating data pipeline refreshes and notification triggers.
• Experience with programming languages such as Python with a focus on Pandas and Tensor Flow libraries to assist with NLP.
• PL-300 or DA-100 Certification.
• Experience in Federal Government acquisition, financial management and/or audit readiness.

Responsibilities

• Design, develop, and maintain comprehensive Power BI reports and dashboards, managing the entire lifecycle from gathering business requirements to final visualization.
• Utilize Power Query for advanced data cleaning and transformation, converting complex, structured and unstructured data into clean, structured models. Ensuring data quality, consistency, governance, and security across enterprise systems.
• Develop and maintain data models. Design, develop, and maintain ETL/ELT processes to integrate data from multiple sources efficiently so that reports load quickly and retrieve accurate information.
• Write and maintain complex DAX and M-Query formulas, including calculated columns and measures, to support deep analytical requirements.
• Manage and automate data collection, transformation, validation, extraction and integration, with a specific focus on utilizing and pulling data from Microsoft Platform Solutions.
• Implement workflow automations using Power Automate to schedule data refreshes and trigger necessary alerts or notifications.
• Conduct rigorous validation checks to ensure absolute data accuracy, ensuring that dashboard metrics perfectly align with source files. Establish reporting standards, KPIs, and data visualization best practices.
• Analyze raw data sets to identify emerging trends, spot outliers, and deliver actionable insights to business stakeholders. Enhance adoption of self-service analytics throughout the organization.
• Develop Python based models for predictive analytics, forecasting, classification, and operational optimization. Build and deploy ML workflows using appropriate libraries.

Benefits

• The projected compensation range for this position is $150,000.00 to $175,000.00 (annualized USD).
• The salary range displayed represents the typical salary range for this position and is just one component of Nakupuna Companies total compensation package for employees.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior