Data Analyst & Technical Developer

Modern Technology Solutions, Inc. (MTSI) supports critical work for national defense and security, and builds teams that take ownership of meaningful outcomes. In this onsite role at Wright-Patterson AFB, OH, you will develop automated enterprise metrics and decision-ready data products for the Portfolio Advancement Enterprise (PAE) organization.

As the technical lead for the PAE Scorecard, you will collaborate with OSW and DAF teams to turn authoritative data sources into dashboards, pipelines, and workflows leadership can rely on. With 8–10 years of experience, you’ll help reduce manual reporting while improving how portfolio performance is measured across PAE Lines of Effort.

What you’ll do

• Use 8–10 years of technical data analytics and systems engineering experience to develop, refine, and instantiate enterprise metrics that objectively measure PAE portfolio performance using automated, authoritative data sources.
• Lead the PAE Scorecard effort by building, evolving, and maintaining data products aligned with PAE Lines of Effort in partnership with OSW and DAF teams.
• Analyze complex DoD/DAF database structures and acquisition enterprise systems to identify and validate authoritative sources of data for directorate- and department-level implementations.
• Design and maintain decision-ready Power BI dashboards, including advanced DAX logic, to support strategic metrics and leadership-driven priorities.
• Develop and manage SharePoint architectures (sites, lists, permissions, content structures, and automated workflows) to enable centralized data ingestion and intuitive interfaces for program office stakeholders.
• Create automated data pipelines and metric collection processes using Python, SQL, and Power Automate with sources such as Advana, reducing manual reporting requirements.

What you’ll need

• Active Secret clearance with the ability to obtain and maintain Top Secret
• Bachelor’s degree in engineering, data science, computer science, analytics, or related field (master’s preferred)
• 8–10 years of experience in data analytics, systems engineering, or technical development roles
• Experience with SAP environments and DoD enterprise data systems
• Expertise with Power BI, including advanced DAX modeling
• Proven ability to analyze complex databases and architect end-to-end data solutions
• Proficiency in Python, SQL, Power Automate, and other automation frameworks
• Strong communication skills and experience collaborating with senior leaders and technical teams

Preferred background

• Experience working within Air Force acquisition organizations
• Familiarity with Advana, DAVE, or other DoD enterprise data platforms
• Experience with cloud platforms or enterprise integration technologies
• SharePoint administration or development experience

Tools you’ll use

Power BI, DAX, Python, SQL, Power Automate, SharePoint, SAP, Advana

Benefits and culture

• Vacation: New hires accrue 20 days of PTO and 10 holidays per year
• Health insurance: Zero Deductible Health Plans
• Flexible schedules: Flex Schedules
• Professional development: Up to $10,000 annual education/training reimbursement
• ESOP: Funded Stock Ownership Plan
• 401k match+: 6% 401k match with immediate vesting
• Bonus program: Semi-Annual Bonus Opportunity
• Mentorship: Career mentorship programs
• Interesting work: Co-workers support some of the most important and critical programs to national defense and security
• Values: Employees come first
• 100% employee owned: You have a stake in each other’s success and the success of customers