Overview: LMI is seeking a Data Analyst to perform information technology related requirements as part of an integrated team supporting for the Department of Defense, United States Transportation Command. The position requires proficiency in physical data modeling and any major BI Visualization tool. Work will be performed at Scott AFB, IL and in the vicinity of OFallon, IL.
At LMI, were reimagining the path from insight to outcome at The New Speed of Possible. Combining a legacy of over 60 years of federal expertise with our innovation ecosystem, we minimize time to value and accelerate mission success. We energize the brightest minds with emerging technologies to inspire creative solutioning and push the boundaries of capability. LMI advances the pace of progress, enabling our customers to thrive while adapting to evolving mission needs.
Responsibilities:
Designs and builds automated data and ETL pipelines from multiple real-time and static data sources.
Works with key stakeholders to develop and document data requirements.
Works iteratively while constantly taking into account customer feedback to develop and refine data visualization dashboards.
Creates data orchestration workflows to ensure data visualization dashboards display the latest data.
Takes business requirements and identifies key data sources to support stakeholder needs.
Participates in Agile/Scrum ceremonies and provides updates to teammates and stakeholders as needed.
Works collaboratively with fellow teammates to ensure best practices and efficient techniques are used.
Qualifications:
Bachelor's in Computer Science, Information Systems, Engineering, Business, Social Science, or other related analytical, scientific, or technical disciplines or equivalent years of experience
3-5 years experience building automated ETL data-pipelines, using: Python, Pandas, Dataframes, or Pyspark. Familiarity with Databricks a plus.
3-5 years of SQL experience including: Data Definition Language (DDL) and/or Data Manipulation Language (DML).
3-5 years of MS Excel experience
3-5 years of experience deriving business use case requirements
3-5 years of Business Intelligence and Visualization experience using tools such as: Qlik, Tableau, or PowerBI.
3-5 years working in an Agile/Scrum environment
3-5 years using MS Teams / SharePoint
Experience building physical data models/database design, preferred
Experience working with DoD preferred, but not necessary
Must possess an active SECRET US Government clearance

Job Description:
Conducts data analytics to provide information and insights to stakeholders for decision-making or solution development. Implements data standards and deploys automation tools to extract, synthesize, and validate data from different sources and transform data into usable metrics. Collaborates with OCM specialist and stakeholders to understand stakeholder needs, objectives, and requirements. Constructs data sets, monitors data quality, troubleshoots and resolves database issues to ensure data integrity. Utilizes scripting and querying tools like Python, R or SQL, data visualization/BI tools, statistical methods, and data modeling to produce reports, data files, and dashboards. Administers post-implementation surveys and monitors to collect data, perform analysis and measure the results of changes. Helps to identify and categorize all stakeholders affected by the change. Analyzes the impact of proposed changes on various aspects of the organization, including processes, systems, culture, and people. Typically reports to the contractor's program manager and/or the Senior OCM Analyst/Consultant.
Experience Requirements:
7 years relevant experience
Mandatory: Yes
Preferred: USTRANSCOM experience
Certification Requirements: N/A
Education Requirements:
Bachelor's Degree
Mandatory: Yes
Work Type:
Hybrid - Scott AFB, IL (within 50 miles)
Clearance Requirements:
Secret Clearance is required

Overview: LMI is seeking a Data Analyst to perform information technology related requirements as part of an integrated team supporting for the Department of Defense, United States Transportation Command. The position requires proficiency in physical data modeling and any major BI Visualization tool. Work will be performed at Scott AFB, IL and in the vicinity of OFallon, IL. At LMI, were reimagining the path from insight to outcome at The New Speed of Possible. Combining a legacy of over 60 years of federal expertise with our innovation ecosystem, we minimize time to value and accelerate mission success. We energize the brightest minds with emerging technologies to inspire creative solutioning and push the boundaries of capability. LMI advances the pace of progress, enabling our customers to thrive while adapting to evolving mission needs. Responsibilities: <ul> <li>Designs and builds automated data and ETL pipelines from multiple real-time and static data sources. </li><li>Works with key stakeholders to develop and document data requirements. </li><li>Works iteratively while constantly taking into account customer feedback to develop and refine data visualization dashboards. </li><li>Creates data orchestration workflows to ensure data visualization dashboards display the latest data. </li><li>Takes business requirements and identifies key data sources to support stakeholder needs. </li><li>Participates in Agile/Scrum ceremonies and provides updates to teammates and stakeholders as needed. </li><li>Works collaboratively with fellow teammates to ensure best practices and efficient techniques are used. </li></ul> Qualifications: <ul> <li>Bachelor's in Computer Science, Information Systems, Engineering, Business, Social Science, or other related analytical, scientific, or technical disciplines or equivalent years of experience </li><li>3-5 years experience building automated ETL data-pipelines, using: Python, Pandas, Dataframes, or Pyspark. Familiarity with Databricks a plus. </li><li>3-5 years of SQL experience including: Data Definition Language (DDL) and/or Data Manipulation Language (DML). </li><li>3-5 years of MS Excel experience </li><li>3-5 years of experience deriving business use case requirements </li><li>3-5 years of Business Intelligence and Visualization experience using tools such as: Qlik, Tableau, or PowerBI. </li><li>3-5 years working in an Agile/Scrum environment </li><li>3-5 years using MS Teams / SharePoint </li><li>Experience building physical data models/database design, preferred </li><li>Experience working with DoD preferred, but not necessary </li><li>Must possess an active SECRET US Government clearance </li> </ul>

<h3>Job Description</h3><div>Job Description<div>Air Transportation Data Analyst 1: Will demonstrate in-depth functional knowledge of AMC airlift operations and is highly proficient with utilizing GATES applications. An ideal candidate will possess over eight years of experience serving within an Aerial Port, Air Mobility Squadron, Air Transportation Function (ATF), or Contingency Response Wing (CRW) with routine exposure to manual and automated air manifesting procedures, pax service operations, anti-hijacking screening, mishandled baggage processing, and ITV systems to include- but not limited to- GATES, IGC, GDSS, e-APIS, and e-Secure Flight (eSF). An Air Transportation Data Analyst will initially possess a basic understanding of APS/AMS Data Records functions and will be trained to efficiently troubleshoot and/or resolve TWCF reconciliation requirements. An associate's or bachelor's degree is preferred, however, the OTS Team will prioritize logistics experience and/or the attendance of a 2T2/2T0 technical school. Air Transportation (2T2) subject matter expertise and intermediate computer literacy are paramount to promptly resolving manifesting, passenger vetting, workload reporting, and GATES-user issues experienced 24/7 by the global Port Dawg community. Position OverviewProvide professional and functional subject matter expertise for operational end users in the Remote Manifesting Resolution Center (RMRC) and associated support tools for application functionality, related user productivity (e.g. optimization of workload and application utility) and end user assistance with maximizing In-transit Visibility (ITV) of real world and exercise passenger/cargo operations.Duties and Responsibilities:Within the RMRC, the Air Transportation Specialist will:<ul><li>Maintain cargo/passenger screening and manifesting applications in support of Air Mobility Command (AMC) Aerial Ports and designated USAF operational scenarios/locations where logistics personnel do not have access to automated In-Transit Visibility (ITV) systems</li><li>Apply USAF Transportation (2TXXX) and/or global mobility Subject Matter Expertise (SME) to resolve general air manifesting, workload reporting, record keeping, and GATES-user problems experienced by the Air Transportation community</li><li>Facilitate overall process improvements for data collection, input, analysis, reconciliation, and record keeping processes for Air Terminal Records and Reporting functions world-wide</li></ul>Basic Qualifications:<ul><li>In-depth knowledge of USAF Aerial Port, Air Mobility, (APS/AMS) or Logistic Readiness Squadron (LRS) cargo and passenger movement operations</li><li>Proficient using the Global Air Transportation Execution System (GATES)</li><li>Familiar with In-Transit Visibility (ITV) systems that support global AMC operations</li><li>Skilled with Air Freight automated and manual manifesting requirements</li><li>Experience with Passenger Service Operations to include passenger anti-hacking/screening, manifesting, lost baggage, and Customer Identification Codes (CIC)</li><li>Knowledgeable of Over/Short Shipment Reports, Monthly Station Traffic Handling Reports, and GATES cargo/passenger queries</li><li>Understanding of Customs and Border Protection requirements for flights departing/entering the United States</li><li>Basic understanding of Transportation Working Capital Fund (TWCF) and Air transportation billing/reconciliation requirements</li></ul>Desired Skills:Familiarity with operations of all or some of the following software applications:<ul><li>Global Air Transportation Execution System (GATES)</li><li>Integrated Development Environment GTN Conveyance (IGC)</li><li>Electronic Advance Passenger Information System (eAPIS)</li><li>eSecure Flight</li><li>Transportation Management System (TMS)</li><li>Defense Enterprise Accounting and Management System (DEAMS)</li><li>Distribution Component Billing System (DCBS)</li><li>Global Decision Support System (GDSS)</li><li>C2Remedy</li><li>Hyperion</li><li>Toad Data Point</li><li>Microsoft Office products</li><li>SharePoint</li></ul>Education<ul><li>Associates in relevant technical field or additional 2 years' experience</li><li>Secret Clearance</li></ul></div></div>

Job Description: Conducts data analytics to provide information and insights to stakeholders for decision-making or solution development. Implements data standards and deploys automation tools to extract, synthesize, and validate data from different sources and transform data into usable metrics. Collaborates with OCM specialist and stakeholders to understand stakeholder needs, objectives, and requirements. Constructs data sets, monitors data quality, troubleshoots and resolves database issues to ensure data integrity. Utilizes scripting and querying tools like Python, R or SQL, data visualization/BI tools, statistical methods, and data modeling to produce reports, data files, and dashboards. Administers post-implementation surveys and monitors to collect data, perform analysis and measure the results of changes. Helps to identify and categorize all stakeholders affected by the change. Analyzes the impact of proposed changes on various aspects of the organization, including processes, systems, culture, and people. Typically reports to the contractor's program manager and/or the Senior OCM Analyst/Consultant. Experience Requirements: 7 years relevant experience Mandatory: Yes Preferred: USTRANSCOM experience Certification Requirements: N/A Education Requirements: Bachelor's Degree Mandatory: Yes Work Type: Hybrid - Scott AFB, IL (within 50 miles) Clearance Requirements: Secret Clearance is required

NextGen Federal Systems, LLC (NextGen) is seeking several Data Analysts to work on our Operational Analysis Support contract in the 618th Air Operations Center at Scott AFB. Data Analysts will focus on AMC missions such as contingency force movement, tanker, passenger, and cargo information to tell AMC's true story. They will assist the 618 AOC (TACC), 18 AF, AMC and USTRANSCOM by developing requirements, business rules, and metrics which capture and analyze data in light of system changes or deficiencies. They will create predictive analytics, to scientifically measure demand against capacity and drive the strategies to mitigate excessive demand in order to satisfy customer requirements and achieve national objectives.Primary Work Location: Scott AFB ILSpecific Experience: <ul><li>Demonstrated experience collecting, analyzing, and reporting airlift, aerial refueling or similar data for customers</li><li>Experience with air transportation systems, such as GDSS, GATES, SMS, JOPES, and GTN or similar Federal or commercial systems</li><li>Skilled in transportation policies, procedures, concepts principles, practices, and operational execution</li><li>Able to accomplish studies as well as analysis of transportation delivery methodologies. Produce products on a tight timeline for executive level briefings</li></ul>Desired Experience: <ul><li>Minimum of 3 years' experience in air transportation and logistics operations. </li><li>Provides support, advice and guidance on the correct application of a services/products/technology solution or technique. </li><li>Designs, develops, and implements solutions by using standard methods, techniques, and tools.</li></ul>Education: Bachelor's degree in Business, Computer Science, other related field or equivalent experience/certificationsAbout NextGen: NextGen Federal Systems is an innovative technology and professional services provider specializing in advanced software solutions and comprehensive mission and business support services. We work in close collaboration with our customers to truly understand their business and mission goals. Our approach is to design, build, implement, and manage solutions that measurably improve our client's organizational performance. We have established and foster a corporate culture where we:<ul><li>Treat employees with fairness and respect regardless of their position, sexual identity, race, or tenure.</li><li>Communicate the importance of our mission and our employees' contributions to it, ensuring they understand how their job role contributes to the greater good.</li><li>Openly promote and communicate our ideas for change and adaptability.</li><li>Strive to achieve results as an organization.</li><li>Hold employees accountable to their commitments and provide incentives that encourage positive and productive behaviors.</li><li>Value the talents and contributions of our employees as the key factor for our success.</li><li>Create an environment where people can engage at all levels.</li><li>Encourage people to take risks and allow them to make mistakes.</li></ul>Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.RefID: B03

Overview: LMI is seeking a Data Analyst to perform information technology related requirements as part of an integrated team supporting for the Department of Defense, United States Transportation Command. The position requires proficiency in physical data modeling and any major BI Visualization tool. Work will be performed at Scott AFB, IL and in the vicinity of OFallon, IL. At LMI, were reimagining the path from insight to outcome at The New Speed of Possible. Combining a legacy of over 60 years of federal expertise with our innovation ecosystem, we minimize time to value and accelerate mission success. We energize the brightest minds with emerging technologies to inspire creative solutioning and push the boundaries of capability. LMI advances the pace of progress, enabling our customers to thrive while adapting to evolving mission needs. Responsibilities: <ul><li style="margin: 0in 0in 0in .25in;">Designs and builds automated data and ETL pipelines from multiple real-time and static data sources.</li><li style="margin: 0in 0in 0in .25in;">Works with key stakeholders to develop and document data requirements.</li><li style="margin: 0in 0in 0in .25in;">Works iteratively while constantly taking into account customer feedback to develop and refine data visualization dashboards.</li><li style="margin: 0in 0in 0in .25in;">Creates data orchestration workflows to ensure data visualization dashboards display the latest data.</li><li style="margin: 0in 0in 0in .25in;">Takes business requirements and identifies key data sources to support stakeholder needs.</li><li style="margin: 0in 0in 0in .25in;">Participates in Agile/Scrum ceremonies and provides updates to teammates and stakeholders as needed.</li><li style="margin: 0in 0in 0in .25in;">Works collaboratively with fellow teammates to ensure best practices and efficient techniques are used.</li></ul> Qualifications: <ul><li style="margin: 0in 0in 0in .25in;">Bachelor's in Computer Science, Information Systems, Engineering, Business, Social Science, or other related analytical, scientific, or technical disciplines or equivalent years of experience</li><li style="margin: 0in 0in 0in .25in;">3-5 years experience building automated ETL data-pipelines, using: Python, Pandas, Dataframes, or Pyspark. Familiarity with Databricks a plus. </li><li style="margin: 0in 0in 0in .25in;">3-5 years of SQL experience including: Data Definition Language (DDL) and/or Data Manipulation Language (DML). </li><li style="margin: 0in 0in 0in .25in;">3-5 years of MS Excel experience </li><li style="margin: 0in 0in 0in .25in;">3-5 years of experience deriving business use case requirements </li><li style="margin: 0in 0in 0in .25in;">3-5 years of Business Intelligence and Visualization experience using tools such as: Qlik, Tableau, or PowerBI. </li><li style="margin: 0in 0in 0in .25in;">3-5 years working in an Agile/Scrum environment </li><li style="margin: 0in 0in 0in .25in;">3-5 years using MS Teams / SharePoint </li><li style="margin: 0in 0in 0in .25in;">Experience building physical data models/database design, preferred </li><li style="margin: 0in 0in 0in .25in;">Experience working with DoD preferred, but not necessary </li><li style="margin: 0in 0in 0in .25in;">Must possess an active SECRET US Government clearance </li></ul>

Data Analyst Jobs in Scott Air Force Base, IL

Data Analyst Clearance Required
December 10, 2024

Data Analyst Iii
December 10, 2024

Data Analyst Clearance Required
December 8, 2024

Air Transportation Data Analyst 1 Onsite
December 8, 2024

Data Analyst Iii
December 7, 2024

Data Analyst
December 5, 2024

Data Analyst Clearance Required
December 1, 2024

Quick filters

Top companies

Data Analyst Jobs in Scott Air Force Base, IL

Data Analyst Clearance RequiredDecember 10, 2024

Data Analyst IiiDecember 10, 2024

Data Analyst Clearance RequiredDecember 8, 2024

Air Transportation Data Analyst 1 OnsiteDecember 8, 2024

Data Analyst IiiDecember 7, 2024

Data AnalystDecember 5, 2024

Data Analyst Clearance RequiredDecember 1, 2024