Analytics Engineer I

Republic Services is a leader in Environmental Services, partnering with customers to create a more sustainable world.

We are Sustainability in Action - our promise to be environmentally responsible and to help our customers be environmentally responsible too.

Why choose Republic?

Joining Republic isn't just about taking on a new job, it's about making a commitment to create a more sustainable world together. Our people provide an essential service, serving and impacting customers, neighborhoods, and communities everywhere.

As a company, we are proud of our values and encourage those who share in our aspirations to join our team:

• We protect our colleagues and communities through safe practices everywhere, every day.
• We are committed to serving our customers and communities by going above and beyond to exceed expectations.
• We take action to improve neighborhoods and communities by being environmentally responsible and creating a more sustainable world.
• We are driven to deliver results in the right way.
• We encourage a human centered culture that honors the unique potential and dignity of every person.

POSITION SUMMARY: The Analytics Engineer I assists in the execution, development, maintenance, and continuous refinement of analytics and reporting solutions. This position works on ETL processes, data warehouses, cubes, dashboards, and model deployment. The Analytics Engineer stays up-to-date on the latest technology and maintains system and tool documentation.

PRINCIPLE RESPONSIBILITIES:

• 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.
• Identifies risks and opportunities across the business and drive solutions.
• Troubleshoots and debugs issues.
• Performs other job-related duties as assigned or apparent.

QUALIFICATIONS:

• 2 years of in-depth hands-on relational database and reporting experience including the ability to write SQL
• 2 years of experience in the design and implementation of complex IT, data, and analytics solutions
• 2 years maintaining databases in a production environment including query performance tuning and proactive maintenance
• 1 year of demonstrated proficiency with quantitative tools including R, SAS, Python or similar statistical software
• 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

MINIMUM QUALIFICATIONS:

• Bachelor's Degree in an analytical field (Mathematics, Economics, Computer Science, Information Management, Statistics, Finance, Engineering, etc.)
• Advanced SQL, scripting, and data visualization experience
• Strong skills in Microsoft Excel including complex formulas, pivot tables, connecting to databases and cubes, and macros.

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.

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.• 401(k) plan with a generous company match.• Employee Stock Purchase Plan (ESPP).

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.

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.