Senior Data Warehouse Engineer
WFA Digital Insight
The demand for skilled data professionals continues to soar, with a 25% increase in data engineering roles over the past year. As companies shift towards cloud-based solutions, experts in data warehousing and governance are in high demand. Steampunk, a leader in federal contracting, is looking for a Senior Data Warehouse Engineer to drive innovation in their data exploitation practice. With a strong focus on employee growth and development, this role offers a unique opportunity for professionals to work on complex projects and collaborate with cross-functional teams. Before applying, candidates should be aware of the required qualifications, including proficiency in Python and experience with big data tools.
Job Description
About the Role
The Senior Data Warehouse Engineer will play a critical role in designing, implementing, and optimizing enterprise-grade data platforms, warehouses, and pipelines for Steampunk's clients. As a key member of the data exploitation practice, this professional will work closely with clients to understand their data needs and develop tailored solutions. The ideal candidate will have a strong background in data engineering, data warehousing, and cloud-based technologies, with excellent communication and problem-solving skills.The role will involve leading the migration of data environments, designing and implementing data warehouse solutions, and developing robust data pipelines and ETL processes. The Senior Data Warehouse Engineer will also be responsible for assessing and analyzing data sources, ETL workflows, and business intelligence tools, and addressing technical inquiries related to data warehouse customization, integration, and enterprise architecture.
As a senior member of the team, this professional will contribute to the growth of Steampunk's data exploitation practice by implementing cutting-edge data warehousing solutions and collaborating with data scientists, engineers, and business stakeholders in an Agile development environment.
What You Will Do
- 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 Steampunk's data exploitation practice by implementing cutting-edge data warehousing solutions
What We Are Looking For
- 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 other object-oriented languages such as Scala, Java, or C++
- Experience designing and implementing data governance strategies
- Strong knowledge of SQL and database optimization techniques
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical discipline
- Demonstrated ability to lead large-scale data migration efforts
- Ability to work in a DevSecOps environment, applying CI/CD best practices
Nice to Have
- 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
- 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
Benefits and Perks
- Competitive salary range
- Opportunity to work with a leading federal contractor
- Collaborative and dynamic work environment
- Professional development and growth opportunities
- Access to cutting-edge technologies and tools
- Flexible work arrangements, including remote work options
- Comprehensive benefits package, including health insurance and retirement planning
- Paid time off and holidays
How to Stand Out
- To stand out in the application process, highlight your experience with cloud-based data warehouse solutions and Agile development methodologies.
- Be prepared to discuss your approach to data governance and how you ensure high data quality and compliance.
- Showcase your problem-solving skills by providing examples of complex data pipelines you've worked on and how you resolved issues.
- Familiarize yourself with Steampunk's data exploitation practice and be prepared to discuss how you can contribute to its growth.
- When negotiating salary, consider the company's salary range and benefits package, and be prepared to discuss your expectations and requirements.
- Pay attention to the required qualifications and ensure you meet the necessary criteria before applying.
- Prepare to discuss your experience with big data tools and technologies, such as Hadoop, Spark, and Kafka.
This is a remote position listed on WFA Digital, the platform for professionals who work from anywhere. Browse more remote jobs across all categories.