Data Analytics Engineer

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.

The analytics engineer will be responsible for aggregating data from various sources and files and loading into the cloud data warehouse (Databricks). They will also be responsible for cleaning the data, prepping the sources, and building out the visualizations to the end user spec. Additionally, they will be working with the various directorates for user/developer training on the tools and ad hoc analysis.

1. Requirement Analysis:
• Collaborate with stakeholders to gather and document business requirements.
• Conduct feasibility studies and provide recommendations for analytics solutions.
2. Solution Design:
• Design scalable and maintainable analytics solutions.
• Develop technical specifications and data models.
3. 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.
4. Testing and Deployment:
• Conduct unit testing, integration testing, and user acceptance testing (UAT).
• Deploy solutions to production environments and ensure successful implementation.
5. 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.
6. 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.

Required 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
• Minimum of 5 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)
• 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