Data Engineer Lead

OverviewIn today’s rapidly evolving technology landscape, an organization’s data has never been a more important aspect in achieving mission and business goals. Our data exploitation experts work with our clients to support their mission and business goals by creating and executing a comprehensive data strategy using the best technology and techniques, given the challenge.At Steampunk, our goal is to build and execute a data strategy for our clients to coordinate data collection and generation, to align the organization and its data assets in support of the mission, and ultimately to realize mission goals with the strongest effectiveness possible.For our clients, data is a strategic asset. They are looking to become a facts-based, data-driven, customer-focused organization. To help realize this goal, they are leveraging visual analytics platforms to analyze, visualize, and share information. At Steampunk you will design and develop solutions to high-impact, complex data problems, working with the best and data practitioners around. Our data exploitation approach is tightly integrated with Human-Centered Design and DevSecOps.ContributionsWe are looking for seasoned Data Engineer Lead to work with our team and our clients to develop enterprise grade data platforms, services, and pipelines. We are looking for more than just a "Data Engineer". We are looking for a technologist with excellent communication and customer service skills and a passion for data and problem solving.Lead and architect migration of data environments with performance and reliability.Assess and understand the ETL jobs, workflows, BI tools, and reports.Address technical inquiries concerning customization, integration, enterprise architecture and general feature / functionality of data products.Experience in crafting database / data warehouse solutions in cloud (Preferably GCP. Alternatively Azure, AWS).Key must have skill sets – Python.Support an Agile software development lifecycle.Act as an individual contributor and mentor more junior team members.You will contribute to the growth of our Data Exploitation Practice!QualificationsAbility to hold a position of public trust with the US government.8-10 years industry experience coding commercial software and a passion for solving complex problems.8-10 years direct experience in Data Engineering with experience in tools such as:Big data tools: Hadoop, Spark, Kafka, etc.Relational SQL and NoSQL databases, including Postgres, CloudSQL, MongoDBData pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.AWS cloud services: EC2, EMR, RDS, Redshift (or Azure and GCP equivalents)Data streaming systems: Storm, Spark-Streaming, etc.Search tools: Solr, Lucene, ElasticsearchObject-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, processing, and extracting value from large, disconnected datasets.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 with data modeling tools and process.Experience architecting data systems (transactional and warehouses).Experience aggregating results and/or compiling information for reporting from multiple datasets.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.Experience with BigQuery and Looker.Preferred:Certifications:Google Professional Data EngineerGoogle Associate Cloud EngineerAWS Certified Data AnalyticsAWS Certified Solutions ArchitectAzure Data Engineer Associate About steampunkSteampunk relies on several factors to determine salary, including but not limited to geographic location, contractual requirements, education, knowledge, skills, competencies, and experience. The projected compensation range for this position is $150,000 to $185,000.  The estimate displayed represents a typical annual salary range for this position. Annual salary is just one aspect of Steampunk’s total compensation package for employees. Learn more about additional Steampunk benefits here.  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.  As an employee owned company, we focus on investing in our employees to enable them to do the greatest work of their careers – and rewarding them for outstanding contributions to our growth. If you want to learn more about our story, visit .We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. Steampunk participates in the E-Verify program. Job SummaryJob ID: 5873Clearance Requirement: Public Trust