Analytics Engineer III

Republic Services

3d

About The Position

The Analytics Engineer III designs, develops, maintains, and continually improves analytics and reporting solutions, including ETL processes, data warehouses, cubes, dashboards, and model deployment. The role leads projects, mentors developers, educates users, stays current with technology, and develops proof-of-concepts to meet internal customer needs. It also develops technology road maps and maintains system and tool documentation.

The position designs and implements data solutions and pricing optimization algorithms, supports a single source of truth for data-driven decision-making and self-service, and deploys analytics models and tools in production environments. It uses SQL, R or Python, Excel, Power BI, and cloud computing environments such as AWS.

Requirements

• Master’s degree; the minimum qualifications also specify a bachelor’s degree in an analytical field such as Mathematics, Computer Science, Information Management, Statistics, Engineering, or Business Analytics.
• At least 5 years of demonstrated experience working with relational databases in the context of developing ETL processes and implementing data and analytics solutions.
• At least 5 years of experience maintaining databases and tools in a production environment, including query performance tuning and proactive maintenance.
• At least 5 years of experience with advanced programming in SQL and R or Python, and deploying analytics models and tools in a production environment with relational databases.
• Demonstrated expertise working with formal software development methodologies.
• Proficiency with relational databases and writing SQL queries.
• Proficiency with programming in R or Python in data science and/or engineering settings.
• Proficiency with Excel and Power BI.
• Proficiency with source control, such as GitHub, SVN, or Tortoise, in a multi-developer environment.
• Proficiency with cloud computing environments, such as AWS.

Nice To Haves

• Demonstrated expertise developing and maintaining pricing optimization and/or operational efficiency algorithms in a cloud computing environment such as AWS and/or enterprise IT environments.

Responsibilities

• Design, validate, and evaluate solutions using R, Python, SQL, and other programming tools.
• Design and build pricing optimization algorithms and rules-based pricing recommendations for new and existing customers.
• Design and implement the architecture, tools, and processes needed to provide a single source of truth for data-driven decision-making and self-service.
• Develop and manage end-to-end project plans and ensure on-time delivery.
• Educate and mentor team members on data, reports, and tools.
• Write ETL scripts using SQL Server Integration Services (SSIS) or similar tools to consume and process new data into the data warehouse.
• Design and build automated processes using Excel, SQL, and VBA to facilitate data transfer across teams.
• Design dashboards and tools that enable users to consume and interact with data.
• Implement in-database machine learning solutions using SQL Server and R or Python.
• Maintain and refine analytics and reporting solutions, including ETL processes, data warehouses, cubes, dashboards, and model deployment.
• Develop technology road maps, maintain system and tool documentation, and implement proof-of-concepts to address internal technology needs.
• Perform other job-related duties as assigned or apparent.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior