Data Analytics Engineer

Systems Planning and Analysis, Inc.; Indianapolis (IN); On-site; USD 110,000 - 150,000; Full time

Job summary

Intrepid, an SPA Company, seeks a Data Analytics Engineer to support USAFMCOM in Indianapolis, IN. You will contribute to the Strategic Initiatives Group, delivering analytics solutions to support the Warfighter mission.

Responsibilities include requirements analysis, data extraction from DJMS/IPPS-A, data modeling, and building dashboards with Power BI; on-site M-F. Qualifications: Bachelor's in a related field; 3–10 years in Power Platform, SQL, Python; Databricks; Army Vantage; data

Qualifications

• Bachelor's degree in a related field.
• 3–10 years of relevant work experience.
• 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.

Responsibilities

• Collaborate with stakeholders to gather and document business requirements.
• Design scalable and maintainable analytics solutions.
• Extract data from source systems (DJMS, IPPS-A, etc.).
• Load data into Databricks warehouse and clean for analysis.
• Build custom datasets for dashboard use.
• Create interactive dashboards and reports using Power BI.
• Conduct unit testing, integration testing, and UAT.
• Deploy solutions to production environments and ensure successful implementation.
• Provide ongoing support and maintenance for deployed solutions.
• Troubleshoot and resolve issues in a timely manner.
• Create and maintain comprehensive technical documentation.

Skills

Power Platform development

SQL

Python

Data cleansing

Data prep

Data translation

Education

Bachelor's degree in Math, Computer Science, Information Systems, 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) in Indianapolis, IN. You will be responsible for supporting data analytics and engineering efforts for the Strategic Initiatives Group (SIG).

Responsibilities

• 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

• This position is located in Indianapolis, IN. This position will require the candidate to go on-site M-F
• 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