Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Company Overview