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
Requirements
- Be proficient at using Power Query and Data Analysis Expressions (DAX).
- Understand and create efficient report data models. Understand basic relational database design: how data in one query or table relates to data in another.
- skills in Extract, Transform, Load (ETL) processes are essential for shaping data into a usable format.
- The ability to create clear and insightful visual representations of data.
- Proficiency in DAX for creating custom calculations in Power BI.
- Skills in using Power Query for data transformation.
- Intermediate SQL skills for querying and managing databases.
Responsibilities
- Study, analyze, and understand business requirements in the context of business intelligence.
- Design efficient data models that enable data analysis. Re-engineer existing data models for accuracy, maintainability, and clarity.
- Clean, shape, and transform data for meaningful insights.
- Build interactive and visually appealing dashboards and reports. Work with internal customers to fulfill needs for report content, format, and performance.
- 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.
- Apply principles of data modeling and report design as they relate to report performance. Measure key report performance indicators and optimize performance.
- Use Power BI to: Prepare the data, Model the data, visualize, and analyze data.
Other
- Remote - Some Travel
- Secret Clearance
- CompTIA Security+
- 4+ Years Power BI experience
- Employees of Agile Defense are our number one priority, and the importance we place on our culture here is fundamental. Our culture is alive and evolving, but it always stays true to its roots. Here, you are valued as a family member, and we believe that we can accomplish great things together. Agile Defense has been highly successful in the past few years due to our employees and the culture we create together. What makes us Agile? We call it the 6Hs, the values that define our culture and guide everything we do. Together, these values infuse vibrancy, integrity, and a tireless work ethic into advancing the most important national security and critical civilian missions. It's how we show up every day. It's who we are. We also believe in supporting our employees by offering a competitive and comprehensive benefits package. To explore the benefits we offer, please visit our website under the Careers section. Happy - Be Infectious. Happiness multiplies and creates a positive and connected environment where motivation and satisfaction have an outsized effect on everything we do. Helpful - Be Supportive. Being helpful is the foundation of teamwork, resulting in a supportive atmosphere where collaboration flourishes, and collective success is celebrated. Honest - Be Trustworthy. Honesty serves as our compass, ensuring transparent communication and ethical conduct, essential to who we are and the complex domains we support. Humble - Be Grounded. Success is not achieved alone, humility ensures a culture of mutual respect, encouraging open communication, and a willingness to learn from one another and take on any task. Hungry - Be Eager. Our hunger for excellence drives an insatiable appetite for innovation and continuous improvement, propelling us forward in the face of new and unprecedented challenges. Hustle - Be Driven. Hustle is reflected in our relentless work ethic, where we are each committed to going above and beyond to advance the mission and achieve success.
