Senior SQL Developer

  • Green Job Crawler
  • Phoenix, AZ
  • 27 Apr, 2020

Job Description

Republic Services is an industry leader in U.S. recycling and non-hazardous solid waste disposal. Through our subsidiaries, Republic’s collection operations, transfer stations, recycling processing centers, landfills and environmental services provide effective solutions to make recycling and waste disposal effortless for our 14 million customers nationwide. Our 36,000 employees working in 41 states and Puerto Rico are committed to providing a superior customer experience while helping ensure a cleaner, safer and healthier world for future generations. **Why Work with Us** At Republic Services, we strive to create a workplace that is meaningful and rewarding at every level of our organization. Our employees thrive in an atmosphere where safety is revered, and each person can be a compassionate steward of our environment. We hire the best people to make Republic a great place to work. We are focused on attracting talented individuals across professions who are as committed to serving customers and the planet as we are. We’re proud to be recognized on Barron’s 100 Most Sustainable Companies, Forbes World’s Most Innovative Companies, Forbes Best Employers for Women, Forbes Best Large Employers and Ethisphere’s World’s Most Ethical Companies lists. Republic is also the only company in our industry that is a certified Great Place to Work. POSITION SUMMARY: The Senior SQL Developer designs, develops, maintains, and continuously refines analytics and reporting solutions for the organization. This position is responsible for ETL processes, data warehouses, cubes, dashboards, and model deployment. The Senior SQL Developer leads projects, mentors developers, and educates users. The Senior SQL Developer stays up-to-date on the latest technology and implements proof-of-concepts to stay ahead of the technology demands of internal customers. This position will develop technology road maps and maintain system and tool documentation. PRINCIPLE RESPONSIBILITIES: + Design and implement the architecture, tools, and processes needed to provide the “single source of truth” to support data-driven decision making, and self-service. + Develop and manage end-to-end project plans and ensure on-time delivery. + Collaborate with internal customers, analysts, developers, data scientists, and database administrators. + Educate and mentor team members on data, reports, and tools. + Provide underlying data support for business metrics. + Write ETL scripts using SQL Server Integration Services (SSIS) or similar tools to consume and process new data into the data warehouse. + Develop, maintain, and enhance OLAP cubes using SQL Server Analysis Services (SSAS) or similar tools. + Design dashboards and tools to allow users to consume and interact with data. + Implement in-database machine learning solutions using SQL Server and R/Python. + Ensure security and integrity across all data. + Identify risks and opportunities across the business and drive solutions. + Troubleshoot and debug issues. + Perform other job-related duties as assigned or apparent. QUALIFICATIONS: + Master's degree + Advanced SQL, scripting, and data visualization experience + 2 years of demonstrated proficiency with quantitative tools including MS SQL, SAS, R, 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 Computer Science, Engineering, Statistics, a related field, or equivalent experience + 7 years of in-depth hands-on relational database and reporting experience including the ability to write SQL + 3 years of experience in the design and implementation of complex IT, data, and analytics solutions + 5 years maintaining databases in a production environment including query performance tuning and proactive maintenance 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. We work for Earth. Every day, we come to work with two purposes in mind – serving our customers and doing our part to preserve our Blue Planet®. Our commitment to both has led to such things as landfill innovations, solar energy projects, community education designed to teach people to properly recycle, ongoing efforts to reduce our vehicle emissions and improving safety through technology—to name a few. To put it simply, we are 35,000 guardians of the environment, striving to make the world a better place. Republic Services is more than a recycling and waste services company. We are a company dedicated to turning waste into possibilities. Together, united under the Republic Star, we are working for a cleaner, safer and healthier world where people thrive, not just for today, but for generations to come.