Senior Data Warehouse Engineer

Steampunk, Inc.; McLean (VA); On-site; USD 140,000 - 180,000; Full time

Benefits offered by this job

Additional benefits included

Job summary

Steampunk, Inc. is looking for a Senior Data Warehouse Engineer in McLean, Virginia. The role involves developing and optimizing enterprise-grade data platforms. Candidates should have strong communication skills and thrive in cloud-based environments.

Key responsibilities include leading data migrations and designing data warehouse solutions. The ideal candidate will have 5-7+ years of experience in data engineering along with proficiency in Python and SQL. The compensation range for this position is $140,000 to $180,000.

Qualifications

• 5-7+ years of experience in data engineering, data warehousing, or data architecture.
• Proficiency in Python or other object-oriented languages such as Scala, Java, or C++.
• Experience designing and implementing data governance strategies.

Responsibilities

• Lead and architect data migrations with a focus on performance and scalability.
• Design, implement, and optimize data warehouse solutions.
• Develop and maintain robust data pipelines and ETL processes.

Skills

Data engineering

Data warehousing

Cloud-based environments

Python

SQL

Education

Bachelor's degree in Computer Science or related field

Tools

Hadoop

Spark

Kafka

AWS

Databricks

Apache Airflow

Job description

We’re seeking a Senior Data Warehouse Engineer to join our team and work closely with clients to develop, optimize, and scale enterprise‑grade data platforms, warehouses, and pipelines. We look for more than just a “Senior Data Warehouse Engineer”—a highly skilled data technologist with strong communication and problem‑solving abilities who thrives in cloud‑based environments.

Key Responsibilities

• Lead and architect the migration of data environments with a focus on performance, reliability, and scalability.
• Design, implement, and optimize data warehouse solutions, ensuring 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, ensuring high data quality and compliance.
• Work in an Agile development environment, collaborating with data scientists, engineers, and business stakeholders.
• Contribute to the growth of our Data Exploitation Practice by implementing cutting‑edge data warehousing solutions.

Required Qualifications

• Ability to hold a position of public trust with the U.S. government.
• 5‑7+ years of experience in data engineering, data warehousing, or data architecture.
• Proficiency in Python or other object‑oriented languages such as Scala, Java, or C++.
• Experience designing and implementing data governance strategies.

Preferred Qualifications

• Hands‑on experience with big data tools such as Hadoop, Spark, and Kafka.
• Expertise in cloud‑based data warehouse solutions, preferably AWS (Redshift, S3, RDS, Glue, Lambda).
• Experience with Databricks, PySpark, SparkSQL preferred.
• Experience with ETL tools (SSIS or ADF preferred), data pipeline orchestration, and workflow management tools such as Apache Airflow, Luigi, or AWS Step Functions.
• Experience designing data models, schema design, and entity‑relationship diagrams.
• Strong knowledge of SQL and database optimization techniques (preferably SQL Server; alternatively PostgreSQL, MySQL, Oracle).
• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical discipline, or equivalent professional experience.
• Demonstrated ability to lead large‑scale data migration efforts.
• Ability to work in a DevSecOps environment, applying CI/CD best practices.

Compensation

Steampunk determines salary based on geographic location, contractual requirements, education, skills, and experience. The projected compensation range for this position is $140,000 to $180,000. Annual salary is one aspect of our total compensation package. Additional benefits are included.

Identity Statement

As part of the application process, you are expected to be on camera during interviews and assessments. We reserve the right to take your picture to verify your identity and prevent fraud.

Equal Opportunity Employer

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.