Waste Management (WM), a Fortune 250 company, is the leading provider of comprehensive waste and environmental services in North America.
We are strongly committed to a foundation of operating excellence, professionalism and financial strength. WM serves nearly 25 million customers in residential, commercial, industrial and municipal markets throughout North America through a network of collection operations, transfer stations, landfills, recycling facilities and waste-
based energy production projects.
To enable our business to expand our lead in a market increasingly enhanced by technology, Waste Management is undertaking a substantial technology transformation.
We are seeking talented Information Technology professionals to join the Waste Management team who are motivated to help us transform the way we design, build and use technology.
With your skills and experience, we look for you to combine your technical expertise with industry best practices in an effort to align information technology solutions with Waste Management business strategy.
Job summary :
Listed below are key points regarding environmental demands and work environment of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.
Normal setting for this job is an office setting.
If this sounds like the opportunity that you have been looking for, please click " Join.
ETL (SSIS) Developer in Data Warehousing environment with strong data management and analytical skills. Good understanding of relational and dimensional data modeling / ER diagrams.
Familarity with reporting tools (SSRS / Spotfire). Good communication and presentation skills.
Key Requirements :
Strong knowledge of SQL and T-SQL, designing and tuning complex queries.
Requirement analysis and understanding of DW / BI technical specification documents.
Analyze and improve ETL framework and workflows, develop new packages, troubleshoot.
Perform data analysis, profiling and testing. Test data transformations and validate data for target and source systems.
Understanding of E / R diagrams and data models.
Assist in identifying and prioritizing business information needs, and defining business benefit of data warehousing.
Good problem solving and analytical skills.
Minimum Qualifications :
Minimum 5 years of experience with SQL Server environment.
Minimum 3 years of experience in ETL and with MS BI Stack (SSIS, SSRS, SSAS, SSMS).
Experience with reporting and data discovery tools such as SSRS, Spotfire (preferred), Tableau for relational as well as multidimensional data sources.
Excellent communication, documentation and presentation skills
BS Degree or equivalent required in Computer Science or similar area of study
Preferred Qualifications :
Exposure to Automating the ETL and data validation.
Experience with SQL Server Analysis Services and MDX.
Experience with BIML and metadata-driven ETL.