Silverthorne Advisory Group · 1 month ago
Data Engineer (All Levels)
Scott AFB, IL
Full-time
Onsite
Entry, Mid, Senior LevelSilverthorne 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.
Management Consulting
No H1B
Security Clearance Required
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
Qualification
Required
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
Preferred
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
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
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.
Company
Silverthorne Advisory Group
Silverthorne Advisory Group is a data, cloud engineering, management and IT consulting firm.
Founded in 2016
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase