Senior Power BI Developer

- Insight Generation: 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. - AI/ML: Develop Python based models for predictive analytics, forecasting, classification, and operational optimization. Build and deploy ML workflows using appropriate libraries. 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).• Programming Languages: 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 (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.

The following reflects management’s definition of essential functions for this job but does not restrict the tasks that may be assigned. Management may assign additional duties and responsibilities to this job at any time due to reasonable accommodation or other reasons. - End-to-End Reporting: Design, develop, and maintain comprehensive Power BI reports and dashboards, managing the entire lifecycle from gathering business requirements to final visualization. - Data Transformation: 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.

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

- End-to-End Reporting: Design, develop, and maintain comprehensive Power BI reports and dashboards, managing the entire lifecycle from gathering business requirements to final visualization. - Data Transformation: 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. - Data Modeling: 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.

• 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).• Programming Languages: 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 (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. Must be a U.S. Citizen.