ETL Engineer
Steampunk
- Pay
- $110K to $130K
- a year
- Location
- Mclean, VA
- Posted
- Nov 1
- 2 days ago
Career path
See where this role leads
Jigup maps the next three moves from a job like this one, with the titles and the skills each step asks for.
About the company
Steampunk
Information technology and services · 201 to 500 employees
Steampunk is a Change Agent in the Federal contracting industry, bringing new thinking to clients in the Homeland, Federal Civilian, Health and DoD sectors. Through our Human-Centered delivery methodology , we are fundamentally changing the expectations our Federal clients have for true shared accountability in solving their toughest mission challenges. If you want to learn more about our story, visit http://www.steampunk.com .
What you'll do
- 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
What you need
- Ability to hold a position of public trust with the US government.
- 2-4 years industry experience coding commercial software and a passion for solving complex problems.
- 2-4 years direct experience in Data Engineering with experience in tools such as:ETL Tools: Python, Informatica, Pentaho, TalendBig data tools: Hadoop, Spark, Kafka, etc.Relational SQL and NoSQL databases, including Postgres and Cassandra.Data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.AWS cloud services: EC2, EMR, RDS, Redshift (or Azure equivalents)Data streaming systems: Storm, Spark-Streaming, etc.Search tools: Solr, Lucene, ElasticsearchObject-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
- ETL Tools: Python, Informatica, Pentaho, Talend
- Big data tools: Hadoop, Spark, Kafka, etc.
- Relational SQL and NoSQL databases, including Postgres and Cassandra.
- Data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
- AWS cloud services: EC2, EMR, RDS, Redshift (or Azure equivalents)
- Data streaming systems: Storm, Spark-Streaming, etc.
- Search tools: Solr, Lucene, Elasticsearch
- Object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
- Advanced working SQL knowledge and experience working with relational databases, query authoring and optimization (SQL) as well as working familiarity with a variety of databases.
- Experience with message queuing, stream processing, and highly scalable ‘big data’ data stores.
- Experience manipulating structured and unstructured data for analysis
- Experience constructing complex queries to analyze results using databases or in a data processing development environment
- Experience working in an Agile environment
- Experience supporting project teams of developers and data scientists who build web-based interfaces, dashboards, reports, and analytics/machine learning models
Key skills
Keywords for your resumePro
The words this employer's screening is likely to look for.
This job lists resume keywords
The terms this posting uses, pulled out so you can mirror them in your resume. Jigup Pro members see the list on the job board.
See full description on company page, apply now