Senior Data Engineer

Henderson Drake is a fast-growing, leading business and technology consulting company that partners with their clients to initiate and sustain significant improvements in enterprise performance. They are seeking a highly skilled and experienced Senior Data Engineer to join their dynamic team, where the role focuses on data migration, transformation, and reporting.

Responsibilities:

• Collaborate with project teams and clients to understand data requirements, architecture, and objectives
• Working with business partners to understand the business requirements so that you can create a technical design to support those requirements
• Design, develop, and maintain data pipelines and ETL processes using technologies like Snowflake, Oracle, Fivetran, dbt, and IICS
• Lead the implementation of a Snowflake data warehouse, ensuring data integrity, performance, and scalability
• Develop and optimize SQL queries and scripts for data extraction, transformation, and loading
• Implement best practices for data governance, security, and compliance

Requirements:

• Strong expertise in utilizing technologies such as Snowflake, Oracle, Fivetran, dbt, Windows scripting, and Informatica Integration Cloud Services (IICS)
• Collaborate with project teams and clients to understand data requirements, architecture, and objectives
• Working with business partners to understand the business requirements so that you can create a technical design to support those requirements
• Design, develop, and maintain data pipelines and ETL processes using technologies like Snowflake, Oracle, Fivetran, dbt, and IICS
• Lead the implementation of a Snowflake data warehouse, ensuring data integrity, performance, and scalability
• Develop and optimize SQL queries and scripts for data extraction, transformation, and loading
• Implement best practices for data governance, security, and compliance
• Experience in migrating Oracle data warehouses to Snowflake
• Establishing reporting capabilities during the transition phase