SME Operations Research Analyst - Scott AFB - Onsite

Silverthorne Advisory Group LLC; Shiloh (IL); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

401(k) matching

Health insurance

Dental insurance

Vision insurance

Paid time off

Training & development

Career advancement

Company parties

Retirement plan

Bonuses

Job summary

Silverthorne Advisory Group is seeking a skilled Data Engineer to design, develop, and maintain data infrastructure supporting Advana and related systems. You will work with SQL, ETL, Databricks, Python, and big data tools to enable data integration, quality, analysis, and reporting.

The role targets candidates with 3–10 years’ experience, a DoD-focused background, and the ability to collaborate across teams.

Qualifications

• Secret security clearance or higher required; sponsorship may be available.
• Strong SQL skills with ability to write, troubleshoot, and modify complex queries.
• Hands-on experience with ETL processes, data integration, and data transformation.
• Programming experience with Python and related technologies including Spark/Scala/JSON.
• Experience with large datasets and big data processing technologies.
• Understanding of data modeling, database design, data visualization, and data governance principles.
• Experience developing or maintaining BI applications, reports, and dashboards.

Responsibilities

• 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 for scalable, reliable, 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/defense environments.
• Write, troubleshoot, and optimize complex SQL queries and stored procedures across datasets.
• Develop and maintain data models, reports, dashboards, and applications to support BI and decision-making.
• Apply data governance policies to ensure compliance with requirements and standards.
• Collaborate with data scientists, analysts, and cross-functional teams to develop data solutions.
• Troubleshoot complex data issues and recommend improvements to workflows and infrastructure.
• Maintain technical documentation for applications and data pipelines.

Skills

SQL proficiency

ETL processes

Python programming

Big data technologies

Data modeling

Data governance

Communication skills

Education

Bachelor’s or Master’s Degree

Tools

Databricks

AWS S3

Jupyter Notebooks

Power BI

Cognos

Teradata

Job description

Benefits

• 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

Operations Research Analyst -Shiloh, IL (Data Engineer – Advana)

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

Job Description

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.

Responsibilities

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

Required Qualifications

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

Preferred Qualifications

• Experience with Databricks, AWS/S3, and Jupyter Notebooks.
• Experience with Cognos Analytics, Qlik Sense, or Power BI.
• Teradata experience, including MultiLoad, BTEQ, and related procedures.
• Knowledge of DoD financial and accounting systems, such as DEAMS, TFMS, or Navy ERP (NERP).
• Familiarity with DoD accounting processes and transportation policies.
• Experience supporting federal agencies or defense‑sector data initiatives.

Benefits

• Healthcare: Medical, dental, and vision coverage for employees and their families.
• Retirement: Competitive 401(k) plan with 100% matching on contributions up to the first 6%, plus access to Vanguard Admiral funds.
• Paid Time Off: Generous paid leave based on length of service.
• Bonus Opportunities: Bonuses for employees who meet and exceed performance goals.
• Professional Development: Support for training, certifications, and career growth.
• Company Events: Sponsored retreats, team-building activities, and professional conferences.

Why Join Silverthorne Advisory Group?

Join a growing team supporting important defense-sector data initiatives. You will have the opportunity to apply your technical expertise to complex data challenges, contribute to data modernization efforts, and grow your career while supporting mission‑critical government programs.