Data Engineer (All Levels) - Shiloh, IL

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. #J-18808-Ljbffr