Job Description
Description
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.
Qualifications
Education
High School (required)
General Education Diploma (preferred)
Bachelors of Relevant field (required)
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)
