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, Inc. plays a crucial role in the design, development, maintenance, and continuous refinement of analytics and reporting solutions. This position is responsible for managing ETL processes, data warehouses, cubes, dashboards, and model deployment. The Analytics Engineer II is expected to stay current with the latest technology trends and implement proof-of-concepts to meet the evolving technology demands of internal customers. Additionally, this role involves maintaining comprehensive system and tool documentation to ensure clarity and efficiency in operations. In this position, the Analytics Engineer II will maintain and troubleshoot pricing optimization algorithms and rules-based pricing recommendations for both new and existing customers. Collaboration is key, as this role requires working closely with internal customers, analysts, developers, data scientists, and database administrators to provide the underlying data support necessary for business metrics. The engineer will write ETL scripts using SQL Server Integration Services (SSIS) or similar tools to effectively consume and process new data into the data warehouse. Furthermore, they will design and build automated processes that leverage Excel, SQL, and VBA to facilitate seamless data transfer across teams. The role also includes designing dashboards and tools that allow users to easily consume and interact with data. The implementation of in-database machine learning solutions using SQL Server and R/Python is another critical responsibility. Ensuring the security and integrity of all data is paramount, and the engineer will troubleshoot and debug any issues that arise. Other job-related duties may be assigned as necessary, reflecting the dynamic nature of the position.

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
• 2 years maintaining databases in a production environment including query performance tuning and proactive maintenance
• Experience using source control (e.g., Github, SVN, Tortoise) in a multi-developer environment
• Experience working with a formal software development methodology
• Strong requirements gathering and documentation skills
• Experience developing and maintaining pricing optimization and rules based algorithms
• Bachelor's Degree in an analytical field (Mathematics, Economics, Computer Science, Information Management, Statistics, Finance, Engineering, etc.)
• 2 years of in-depth hands-on relational database and reporting experience including the ability to write SQL
• 2 years of experience in Advanced SQL, scripting, and data visualization experience
• 2 years of experience in the design and implementation of complex IT, data, and analytics solutions
• 2 years of strong skills in Microsoft Excel including complex formulas, pivot tables, connecting to databases and cubes, and macros
• 2 years of experience coding in VBA
• 1 year of demonstrated proficiency with quantitative tools including R, SAS, Python or similar statistical software.

Benefits

• Comprehensive medical benefits coverage
• Dental plans
• 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)