BI ETL Developer

DescriptionRumpke is a family-owned and operated company that ranks as one of the largest firms in the waste and recycling industry. Our mission is simple: to deliver exceptional waste and recycling solutions to our customers and communities through a commitment to safety, service, the environment and the growth of our people.When you join Rumpke, you'll be part of a team providing essential services to millions of residents, businesses, and neighborhoods. You will enjoy competitive pay and comprehensive benefits, including health, dental, vision, matching 401(k), life insurance, paid vacation, and more.This is your opportunity to make a difference for you and your family. Come join our teamAs a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop ETL solutions and help automate data extraction from source systems and transform unstructured and disparate source data into target data stores or data marts.Responsibilities of Position:Use different data warehousing concepts to build a data warehouse for internal departments of the organization, determine storage needs for reporting databases and data warehouseCreate 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 actionsLead the design of the logical data model and implement the physical database structure and constructs and implements operational data stores and data martsProficient in developing and orchestrating ETL workflows using SSIS, DBT,and Fivetran, with strong hands-on experience in Snowflake and SQL ServerData migration experience from any Databases to SnowflakeExperience building DBT models for data ingestionDesign and execute ETL workflows using DBT Cloud to load dimension tables, fact tables and test cases to run during the execution of DBT jobsUnderstanding and familiar with different Snowflake features and concepts eg Virtual Warehouse Micropartition zero copy cloning data sharing Time travel Cache etcExperience in optimizing SSIS packages and tuned SQL Server Agent jobs to enhance performance,reduce latency, and eliminate bottlenecks across critical data workflowsDevelop and support stored procedures, understand and code in open SQL language in SQL and HANA cloud foundry (BAS) environmentsDevelop smart data Integration (SDI) objects between multiple source systems which helps in transformation, extraction and loading into target databaseDevelop logical and physical data flow models for ETL applicationsPerform performance optimization and tuning on new and/or existing data warehouse and/or ETL operationsParticipate in ongoing architecture quality review activities to ensure both current and future capability meets architecture standardsCreate and maintain documentation for existing architecture, data dictionaries, future data warehouse architecture and business intelligence reportingPrepare accurate and detailed requirement specifications documents, workflow analysis, user guides, and functional specification documentsPerform other duties as assignedSupervisory Responsibility:This position will not manage employeesSkills & Abilities Needed for Position:Excellent analytical and problem solving skillsStrong planning and organizational skillsAbility to clearly articulate pros and cons of various technologies and platformsOutstanding interpersonal, verbal, and written commun

Created: 2025-11-24