At Agile Defense we know that action defines the outcome and new challenges require new solutions. That’s why we always look to the future and embrace change with an unmovable spirit and the courage to build for what comes next.
Our vision is to bring adaptive innovation to support our nation's most important missions through the seamless integration of advanced technologies, elite minds, and unparalleled agility—leveraging a foundation of speed, flexibility, and ingenuity to strengthen and protect our nation’s vital interests.
Requisition #: 1353
Job Title: Power BI Developer
Location: Remote - Some Travel
Clearance Level: Secret
Required Certification(s): CompTIA Security+
SUMMARY
Power BI is a unified, scalable platform for self-service and enterprise business intelligence. The Marine Corps provides an enterprise package for M365 including Power BI via Power BI service. Marine Forces Reserve IMKM acts as the lead agent for Marine Forces Reserve Power BI products, developing MFR governance based on Marine Corps guidance/policy.
Power BI uses customer data in the form of reports to create a visual representation allowing decision makers the ability to make more informed decisions. Information Management/Knowledge Management uses Power BI to support its customers in MARFORES. IMKM assumes all permission rights for any published reports and provides view access reports as determined by the report owner.
Marine Forces Reserve IMKM supports a significant Power BI product line including dozens of reports in production supporting customers across the following MFR and MSC Staff sections. The Power BI team manages all relevant workspaces (Development, Test, and Production), develops, and manages production dataflows, reports, and data sources. A Power BI team member needs to have expertise in understanding customer requirements and how to translate the requirement into an actionable decision support tool. The developer must also be expert in determining how to access, transfer, import, and process the necessary data with data sources ranging from local files stored on Teams or automatic data feeds from DOD/DON/USMC Programs of Record into the Marine Forces Reserve IMKM SQL data warehouse, each with unique technological processing capabilities. The developer, in concert with the IMKM Data Architects, must tailor each feed to optimally meet the requirement including the need to develop interfaces with on premise sources, then transfer the data to cloud-based services via the Marine Corps Operational Data Gateway
JOB DUTIES AND RESPONSIBILITIES
Business Requirements Analysis: Study, analyze, and understand business requirements in the context of business intelligence.
Collaboration: Work with data owners and internal customers, and with the technology team and other developers to build effective solutions that meet the needs of the organization.
Data Modeling: Design efficient data models that enable data analysis. Re-engineer existing data models for accuracy, maintainability, and clarity.
Data Transformation: Clean, shape, and transform data for meaningful insights.
Report and Dashboard Creation: Build interactive and visually appealing dashboards and reports. Work with internal customers to fulfill needs for report content, format, and performance.
Data Integration: Integrate data from various sources to create comprehensive reports. Understand data source platforms sufficiently to ensure data connections are secure and efficient and understand security to provide necessary data access and no more than necessary.
Performance: Apply principles of data modeling and report design as they relate to report performance. Measure key report performance indicators and optimize performance.
Decision Making: Understand organizational data sources and data needs and present data to aid in better decision-making.
Working with available data and applying domain expertise, design and deliver report visualizations to generate actionable insights.
Provide meaningful business value through easy-to-comprehend data visualizations.
Work closely with business stakeholders to identify business requirements.
Collaborate with users, analytics engineers, and data engineers to identify and acquire data.
Use Power BI to: Prepare the data, Model the data, visualize, and analyze data.
Establish and utilize roles to manage permissions and view access to secure Power BI reports for respective users.
Research Power BI Power Query translations issues for editing queries.
Utilize enterprise security classification requirements when working with sensitive information.
Troubleshoot instances of Power BI reports not updating properly.
Develop tutorials/content for IM/KM library on various Power BI topics for end user reference including Bar Graph Design, Power Data Source Connections, Data Transformation in Power BI.
QUALIFICATIONS
Required Certifications
CompTIA Security+
Education, Background, and Years of Experience
4+ Years Power BI experience
ADDITIONAL SKILLS & QUALIFICATIONS
Required Skills
Analytical Abilities: Advanced analytical skills to interpret and analyze complex data sets.
Be proficient at using Power Query and Data Analysis Expressions (DAX).
Troubleshooting, as required, for all issues associated with reports, including external data connections & data sources.
Communication and Collaboration: Effective communication skills to work effectively with stakeholders and team members.
Problem-Solving: Ability to troubleshoot and solve data-related issues efficiently.
Adaptability: ability and attitude to thrive in a fast-moving environment.
Technical Skills
Data Modeling: Understand and create efficient report data models. Understand basic relational database design: how data in one query or table relates to data in another.
Data Transformation: skills in Extract, Transform, Load (ETL) processes are essential for shaping data into a usable format.
Data Visualization: The ability to create clear and insightful visual representations of data.
DAX (Data Analysis Expressions language): Proficiency in DAX for creating custom calculations in Power BI.
Power Query (M language): Skills in using Power Query for data transformation.
SQL: Intermediate SQL skills for querying and managing databases.
Programming Skills: Experience with JSON, XML and HTML. Experience with PowerShell is helpful. Experience with .NET, JavaScript, C#, and/or RESTful Web Services is helpful.
Power BI Platform Knowledge: familiarity with Power BI Admin APIs, Power BI Activity Logs, Power BI Service Administration, Power BI Governance and Security, Power BI Solution development, and Power BI Report Server administration.
Preferred Skills
Microsoft Certified: Power Platform Fundamentals
Microsoft Certified: Security, Compliance, and Identity Fundamentals
Microsoft Certified: Power BI Data Analyst Associate
Microsoft Certified: Azure Data Fundamentals
Microsoft Certified: Power Platform Developer Associate
WORKING CONDITIONS
Environmental Conditions
Sitting, typing, reading, some travel.
Strength Demands
Minimal
Physical Requirements
Minimal