Data Analyst & Technical Developer

Modern Technology Solutions, Inc.; Fairborn (OH); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

ESOP

Flexible schedules

Educational reimbursement

Semi-annual bonus eligibility

Job summary

MTSI seeks a Data Analyst and Technical Developer with 8-10 years in technical data analytics, systems engineering, and enterprise data environments, ideally within DoD and SAP ecosystems. The role is a senior technical contributor building automated metrics and data products to support the PAE organization.

Responsibilities include leading the PAE Scorecard, designing DoD data solutions, building Power BI dashboards with advanced DAX, and developing data pipelines using Python, SQL, and Power

Qualifications

• 8-10 years in data analytics, systems engineering, or tech development roles.
• Experience with SAP environments and DoD enterprise data systems.
• Expertise with Power BI, including advanced DAX modeling.
• Strong ability to analyze complex databases and architect end-to-end data solutions.
• Proficiency in Python, SQL, Power Automate, and automation frameworks.

Responsibilities

• Develop, refine, and instantiate enterprise metrics using automated data sources.
• Lead PAE Scorecard efforts with OSW and DAF teams to maintain data products.
• Analyze complex DoD/DAF databases and authoritative data sources.
• Design and maintain Power BI dashboards with advanced DAX logic.
• Develop SharePoint architectures and automated workflows for stakeholders.
• Create automated data pipelines using Python, SQL, and Power Automate.

Skills

Data analytics

Systems engineering

Power BI

Python

SQL

Power Automate

SharePoint

DAX modeling

Education

Bachelor's in engineering

Master's preferred

Tools

Power BI

Python

SQL

Power Automate

SharePoint

Advana

SAP

Job description

MTSI is seeking a highly skilled Data Analyst and Technical Developer with 8-10 years of experience in technical data analytics, systems engineering, and enterprise data environments-preferably within the Department of Defense (DoD) and SAP-based ecosystems. The ideal candidate will serve as a senior technical contributor, developing automated, decision-quality metrics and data products that directly support the Portfolio Advancement Enterprise (PAE) organization. This role requires strong analytical acumen, advanced development capabilities, and an ability to work seamlessly with cross-functional teams across the Office of the Secretary of the Air Force (OSW), Department of the Air Force (DAF), and other stakeholder organizations.

Key Responsibilities

• Apply 8-10 years of technical data analytics and systems engineering experience to develop, refine, and instantiate critical enterprise metrics that objectively measure PAE portfolio performance using automated, authoritative data sources.
• Serve as the technical lead for the PAE Scorecard effort, collaborating with OSW and DAF teams to build, evolve, and maintain data products aligned with PAE Lines of Effort.
• 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, build, and maintain complex, decision-ready Power BI dashboards, including advanced DAX logic, to support strategic metrics and leadership-driven priorities.
• Develop and manage SharePoint architectures, including sites, lists, permissions, content structures, and automated workflows to provide centralized data ingestion points and intuitive user interfaces for program office stakeholders.
• Utilize advanced coding and scripting techniques - such as Python, SQL, and Power Automate - to create automated data pipelines and metric collection processes from systems like Advana, significantly reducing manual reporting requirements.

Required Qualifications

• Active Secret clearance with 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
• Demonstrated 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 ability to collaborate with senior leaders and technical teams

Desired Qualifications

• 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.

Interesting Work:

Our co-workers support some of the most important and critical programs to our national defense and security.

Values:

Our first core value is that employees come first. We challenge our co-workers to provide the highest level of support and service, and reward them with some of the best benefits in the industry.

100% Employee Owned:

We have a stake in each other's success, and the success of our customers. It's also nice to know what's going on across the company; we have company wide town-hall meetings three times a year.

Great Benefits - Most Full-Time Staff Are Eligible for:

• Starting PTO accrual of 20 days PTO/year + 10 holidays/year
• Flexible schedules
• 6% 401k match with immediate vesting up to $9k annually
• Semi-annual bonus eligibility (July and December)
• Company funded Employee Stock Ownership Plan (ESOP) - a separate qualified retirement account
• Up to $10,000 in annual educational reimbursement
• Other company funded benefits, like life and disability insurance
• Optional zero deductible Blue Cross/Blue Shield health insurance plan

Track Record of Success:

We have grown every year since our founding in 1993.

Modern Technology Solutions, Inc. (MTSI) is a 100% employee-owned engineering services and solutions company that provides high-demand technical expertise in Digital Transformation, Modeling and Simulation, Rapid Capability Development, Test and Evaluation, Artificial Intelligence, Autonomy, Cybersecurity and Mission Assurance

MTSI delivers capabilities to solve problems of global importance. Founded in 1993, MTSI today has employees at over 20 offices and field sites worldwide.

For more information about MTSI, please visit www.mtsi-va.com

MTSI embraces nine core values including our first core value of Employees come first. Consistent with our Core Values, we are committed to Equal Opportunity, making decisions without regard to race, color, religion, sex, national origin, age, military/veteran status, disability, or any other characteristics protected by applicable law. MTSI is committed to Equal Employment Opportunity and providing reasonable accommodations to applicants and employees with physical and/or mental disabilities.