Rumpke is looking to manage the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments by hiring an ETL Developer.
Requirements
- Proficient in developing and orchestrating ETL workflows using SSIS, DBT,and Fivetran, with strong hands-on experience in Snowflake and SQL Server
- Data migration experience from any Databases to Snowflake
- Experience building DBT models for data ingestion
- Design and execute ETL workflows using DBT Cloud to load dimension tables, fact tables and test cases to run during the execution of DBT jobs
- Understanding and familiar with different Snowflake features and concepts eg Virtual Warehouse Micropartition zero copy cloning data sharing Time travel Cache etc
- Experience in optimizing SSIS packages and tuned SQL Server Agent jobs to enhance performance,reduce latency, and eliminate bottlenecks across critical data workflows
- Develop and support stored procedures, understand and code in open SQL language in SQL and HANA cloud foundry (BAS) environments
Responsibilities
- Use different data warehousing concepts to build a data warehouse for internal departments of the organization, determine storage needs for reporting databases and data warehouse
- Create and enhance data solutions enabling seamless delivery of data; responsible for collecting, parsing, managing, performing complex data analysis/validation on large sets of data to ensure the accuracy and integrity of data and research/troubleshoot data anomalies to recommend/implement corrective actions
- Lead the design of the logical data model and implement the physical database structure and constructs and implements operational data stores and data marts
- Proficient in developing and orchestrating ETL workflows using SSIS, DBT,and Fivetran, with strong hands-on experience in Snowflake and SQL Server
- Data migration experience from any Databases to Snowflake
- Experience building DBT models for data ingestion
- Design and execute ETL workflows using DBT Cloud to load dimension tables, fact tables and test cases to run during the execution of DBT jobs
Other
- Excellent analytical and problem solving skills
- Strong planning and organizational skills
- Ability to clearly articulate pros and cons of various technologies and platforms
- Outstanding interpersonal, verbal, and written communication skills
- Ability to perform detailed analysis of business problems and technical environments and use this in designing the solution
