Data Warehouse Engineer

GameStop; McLean (VA); On-site; USD 80,000 - 140,000; Full time

Job summary

An established industry player is on the lookout for a skilled Data Warehouse Engineer to enhance their data platforms and pipelines. This role involves collaborating with clients to optimize performance and scalability while ensuring high data quality and compliance. The ideal candidate will thrive in a cloud-based environment and possess strong communication and problem-solving skills. Join a forward-thinking team that values innovation and continuous improvement in data engineering practices, where your contributions will significantly impact the organization’s data exploitation efforts.

Qualifications

• 3-5+ years of experience in data engineering or data warehousing.
• Strong knowledge of SQL and database optimization techniques.

Responsibilities

• Develop and maintain robust data pipelines and ETL processes.
• Design and enforce data governance strategies ensuring data quality.

Skills

Data Engineering

Data Warehousing

Problem-Solving

Communication Skills

Python

SQL

Data Governance

Agile Methodologies

Education

Bachelor's Degree in Computer Science or related field

Tools

Databricks

PySpark

SparkSQL

SSIS

Azure Data Factory (ADF)

Job description

Overview

We are seeking a 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 are looking for more than just a “Data Warehouse Engineer,” but a highly skilled data technologist with strong communication and problem-solving abilities who thrives in cloud-based environments.

Contributions

Key Responsibilities:

• Help develop the migration of data environments with a focus on performance, reliability, and scalability.
• Ability to 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.

Qualifications

Required:

• Ability to hold a position of public trust with the US government.
• 3-5+ years of experience in data engineering, data warehousing, or data architecture.
• Knowledge of Python or other object-oriented languages is a plus.
• Experience designing and implementing data governance strategies.

Preferred:

• Strong knowledge of SQL and database optimization techniques (Preferably SQL Server. Alternatively, PostgreSQL, MySQL, Oracle).
• Experience with Databricks, PySpark, SparkSQL is a plus.
• Experience with SSIS or ADF.
• Experience creating entity-relationship diagrams.
• Ability to work in a DevSecOps environment, applying CI/CD best practices.
• DBA or server patching experience is a plus.