SME Operations Research Analyst - Scott AFB - Onsite

• Retirement Plan
• 401(k)
• 401(k) matching
• Bonus based on performance
• Company parties
• Competitive salary
• Dental insurance
• Health insurance
• Opportunity for advancement
• Paid time off
• Training & development
• Vision insurance

Location: Shiloh, IL (onsite) Scott AFB

Clearance: Active Secret Clearance or Higher Required

Employment Type: Full-Time, Salaried

Experience Level: Experienced/Senior

Education: Bachelor's or Master's Degree

Years of

Experience:

3-10 years of directly related experience

Silverthorne Advisory Group is seeking a skilled and motivated Data Engineer to support an exciting and growing opportunity within the defense sector. The selected candidate will help design, develop, and maintain data infrastructure and pipelines supporting Advana and related data systems. This role requires strong technical expertise in SQL, ETL processes, Databricks, Python, and big data technologies to support data integration, quality, analysis, and reporting.

The ideal candidate has experience working with large datasets, developing scalable data pipelines, and supporting federal or Department of Defense (DoD) data environments. Experience with business intelligence tools and DoD financial or accounting systems is a plus.

• Design, develop, and maintain end-to-end data pipelines using ETL processes, Databricks, Python, Spark, Scala, SQL, and related technologies.
• Build and optimize data pipelines from the ground up to support scalable, reliable, and high-performance data processing.
• Perform data cleansing, integration, transformation, and quality assurance to ensure data accuracy and integrity.
• Process and analyze large datasets using big data technologies within federal and defense environments.
• Write, troubleshoot, and optimize complex SQL queries and stored procedures across multiple datasets.
• Develop and maintain data models, reports, dashboards, and applications to support business intelligence and decision-making.
• Apply data governance policies and procedures to ensure compliance with applicable requirements and standards.
• Collaborate with data scientists, analysts, and cross-functional teams to understand requirements and develop effective data solutions.
• Troubleshoot complex data issues and recommend improvements to data workflows, infrastructure, and processing methods.
• Maintain technical documentation for applications, data pipelines, workflows, and processes.
• Stay current with emerging data engineering technologies and recommend opportunities for continuous improvement.

• Secret security clearance or higher required; sponsorship may be available.
• Strong SQL skills, including the ability to write, troubleshoot, and modify complex queries and procedures.
• Hands-on experience with ETL processes, data integration, and data transformation.
• Programming experience with Python and related technologies such as Spark, Scala, JavaScript/JSON, and SQL.
• Experience working with large datasets and big data processing technologies.
• Understanding of data modeling, database design, data visualization, and data governance principles.
• Experience developing or maintaining business intelligence applications, reports, and dashboards.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Strong attention to detail and commitment to delivering high-quality work.

• Experience with Databricks, AWS/S3, and Jupyter Notebooks.
• Experience with Cognos Analytics, Qlik Sense, or Power BI.
• Teradata experience, including Multi Load, BTEQ, and related procedures.
• Knowledge of DoD financial and accounting systems, such as DEAMS, TFMS, or Navy ERP (NERP).
• Familiarity with DoD…