Data Analytics Engineer — DoD Data, Power BI & Databricks

Systems Planning & Analysis, Inc.; Indianapolis (IN); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Intrepid, an SPA Company, seeks a Data Analytics Engineer to support USAFMCOM in Indianapolis, IN. You will analyze data, design scalable analytics solutions, and build dashboards using Power BI.

Responsibilities include extracting data from DJMS and IPPS-A, loading into Databricks, creating custom datasets, performing testing, deploying solutions to production, and maintaining documentation. On-site M-F; active Secret clearance required.

Qualifications

• Bachelor's degree in Math, Computer Science, Information Systems, Data Science, or related field.
• 3+ years Power Platform development (Apps, Automate, BI), SQL, and Python.
• Experience with Databricks and Army Vantage.
• Data cleansing, prep, and data translation.
• Active Secret security clearance; on-site Indianapolis, M-F.

Responsibilities

• Collaborate with stakeholders to gather and document business requirements.
• Design scalable analytics solutions and data models.
• Extract data from source systems (DJMS, IPPS-A, etc.).
• Load the data into Databricks warehouse and clean for analysis.
• Build custom datasets for dashboard use and create Power BI reports.
• Perform unit, integration, and user acceptance testing; deploy to production.
• Maintain comprehensive technical documentation and end-user guides.

Skills

Power Platform development (Apps Autom

SQL

Python

Data cleansing

Data prep

Data translation

Problem solving

Communication

Security clearance

Education

Bachelor's degree in Math, CS, IS, Data Science, or related field

Tools

Databricks

Army Vantage

Job description

Overview

Intrepid, an SPA Company, brings more than 20 years of experience supporting the Department of Defense and U.S. Government, consistently setting the standard for excellence in the federal marketplace. Committed to advancing the mission of the U.S. Warfighter, Intrepid leverages technological superiority to deliver innovative solutions across air, space, land, and sea domains. We are proud to foster a collaborative, dynamic work environment, offering competitive compensation and an industry-leading 401k contribution. Our team is built through merit and achievement, and we’re always looking for the best and brightest to join us in our growth. We treat our people like family, we are mission-focused, and we give back! Join us today.

We are seeking a skilled Data Analytics Engineer to join our team to support the U.S. Army Financial Management Command (USAFMCOM). You will be responsible for supporting data analytics and engineering efforts for the Strategic Initiatives Group (SIG).

Responsibilities

The Data Analytics Engineer will be responsible for supporting various data analytics efforts across USAFMCOM, specifically for the Strategic Initiatives Group (SIG). The enineer will be responsible for, but not limited to:

1. Requirement Analysis:

• Collaborate with stakeholders to gather and document business requirements.
• Conduct feasibility studies and provide recommendations for analytics solutions.

Solution Design:

• Design scalable and maintainable analytics solutions.
• Develop technical specifications and data models.

Development:

• Extract data from source systems (DJMS, IPPS-A, etc.).
• Load the data into Databricks warehouse and clean for analysis.
• Build custom datasets for dashboard use.
• Create interactive dashboards and reports using Power BI.

Testing and Deployment:

• Conduct unit testing, integration testing, and user acceptance testing (UAT).
• Deploy solutions to production environments and ensure successful implementation.

Maintenance and Support:

• Provide ongoing support and maintenance for deployed solutions.
• Troubleshoot and resolve issues in a timely manner.
• Implement enhancements and updates as needed.

Documentation:

• Create and maintain comprehensive technical documentation for all developed solutions, to include business requirements, technical specifications, architecture diagrams and design documents, and deployment/implementation plans.
• Provide user guides and training materials for end-users.

Qualifications

Required Qualifications:

This position is currently advertised as remote, but on-site requirement for this position is subject to change.

• Bachelor's degree in Math, Computer Science, Information Systems, Data Science, or related field
• 3-10 years of relevant work experience to include:
  • 3+ years of experience in Power Platform development (Apps, Automate, BI)
  • 3+ years of experience with SQL
  • 3+ years of experience with Python
  • Databricks (Data Intelligence Platforms)
  • Army Vantage
  • Data cleansing, data prep, and data translation
• Excellent problem-solving skills and attention to detail, and strong verbal and written communication skills.
• Ability to handle delegated tasks and development
• Active Secret security clearance

Desired Qualifications:

• Experience supporting DoD stakeholders and leadership