SME Operations Research Analyst - Scott AFB - Onsite

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.