SQL Database Developer

Waste Connections
life insurance, flexible benefit account, long term disability, 401(k)

10001 Woodloch Forest Dr Ste 400 (Show on map)
Dec 20, 2024
SQL Database Developer Waste Connections is the premier provider of solid waste collection, transfer, recycling and disposal services, along with recycling and resource recovery, in mostly exclusive and secondary markets across the US and Canada. This is a full-time expert level position at Waste Connections, Inc. located in The Woodlands, Texas. The position will be primarily responsible for management and support of our internal routing and billing application as well as integrating newly acquired company data. This position is a member of the Operations Applications Information Systems group and will be part of the Database Team. Technology Requirements: Working with Microsoft SQL Stack e.g., SQL Server 2016 or higher, SSAS, SSIS, SSRS Transact SQL SQL Agent jobs Database Replication Database Administration SSRS and Crystal Reports Standardized reports as well as ad-hoc reporting in both SSRS and Crystal Reports. Tableau Report Writing DUTIES AND RESPONSIBILITIES SQL Server Development Writing SQL queries from scratch, must be very proficient in Transact SQL SSIS - take data from the old system, modify that data, and feed into the new system Use of data model concepts, master data management, operational process, SDLC, project management, data profiling, data cleansing/de-duplication processes. Use of SQL Server database, SQL Server Integration Services (SSIS), SQL Server analysis Services (SSAS), SQL Server Reporting Services (SSRS) and Azure Data platforms (Azure Data Factory, Azure Synapse, Azure Data Lakes, and Azure Databricks). Working with Microsoft SQL Stack e.g., SQL Server 2016 or higher, SSAS, SSIS, SSRS Data Analysis and Data Updates Live and Test database updates Create, update, and maintain Transact SQL scripts Create, update and maintain indexes, stored procedures, and triggers. Data Conversions Create scripts to migrate legacy data into our current routing and hauling software. Data migration with source database to target database mapping. Support Analyze data, provide solutions and support our existing customers. Database Administration Light administration such as performance monitoring, restores and backups. Working directly with the business clients. Extensive use of written and oral communication skills, particularly the ability to synthesize complex issues/scenarios into easy-to-understand concepts. Works closely with the business team, development team, analysis team, and the users to enhance quality and product delivered. Responsible for precisely communicating impact, status, priority, progress, and roadblocks to management Provides guidance in terms of priority and ownership of issues and requests. EDUCATION / TECHNICAL EXPERTISE / EXPERIENCE: 3+ years of experience in application development Bachelor's or Master's degree in Computer Science or a related field Excellent in Transact SQL Proficient in Microsoft SQL Server Administration Strong problem-solving and communication skills Ability to learn quickly and work independently or as part of a team Excellent Communication and Inter-personal skills, both with business customers and with fellow IT professionals (Business Analysts, Project Managers and Developers) Must be able to work in fast paced environment and be able to adapt to changing requirements Ability to multi-task Ability to work to deadline What's In It For You: You will be joining a great team and a company in a "work hard, play harder" environment along with a competitive salary. We also offer excellent benefits including: medical, dental, vision, flexible spending account, long term disability, life insurance, 401K retirement and unlimited opportunities to "Connect with Your Future". Other peripheral benefits include a strong presence in our local communities, sustainability initiatives, and more. For more information and to apply, please visitwww.wasteconnections.com. SQL Database Developer Waste Connections is the premier provider of solid waste collection, transfer, recycling and disposal services, along with recycling and resource recovery, in mostly exclusive and secondary markets across the US and Canada. https://www.wasteconnections.com/about-us This is a full-time expert level position at Waste Connections, Inc. located in The Woodlands, Texas. The position will be primarily responsible for management and support of our internal routing and billing application as well as integrating newly acquired company data. This position is a member of the Operations Applications Information Systems group and will be part of the Database Team. Technology Requirements: The following technologies are in production use with continual development requirements. Working with Microsoft SQL Stack e.g., SQL Server 2016 or higher, SSAS, SSIS, SSRS Transact SQL SQL Agent jobs Database Replication Database Administration SSRS and Crystal Reports Standardized reports as well as ad-hoc reporting in both SSRS and Crystal Reports. Tableau Report Writing DUTIES AND RESPONSIBILITIES SQL Server Development Writing SQL queries from scratch, must be very proficient in Transact SQL SSIS - take data from the old system, modify that data, and feed into the new system Use of data model concepts, master data management, operational process, SDLC, project management, data profiling, data cleansing/de-duplication processes. Use of SQL Server database, SQL Server Integration Services (SSIS), SQL Server analysis Services (SSAS), SQL Server Reporting Services (SSRS) and Azure Data platforms (Azure Data Factory, Azure Synapse, Azure Data Lakes, and Azure Databricks). Working with Microsoft SQL Stack e.g., SQL Server 2016 or higher, SSAS, SSIS, SSRS Data Analysis and Data Updates Live and Test database updates Create, update, and maintain Transact SQL scripts Create, update and maintain indexes, stored procedures, and triggers. Data Conversions Create scripts to migrate legacy data into our current routing and hauling software. Data migration with source database to target database mapping. Support Analyze data, provide solutions and support our existing customers. Database Administration Light administration such as performance monitoring, restores and backups. Working directly with the business clients. Extensive use of written and oral communication skills, particularly the ability to synthesize complex issues/scenarios into easy-to-understand concepts. Works closely with the business team, development team, analysis team, and the users to enhance quality and product delivered. Responsible for precisely communicating impact, status, priority, progress, and roadblocks to management Provides guidance in terms of priority and ownership of issues and requests. EDUCATION / TECHNICAL EXPERTISE / EXPERIENCE 3+ years of experience in application development Bachelor's or Master's degree in Computer Science or a related field Excellent in Transact SQL Proficient in Microsoft SQL Server Administration Strong problem-solving and communication skills Ability to learn quickly and work independently or as part of a team Excellent Communication and Inter-personal skills, both with business customers and with fellow IT professionals (Business Analysts, Project Managers and Developers) Must be able to work in fast paced environment and be able to adapt to changing requirements Ability to multi-task Ability to work to deadline What's In It For You: You will be joining a great team and a company in a "work hard, play harder" environment along with a competitive salary. We also offer excellent benefits including: medical, dental, vision, flexible spending account, long term disability, life insurance, 401K retirement and unlimited opportunities to "Connect with Your Future". Other peripheral benefits include a strong presence in our local communities, sustainability initiatives, and more. For more information and to apply, please visitwww.wasteconnections.com. Waste Connections is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to disability or protected veteran status.