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.
WHY SILVERTHORNE
WE ADVISE AS YOUR BUSINESS PARTNER
The most important thing we can do is do right by our clients. They come to us when something may not be going the way it should. Oftentimes, the root cause is unknown. That’s why, even when our clients ask for a specific service, we ask questions and listen. Not just for their answers, but for what’s not being said, because that’s when true challenges come to light. We help client implement sustainable solutions to leave their organization stronger than when we arrived.
WE INVEST IN OUR PEOPLE
Hiring the best people is just the start. Our employees are our most valuable asset, so we make sure we treat them as such—starting on day one. Through mentorship, guidance, and collaboration, we help them grow their skills and their careers. We respect our employees and support them with the resources they need to do the jobs they want to do. That includes offering competitive salaries, expansive benefits coverage, and an above-industry 401k retirement plan to provide security over their future. When our people are happy, confident, and fulfilled, we are a stronger organization and so are our clients.
WE LOVE WHAT WE DO
We keep our hearts in our work. It makes the days more fun, but more importantly, it makes the outcomes more rewarding. Loving our work means respecting the process, and paying attention to every detail, no matter how small. It’s the difference between working for a paycheck, when anything might do, and working to make an impact, when only our best will do.
SMALL TEAM, BIG RESULTS
People come to Silverthorne when they are ready to do things differently—to start just by listening, to put clients first, and to sweat the details, because the little stuff really is big stuff. People stay at Silverthorne because there’s one thing about us that’s exactly the same. We love what we do.
We are passionate about our work and we enjoy the people we work with. We keep our team small, filling it with bright, talented people who are eager to grow and advance their careers. By providing mentorship and resources to our team, we create a great place to work and deliver the results our clients are looking for.
Think Silverthorne is the right fit for you?