Analytics Engineer II

Disability Solutions - Phoenix, AZ

Full-time - Mid Level

Phoenix, AZ

10,001+ employees

Administrative and Support Services

About the position

The Analytics Engineer II at Republic Services plays a crucial role in designing, developing, and maintaining analytics and reporting solutions. This position focuses on ETL processes, data warehouses, dashboards, and model deployment, ensuring that the company stays ahead of technology demands while supporting internal customers with data-driven insights.

Responsibilities

• Maintains and troubleshoots pricing optimization algorithms and rules-based pricing recommendations for new and existing customers.
• Collaborates with internal customers, analysts, developers, data scientists, and database administrators.
• Provides underlying data support for business metrics.
• Writes ETL scripts using SQL Server Integration Services (SSIS) or similar tools to consume and process new data into the data warehouse.
• Designs and builds automated processes that leverage Excel, SQL, and VBA to facilitate data transfer across teams.
• Designs dashboards and tools to allow users to consume and interact with data.
• Implements in-database machine learning solutions using SQL Server and R/Python.
• Ensures security and integrity across all data.
• Troubleshoots and debugs issues.
• Performs other job-related duties as assigned or apparent.

Requirements

• Master's degree in an analytical field (Mathematics, Computer Science, Information Management, Statistics, Engineering).
• 4 years of demonstrated experience working with relational databases in the context of developing ETL processes and implementing data and analytics solutions.
• 4 years of experience maintaining databases and tools in a production environment including query performance tuning and proactive maintenance.
• Experience with cloud computing environments (e.g. AWS).
• Demonstrated experience working with a formal software development methodology.
• Experience developing and maintaining pricing optimization and rules-based algorithms.

Nice-to-haves

• Proficiency with relational databases and the ability to write SQL queries.
• Proficiency with programming in R or Python in data science and/or engineering settings.
• Proficiency with Excel and PowerBI.
• Proficiency with source control (e.g. Github, SVN, Tortoise) in a multi-developer environment.

Benefits

• 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).