Data Visualization, PowerBI Consultant - #24319

Data Visualization/PowerBI Consultant

Onsite at Camp Pendleton

105,000 - 125,000 

Due to the nature of the government contract US Citizenship AND an Active DOD Clearance is required

Position Description:

We are seeking a motivated Data Visualization/PowerBI Consultant to lead all matters related to Marine Corps Logistics and Financial data sources, database management and PowerBI reporting. This person will maintain a fully built-out database and apply basic principles, theories, and concepts to job assignments. Interface with internal and external stakeholders and make significant contributions to department goals and planning efforts. They will coordinate projects vertically and horizontally within a Major Subordinate Command Marine Corps staff. They will support the development and maintenance of scalable data stores that supply large amounts of data in forms needed for business analysis that leads to key leader decision making. This person will assist in the design of BI dashboards and reports for logistics and fiscal Key Performance Indicators (KPIs) and data analytics tools that are aligned and/or synchronized with Marine Corps Readiness optimization and Intermediate Supply and Maintenance production oversight in accordance with Marine Corps priorities. As required, they will provide training to the personnel on developed products and utilization of reports and tools.

• Manage progress on the project assigned and report closely to superior on project status.
• Troubleshoot data issues by tracing the data flow and identifying the root of cause.
• Maintain SQL queries for ad-hoc reports.
• Maintain and enhance stored procedures for production databases.
• Perform testing on customized in-house developed web-based analytical software.
• Improve the plan/process of a project to maximize efficiency by minimizing the time and effort needed.
• Confer with stakeholders to analyze current operational procedures, identify problems, and learn specific input and output requirements.
• Validate and analyze data and convert from raw data to analytical reports for decision-making purposes.
• Create schema objects such as attributes, facts, logical views, user hierarchies and transformations using Data Visualization tool (i.e. Power BI).
• Create public objects such as metrics, filters, prompts, consolidations, custom groups, reports and documents based on client's requirements using Power Bi.
• Develop and maintain document services reports based on client's requirements.
• Develop and maintain custom reports to combine the data sets of multiple reports and also create customized dashboards and scorecards using report services.
Required qualifications to be successful in this role:
• 2+ years of operating experience with SQL & PowerBI
• Increasing responsibilities in design and/or maintenance of complex electronic systems.
• Familiar with Design and Development Software Process Activities including Waterfall and Agile Design Processes as well as familiarization with the design and development of databases.
• Progressive experience in design and installation of integrated systems of personnel, materials, machinery, and/or equipment.
• Knowledge of both logical and physical data modeling.

Preferred:
• Familiarity of DoD Logistics and Supply Chain operations with working knowledge of recent developments and policies of issues affecting Marine Corps Supply and Maintenance Activity that may impact Marine Corps Military Equipment Readiness a plus.

Work Type:

OnSite - Camp Pendleton, CA

Clearance Requirements:

Secret or ability to achieve.