Senior Data Warehouse Engineer

Steampunk • McLean, VA

8d • $140,000 - $180,000

About The Position

Steampunk is seeking a Senior Data Warehouse Engineer to work closely with clients to develop, optimize, and scale enterprise-grade data platforms, warehouses, and pipelines. The role calls for a skilled data technologist with strong communication and problem-solving abilities who is effective in cloud-based environments.

The engineer will lead data-environment migrations and design, implement, and optimize data warehouse solutions. They will assess data sources and ETL workflows, develop and maintain pipelines, address technical questions about customization and integration, and establish data governance practices that support data quality and compliance. The position works in an Agile environment alongside data scientists, engineers, and business stakeholders and contributes to the growth of Steampunk’s Data Exploitation Practice.

The projected annual salary range is $140,000 to $180,000. Compensation depends on factors including 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.
• 5–7+ years of experience in data engineering, data warehousing, or data architecture.
• Proficiency in Python or another object-oriented language such as Scala, Java, or C++.
• Experience designing and implementing data governance strategies.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical discipline, or equivalent professional experience.

Nice To Haves

• Hands-on experience with big data tools such as Hadoop, Spark, and Kafka.
• Expertise in cloud-based data warehouse solutions, preferably AWS services such as Redshift, S3, RDS, Glue, and Lambda.
• Experience with Databricks, PySpark, or SparkSQL.
• Experience with ETL tools, preferably SSIS or ADF, and with data pipeline orchestration and workflow management tools such as Apache Airflow, Luigi, or AWS Step Functions.
• Experience designing data models, schemas, and entity-relationship diagrams.
• Strong knowledge of SQL and database optimization techniques, preferably with SQL Server or alternatively PostgreSQL, MySQL, or Oracle.
• Demonstrated ability to lead large-scale data migration efforts.
• Ability to work in a DevSecOps environment and apply CI/CD best practices.

Responsibilities

• Lead and architect data-environment migrations with a focus on performance, reliability, and scalability.
• Design, implement, and optimize data warehouse solutions using best practices in data modeling, storage, and retrieval.
• Examine and understand complex data pipelines.
• Assess, document, and analyze data sources, ETL workflows, and business intelligence tools.
• Address technical inquiries related to data warehouse customization, integration, and enterprise architecture.
• Develop and maintain robust data pipelines and ETL processes to support business intelligence and analytics.
• Design and enforce data governance strategies to ensure data quality and compliance.
• Collaborate with data scientists, engineers, and business stakeholders in an Agile development environment.
• Contribute to Steampunk’s Data Exploitation Practice by implementing data warehousing solutions.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior