Data Engineer (All Levels) - Shiloh, IL

Silverthorne Advisory Group LLC; Scott Air Force Base (IL); On-site; USD 80,000 - 120,000; Full time

Benefits offered by this job

Retirement Plan

Health insurance

401(k) matching

Bonus based on performance

Paid time off

Professional Development

Company parties

Training & development

Job summary

Silverthorne Advisory Group LLC is looking for a skilled Data Engineer to join their team at Scott Air Force Base. This position will involve designing and maintaining data infrastructure within the Defense sector. The ideal candidate must have expertise in SQL, ETL processes, and various programming technologies like Python and Spark. A Secret clearance is required, and the company offers a competitive salary along with comprehensive health benefits, retirement planning, and opportunities for professional development.

Qualifications

• Secret clearance or higher required (can be sponsored).
• Demonstrated experience working with large datasets.
• Excellent communication and collaboration skills.

Responsibilities

• Design, develop, and implement end-to-end data pipelines.
• Perform data cleansing, integration, and quality assurance.
• Troubleshoot data-related problems and provide solutions.

Skills

SQL

ETL

Python

Spark

Scala

JavaScript/JSON

Data Governance

Business Intelligence

Data Cleansing

Big Data Technologies

Tools

Databricks

Amazon AWS/S3

Jupyter Notebooks

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

Job Description

Silverthorne Advisory Group is seeking a skilled and highly motivated Data Engineer to join an exciting and growing opportunity within the Defense sector. As a Data Engineer, you will play a crucial role in designing, developing, and maintaining our Advana data infrastructure and systems. Your expertise in ETL, Databricks, Python, Spark, Scala, JavaScript/JSON, SQL, and Jupyter Notebooks will be essential in ensuring efficient data processing and analysis.

Responsibilities

• Design, develop, and implement end-to-end data pipelines, utilizing ETL processes and technologies such as Databricks, Python, Spark, Scala, JavaScript/JSON, SQL, and Jupyter Notebooks.
• Create and optimize data pipelines from scratch, ensuring scalability, reliability, and high-performance processing.
• Perform data cleansing, data integration, and data quality assurance activities to maintain the accuracy and integrity of large datasets.
• Leverage big data technologies to efficiently process and analyze large datasets, particularly those encountered in a federal agency.
• Troubleshoot data-related problems and provide innovative solutions to address complex data challenges.
• Implement and enforce data governance policies and procedures, ensuring compliance with regulatory requirements and industry best practices.
• Work closely with cross-functional teams to understand data requirements and design optimal data models and architectures.
• Collaborate with data scientists, analysts, and stakeholders to provide timely and accurate data insights and support decision-making processes.
• Maintain documentation for software applications, workflows, and processes.
• Stay updated with emerging trends and advancements in data engineering and recommend suitable tools and technologies for continuous improvement.

Requirements

• Secret clearance or higher required (can be sponsored).
• Strong SQL knowledge: Ability to write, troubleshoot, and modify complex SQL procedures and queries across a variety of datasets.
• Extract, Transform, Load (ETL) experience: Experience with establishing and maintaining data load processes as well as manipulating and combining various data sources.
• Business Intelligence experience: Creating and updating applications, reports, dashboards, etc. Cognos Analytics, Qlik Sense, and Power BI especially are relevant to the role.
• Python and Coding experience: Hands‑on experience with languages/technologies such as Python, Spark, Scala, JavaScript/JSON, and SQL.
• Databricks experience: Familiarity with Databricks, Amazon AWS/S3, Jupyter Notebooks will be helpful in the role.
• Strong problem‑solving skills and ability to solve complex data‑related issues.
• Demonstrated experience working with large datasets and leveraging big data technologies to process and analyze data efficiently.
• Understanding of data modeling/visualization, database design principles, and data governance practices.
• Excellent communication and collaboration skills, with the ability to work effectively with cross‑functional teams.
• Detail‑oriented mindset with a commitment to delivering high‑quality results.
• Teradata experience is a plus. Knowledge of Multiloads, BTEQs, and other assorted Teradata procedures will be helpful in the role.
• Accounting knowledge is a plus. Some background on DoD accounting system (DEAMS, TFMS, NERP etc.) and transportation policies will be helpful in the role.

Benefits

• Compensation - We carefully consider a wide range of compensation factors, including but not limited to prior experience, skills, expertise, location, and other considerations permitted by law.
• Healthcare - We offer Health, Vision, and Dental Plans for our employees and their families.
• Retirement Plan – We invest in your future with a competitive 401(k) plan, where we match 100% of your contributions up to your first 6% and give you access to Vanguard Admiral funds.
• Paid Time Off - Based on length of service, we offer a generous amount of paid leave.
• Bonus System – As you invest in us, we invest in you. We offer bonuses to all employees who meet and exceed goals throughout the year.
• Professional Development – Support for career growth through training programs and certifications.
• Company Retreats & Team Events – Sponsored trips, team‑building activities, and annual conferences related to your skillset.