General Dynamics - Falls Church, VA

posted 3 months ago

Full-time - Senior
Remote - Falls Church, VA
10,001+ employees
Transportation Equipment Manufacturing

About the position

The Senior Data Engineer will play a crucial role in the data warehousing team, focusing on transforming transactional data into datasets that are consumable for various reporting and analytics purposes. This position requires a candidate who is flexible and forward-thinking, with a strong ability to learn new tools and skills as the data warehouse evolves. The successful candidate will be expected to work closely with other program staff and customers to make design decisions within given constraints, ensuring that the data solutions meet the needs of the organization. In this role, the Senior Data Engineer will be responsible for developing and maintaining complex SQL for ETL processes and reporting. The candidate will also perform database administration tasks, including managing scheduled jobs and cluster configurations, as well as software administration tasks such as deploying applications and managing scheduled tasks. The ability to learn new tools quickly is essential, as is the desire to collaborate with team members and clients to reach effective design solutions. Candidates must be local to the Ashburn, VA office and able to work onsite occasionally. The position requires a Bachelor's degree and at least 7 years of experience in a data engineering role, with a strong background in ETL development, database development, data integration, data mining, and big data. Excellent communication and diplomacy skills are necessary to effectively interact with both technical staff and clients.

Responsibilities

  • Transform transactional data into consumable datasets for reporting and analytics.
  • Develop and maintain complex SQL for ETL and reporting.
  • Perform database administration tasks, including managing scheduled jobs and cluster configurations.
  • Execute software administration tasks such as deploying applications and managing scheduled tasks.
  • Collaborate with program staff and customers to reach design decisions within constraints.
  • Learn new tools quickly to provide innovative solutions to problems.

Requirements

  • Bachelor's degree in a relevant field.
  • 7+ years of experience in a data engineering role, including ETL development and database development.
  • Strong experience with SQL for ETL and reporting.
  • Experience with large complex data systems.
  • Experience performing database administration tasks.
  • Experience performing software administration tasks.
  • Ability to learn new tools quickly.
  • Excellent communication and diplomacy skills.

Nice-to-haves

  • Proficiency in Python and Scala.
  • Experience using Spark and Hive.
  • Experience with Qlik or other data visualization tools.
  • Experience with Databricks development and administration.
  • Familiarity with tools such as DB2, Oracle, SAP, Postgres, Elastic Search, Glacier, Cassandra, DynamoDB, Hadoop, Splunk, SAP HANA.

Benefits

  • 401K with company match
  • Comprehensive health and wellness packages
  • Internal mobility team dedicated to career development
  • Professional growth opportunities including paid education and certifications
  • Paid vacation and holidays
  • Short and long-term disability benefits
  • Life, accidental death and dismemberment insurance
  • Critical illness and business travel insurance
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service