Senior Data Warehouse Engineer
概述 我们正在寻找一名高级数据仓库工程师,加入我们的团队并与客户密切合作开发,优化和扩展企业级数据平台,仓库和管道。我们不仅在寻求一位高级数据仓储工程师,但是一位具有强大的沟通和解决问题的能力的高技能数据技术人员,在基于云环境中繁荣。贡献 主要责任:·领导和设计数据环境迁移,重点关注性能,可靠性和扩展性。·设计,实施和优化数据仓库解决方案,确保数据建模,存储和检索最佳实践。· 能够检查和理解复杂的数据管道。·评估,记录和分析数据来源,ETL 工作流程和商业智能工具。·解决与数据仓库定制,集成和企业架构相关的技术询问。·开发和维护可靠的数据管线和 ETL 过程以支持商业智力和分析。·设计和执行数据治理策略,确保高数据质量和合规性。· 在敏捷发展环境中工作,与数据科学家,工程师和商业利益相关者合作。· 通过实施先进的数据仓库解决方案,促进我们数据利用实践的发展。资格要求:· 在美国政府中拥有公众信任地位的能力。· 5~7年以上在数据工程,数据仓库或数据架构方面的经验。·熟练使用 Python 或其他基于对象语言如 Scala,Java 或 C++. ·设计和实施数据治理策略的经验。首选资格:·与哈多普,斯帕克和卡夫卡等大数据工具的实践经验。• 云计算数据仓库方案的专业知识,最好是 AWS (Redshift,S3,RDS,Glue,Lambda). · 经验与数据,PySpark,SparkSQL 优先 · ETL 工具 (SSIS 或 ADF 优先),数据管道编排和工作流管理工具的经验。· 数据模型设计,方案设计和实体关系图表的经验· SQL 和数据库优化技术的强大知识 (最好是 SQL Server.可选的是 PostgreSQL,MySQL,Oracle). ·计算机科学学士学位,信息系统,工程,相关技术等类型;
查看英文原文
Overview
We are 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 are looking for more than just a “Senior 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:
- 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.
- 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 Qualifications:
- 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.
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, a related technical discipline, or professional experience equivalent.
- Demonstrated ability to lead large-scale data migration efforts.
- Ability to work in a DevSecOps environment, applying CI/CD best practices.
About steampunk
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.
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.
Steampunk is a Change Agent in the Federal contracting industry, bringing new thinking to clients in the Homeland, Federal Civilian, Health and DoD sectors. Through our Human-Centered delivery methodology, we are fundamentally changing the expectations our Federal clients have for true shared accountability in solving their toughest mission challenges. As an employee owned company, we focus on investing in our employees to enable them to do the greatest work of their careers – and rewarding them for outstanding contributions to our growth. If you want to learn more about our story, visit
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.
Originally posted on Himalayas