ETL Engineer

Steampunk•McLean, VA

4d•$110,000 - $130,000

About The Position

Steampunk is seeking a seasoned ETL Engineer to work with its team and clients to develop enterprise-grade data pipelines. The role calls for a technologist with strong communication and customer service skills and an interest in data and problem solving. The position supports reporting, business intelligence, and data science users through ETL and ELT operations, and contributes to the growth of Steampunk’s Data Exploitation Practice. The engineer will work with data architects on data models and schemas for relational databases, data warehouses, and data lakes, and will work within an Agile software development lifecycle. The position requires the ability to hold a position of public trust with the US government. Steampunk’s projected annual compensation range for this position is $110,000 to $130,000. The company notes that salary is one part of its total compensation package and that compensation may depend on factors such as location, contractual requirements, education, skills, and experience. Applicants are expected to be on camera during interviews and assessments; Steampunk may take a picture to verify identity and prevent fraud.

Requirements

Ability to hold a position of public trust with the US government.
2–4 years of industry experience coding commercial software.
2–4 years of direct experience in data engineering.
Key skills in Python and SQL.
Advanced working knowledge of SQL, including query authoring and optimization, and familiarity with a variety of databases.
Experience with relational SQL and NoSQL databases, including Postgres and Cassandra.
Experience with ETL tools such as Python, Informatica, Pentaho, or Talend.
Experience with big data tools such as Hadoop, Spark, or Kafka.
Experience with data pipeline and workflow management tools such as Azkaban, Luigi, or Airflow.
Experience with AWS cloud services such as EC2, EMR, RDS, and Redshift, or Azure equivalents.
Experience with data streaming systems such as Storm or Spark Streaming.
Experience with search tools such as Solr, Lucene, or Elasticsearch.
Experience with object-oriented or object-function scripting languages such as Python, Java, C++, or Scala.
Experience with message queuing, stream processing, and highly scalable big data stores.
Experience manipulating structured and unstructured data for analysis.
Experience constructing complex queries to analyze results using databases or a data processing development environment.
Experience working in an Agile environment.
Experience supporting project teams of developers and data scientists building web-based interfaces, dashboards, reports, and analytics or machine-learning models.

Responsibilities

Assess and understand ETL jobs and workflows.
Create reusable data pipelines from source to target systems.
Test, validate, and deploy ETL pipelines.
Support reporting, business intelligence, and data science end users through ETL and ELT operations.
Work with data architects to create data models and design schemas for RDBMS, warehouse, and data lake systems.
Work within an Agile software development lifecycle.
Contribute to the growth of the Data Exploitation Practice.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume