Senior Data Engineer at Steampunk in US-VA-McLean

Job description

• We are looking for seasoned Senior Data Engineer to work with our team and our clients to develop enterprise grade data platforms, services, and pipelines in Databricks . We are looking for more than just a " Senior Data Engineer", but a technologist with excellent communication and customer service skills and a passion for data and problem solving.

Responsibilities

• Lead and architect migration s of data using Databricks with focus on performance , reliability , and scalability .
• Assess and understand ETL jobs, workflows, data marts, BI tools, and reports
• Address technical inquiries concerning customization, integration, enterprise architecture and general feature/functionality of data products
• Experience working with database/data warehouse /data mart solutions in cloud (AWS, Azure, GCP).
• Key must have skill sets – Databricks, SQL, PySpark / Python , AWS
• Support an Agile software development lifecycle
• You will contribute to the growth of our AI & Data Exploitation Practice !

Requirements

• Current ICE US Public Trust Clearance (Full Background Investigation)
• Ability to hold a position of public trust with the US government.
• 5 - 7 years industry experience coding commercial software and a passion for solving complex problems.
• 5 - 7 years direct experience in Data Engineering with experience in tools such as:
• Big data tools: Databricks, Apache Spark, Delta Lake , etc.
• Relational SQL (Preferably T-SQL. Alternatively pgSQL , MySQL) .
• Data pipeline and workflow management tools: Databricks Workflows , Airflow, Step Functions, etc.
• AWS and Azure cloud services: e.g. Databricks on AWS, S3, EC2, RDS .
• Object-oriented/object function scripting languages: PySpark / Python, Java, C++, Scala, etc.
• Experience working with Data Lake house architecture and Delta Lake /Apache Iceberg
• 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 manipulating, processing , and extracting value from large, disconnected datasets.
• Ability to inspect existing data pipelines, discern their purpose and functionality, and re-implement them efficiently in Databricks.
• Experience manipulating structured and unstructured data .
• Experience architecting data systems (transactional and warehouses).
• Experience the SDLC, CI/CD, and op erating in dev/test/prod environments.
• Experience with data cataloging tools such as Informatica EDC, Unity Catalog, Collibra, Alati on, Purview, or DataZone is a plus .
• Commitment to data governance.
• 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

Skills

Required

• Databricks
• SQL
• PySpark / Python
• AWS
• Apache Spark
• Delta Lake
• Relational SQL (T-SQL, pgSQL, MySQL)
• Data Lake house architecture
• Data governance
• Agile development
• SDLC, CI/CD

Benefits

• Steampunk 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 $140,000 to $180,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.