Data Engineer (All Levels)
Full Time • Illinois
Responsive recruiter
Replies within 24 hours
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
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.
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?
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?
(if you already have a resume on Indeed)