POSITION SUMMARY: The Sr. Analyst Data Analytics & Reporting is responsible for gathering, analyzing and documenting technical specifications and data mappings from business requirements to provide accurate direction to application developers. The Sr. Analyst Data Analytics & Reporting leverages their analytical skills, knowledge of application tools and techniques to drive the development of services and analytical solutions that meet the business requirements. The Sr. Analyst Data Analytics & Reporting works closely with IT architecture and development teams to ensure product development meets design criteria and deployment timelines. The Sr. Analyst Data Analytics & Reporting is a data specialist who works with the SME’s to analyze and develop standards for preparing and delivering business reports. The Sr. Analyst Data Analytics & Reporting contributes to the overall improvement of business reporting by maintaining the data systems and implementing processes and initiatives that ultimately increase the effectiveness and integrity of data reporting and documentation. This role relies heavily on analytical skills to evaluate complex information, formulate insights, and develop sound recommendations to support the management of assets, inventory, work orders, planning & scheduling, warranty, vendor management, master data management and reporting & analytics.
PRINCIPAL RESPONSIBILITIES:
Standardizes, audits, queries, and cleanses system data and develops governance processes to maintain data cleanliness.
Owns reports requirements development (technical specifications and data mapping requirements), rationalization and prioritization in conjunction with business partners.
Partners with the business and functional leads to ensure business understanding of the code and what it is doing in a deployed environment. This includes training the end users by explaining detailed software mapping documents.
Coordinates with other analysts to ensure alignment of middleware solutions across various business domains.
Interfaces with executive and operational management to create software-mapping documents including transformations and software algorithms.
Compiles information into various formats, may create executive briefings from entity relationship diagrams, logical architectures and presents information to executive and operational leadership in written and verbal forms.
Defines and documents reporting metrics and how those metrics are calculated from source system data. Analyzes source data systems for content, writes technical definition specifications, report layouts/mockups and test scripts.
Uses Rally or similar agile tools to create scorecards and reports for communicating metrics, goals and performance-to-date.
Creates technical flow diagrams based on standards and process flow diagrams, wireframes and prototypes which are used to collaborate and guide development resources to rapidly develop integration assets.
Uses query languages like SQL to mine data, create reports and uses the latest technology to identify and analyze performance trends. This includes performance and forecast impact on future results. May also make recommendations on use of information to improve results, including recommendations on changes to business processes.
Constructs SQL queries in large-scale databases to provide research, audit and analysis of complex data needs.
Develops quality training content and manages rollout of new or adjusted processes to the field.
Develops and completes system and dashboard test scripts.
Uses agile software tools to track performance and creates logical software flow diagrams to solve complicated business processes.
Performs other job-related duties as assigned or apparent.
QUALIFICATIONS:
Experience with business intelligence and Reporting tools like MSFT Power BI, Qlik, Tableau, Alteryx.
Experience in workflow modeling, data modeling, process engineering.
Experience using data virtualization tools and data catalogs like Denodo, AWS Glue, TIBCO Data Virtualization.
Demonstrated ability to extract data from large data warehouse (using SQL/SAS and/or Advanced Excel with Macros, Advanced Excel math Functions, Pivot tables, Pivot Charts and Excel dashboards for data analysis )
Solid working knowledge of SharePoint.
MINIMUM QUALIFICATIONS:
Minimum of 5 years of experience in a business or technical analysis role
Experience with project management techniques (i.e. 3 years experience with Agile, experience using Agile software tools such as Rally or similar tools)
Rewarding Compensation and Benefits
Eligible employees can elect to participate in:
• Comprehensive medical benefits coverage, dental plans and vision coverage.
• Health care and dependent care spending accounts.
• Short- and long-term disability.
• Life insurance and accidental death & dismemberment insurance.
• Employee and Family Assistance Program (EAP).
• Employee discount programs.
• Retirement plan with a generous company match.
• Employee Stock Purchase Plan (ESPP).
• Paid Time Off (PTO)
• Benefits: https://jobs.republicservices.com/us/en/about-us/benefits
The statements used herein are intended to describe the general nature and level of the work being performed by an employee in this position, and are not intended to be construed as an exhaustive list of responsibilities, duties and skills required by an incumbent so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the Company.
EEO STATEMENT:Republic Services is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, protected veteran status, relationship or association with a protected veteran (spouses or other family members), genetic information, or any other characteristic protected by applicable law.
ABOUT THE COMPANY
Republic Services, Inc. (NYSE: RSG) is a leader in the environmental services industry. We provide customers with the most complete set of products and services, including recycling, waste, special waste, hazardous waste and field services. Our industry-leading commitments to advance circularity and support decarbonization are helping deliver on our vision to partner with customers to create a more sustainable world.
In 2023, Republic’s total company revenue was $14.9 billion, and adjusted EBITDA was $4.4 billion. We serve 13 million customers and operate more than 1,000 locations, including collection and transfer stations, recycling and polymer centers, treatment facilities, and landfills.
Although we operate across North America, the collection, recycling, treatment, or disposal of materials is a local business, and the dynamics and opportunities differ in each market we serve. By combining local operational management with standardized business practices, we drive greater operating efficiencies across the company while maintaining day-to-day operational decisions at the local level, closest to the customer.
Our customers, including small businesses, major corporations and municipalities, want a partner with the expertise and capabilities to effectively manage their multiple recycling and waste streams. They choose Republic Services because we are committed to exceeding their expectations and helping them achieve their sustainability goals. Our 41,000 team members understand that it's not just what we do that matters, but how we do it.
Our company values guide our daily actions:
Safe: We protect the livelihoods of our colleagues and communities.
Committed to Serve: We go above and beyond to exceed our customers’ expectations.
Environmentally Responsible: We take action to improve our environment.
Driven: We deliver results in the right way.
Human-Centered: We respect the dignity and unique potential of every person.
We are proud of our high employee engagement score of 86. We have an inclusive and diverse culture where every voice counts. In addition, our team positively impacted 4.6 million people in 2023 through the Republic Services Charitable Foundation and local community grants. These projects are designed to meet the specific needs of the communities we serve, with a focus on building sustainable neighborhoods.
STRATEGY
Republic Services’ strategy is designed to generate profitable growth. Through acquisitions and industry advancements, we safely and sustainably manage our customers’ multiple waste streams through a North American footprint of vertically integrated assets.
We focus on three areas of growth to meet the increasing needs of our customers: recycling and waste, environmental solutions and sustainability innovation.
With our integrated approach, strengthening our position in one area advances other areas of our business. For example, as we grow volume in recycling and waste, we collect additional material to bolster our circularity capabilities. And as we expand environmental solutions, we drive additional opportunities to provide these services to our existing recycling and waste customers.
Recycling and Waste
We continue to expand our recycling and waste business footprint throughout North America through organic growth and targeted acquisitions. The 13 million customers we serve and our more than 5 million pick-ups per day provide us with a distinct advantage. We aggregate materials at scale, unlocking new opportunities for advanced recycling. In addition, we are cross-selling new products and services to better meet our customers’ specific needs.
Environmental Solutions
Our comprehensive environmental solutions capabilities help customers safely manage their most technical waste streams. We are expanding both our capabilities and our geographic footprint. We see strong growth opportunities for our offerings, including PFAS remediation, an increasing customer need.
SUSTAINABILITY INNOVATION
Republic’s recent innovations to advance circularity and decarbonization demonstrate our unique ability to leverage sustainability as a platform for growth.
The Republic Services Polymer Center is the nation’s first integrated plastics recycling facility. This innovative site processes rigid plastics from our recycling centers, producing recycled materials that promote true bottle-to-bottle circularity. We also formed Blue Polymers, a joint venture with Ravago, to develop facilities that will further process plastic material from our Polymer Centers to help meet the growing demand for sustainable packaging. We are building a network of Polymer Centers and Blue Polymer facilities across North America.
We continue to advance decarbonization at our landfills. As demand for renewable energy continues to grow, we have 70 landfill gas-to-energy projects in operation and plan to expand our portfolio to 115 projects by 2028.
RECENT RECOGNITION
Barron’s 100 Most Sustainable Companies
CDP Discloser
Dow Jones Sustainability Indices
Ethisphere’s World’s Most Ethical Companies
Fortune World’s Most Admired Companies
Great Place to Work
Sustainability Yearbook S&P Global