Talent.com
Data Engineer (All Levels)

Data Engineer (All Levels)

Silverthorne Advisory Group LLCIllinois, IL, US
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.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.
    • serp_jobs.job_alerts.create_a_job

    Data Engineer • Illinois, IL, US