BI ETL Developer

Rumpke 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 team!

As 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 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
• 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
• Develop smart data Integration (SDI) objects between multiple source systems which helps in transformation, extraction and loading into target database
• Develop logical and physical data flow models for ETL applications
• Perform performance optimization and tuning on new and/or existing data warehouse and/or ETL operations
• Participate in ongoing architecture quality review activities to ensure both current and future capability meets architecture standards
• Create and maintain documentation for existing architecture, data dictionaries, future data warehouse architecture and business intelligence reporting
• Prepare accurate and detailed requirement specifications documents, workflow analysis, user guides, and functional specification documents
• Perform other duties as assigned

Supervisory Responsibility:

• This position will not manage employees

Skills & Abilities Needed for Position:

• 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
• Ability to estimate the financial impact of individual solution architecture alternatives
• Ability to provide accurate estimates for tasks and project activity
• Possess personal drive and initiative regarding career growth
• Ability to work independently, prioritize own tasks, and tasks of others

Experience & Knowledge Needed for Position:

• Bachelors degree in Computer Science or related field required
• 3+ years related experience as a ETL Developer/Data Analyst or similar position
• Snowflake SnowPro Core Certification Preferred
• DBT Analytics Engineering Certification Preferred
• Experience working with SAP HANA cloud foundry and SAP Analytics Cloud is a plus

Physical Requirements in a Regular Workday:

• Occasionally stooping/kneeling/crouching/crawling
• Occasionally climbing and/or balancing
• Occasionally sitting/standing/walking

Additional Working Conditions/Aspects:

• Ability to travel between offices, as required
• Ability to work flexible hours; expected to work nights and weekends as needed
• Ability to work overtime, weekends, and/or holidays
• Must be available for 24-hour emergency calls
• Legally eligible to work in the United States
• Valid driver's license (if applicable)
• Must successfully complete pre-employment testing
• Must be able to read and speak the English language

This job description is intended to describe the general nature, complexity, and level of work to be performed by employees assigned to this position and is not to be construed as an exhaustive list of responsibilities, duties, and/or skills required. It does not prescribe or restrict the work that may be assigned. Furthermore, this does not establish an employment contract and is subject to change at the discretion of the company.

Rumpke Waste and Recycling is committed to equality in all aspects of employment. It is Rumpke's policy to provide equal opportunities to all employees and potential employees without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.