Data Analytics Engineer

Systems Planning & Analysis; Indianapolis (IN); Remote; USD 123,000 - 146,000; Full time

Job summary

Systems Planning & Analysis seeks a Data Analytics Engineer to support US Army Financial Management Command initiatives. You will extract and prepare data (DJMS, IPPS-A), build scalable analytics, and develop Power BI dashboards for decision support.

You'll collaborate with stakeholders, ensure security clearances, and deploy robust analytics solutions with thorough documentation for end-users.

Qualifications

• Bachelor's degree in Math, CS, IS, Data Science, or related field.
• 3+ years of Power Platform development (Apps, Automate, BI).
• 3+ years of SQL experience.
• 3+ years of Python experience.
• Experience with Databricks Data Intelligence Platform.
• Familiarity with Army Vantage and data cleansing/prep/translation.
• Active Secret security clearance.

Responsibilities

• Collaborate with stakeholders to gather business requirements.
• Design scalable analytics solutions and data models.
• Extract data from source systems (DJMS, IPPS-A, etc.).
• Load data into Databricks warehouse and clean for analysis.
• Build datasets for dashboards and reports.
• Create Power BI dashboards and reports.
• Conduct testing (unit, integration, UAT) and deploy to production.
• Provide ongoing maintenance and user guides for solutions.

Skills

Power Platform development

SQL

Python

Databricks

Army Vantage

Data cleansing

Education

Bachelor's degree in Math, Computer Science, Information Systems, Data Science, or related field

Tools

Power Platform (Apps/Automate/BI)

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.

Data Analytics Engineer

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

• 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
  

Pay Range Information

At SPA, we strive to deliver a robust total compensation package that will attract and retain top talent. Elements of the compensation package include competitive base pay and variable compensation opportunities. SPA provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health insurance, flexible spending accounts, health savings accounts, retirement savings plans, life and disability insurance programs, and a number of programs that provide for both paid and unpaid time away from work. The specific programs and options available to any given employee may vary depending on eligibility factors such as geographic location, date of hire, etc. Please note that the salary information shown below is a general guideline only. Salaries are commensurate with experience and qualifications, as well as market and business considerations. , Pay Transparency Salary range: USD $123,054.23/Yr. - USD $145,681.60/Yr.