SQL Developer
Company Description
Zayo Group provides Communications Infrastructure services, including fiber and bandwidth connectivity, colocation and cloud services to the world’s leading businesses. In addition to high-capacity dark fiber, wavelength, Ethernet and other connectivity solutions, Zayo offers colocation and cloud services in its carrier-neutral data centers. Zayo provides clients with flexible, customized solutions and self-service through Tranzact, an innovative online platform for managing and purchasing bandwidth and services.
Position Description
This role is responsible for the design and development of T-SQL code to support billing functions. The position is also responsible for maintaining data quality and working with billing analysts to ensure monthly bills are accurate. This is an individual contributor position with no personnel responsibilities.
Responsibilities
- Member of the billing automation team working to improve our automation processes
- Design and implement T-SQL code to meet changing requirements after fully understanding product specific customizations
- Production support for billing automation processes
- Will occasionally be required to work outside of normal business hours
- Participate in cross-functional teams that address strategic business issues involving Salesforce.com and Zayo IT functionality
- Develop and maintain data exchange with other internal and third party solutions
Qualifications
- Intermediate to Advanced SQL skills
- Proficiency in MS SQL Server
- Solid understanding of data structures, data modeling, database design
- Bachelor’s degree Computer Information Systems or 5 years’ experience
- 3 or more years database design, T-SQL code development, and data management
- The ability to collaborate across functional groups
- The ability to communicate effectively at all levels of the organization
- Proven ability to independently perform database development, testing, implementation and documentation
- Demonstrated ability to effectively communicate technical issues and resolve problems at all levels of the organization both internally and externally
- Solid business analysis skill. Must have good inter-personal skills
- Must be comfortable in rapidly changing environment. Keen attention to detail and complex problem solving abilities from operational and technical perspective. Ability to work independently and engage supervisor as needed
- Demonstrated ability to effectively communicate technical issues and resolve problems at all levels of the organization both internally and externally
- Experience documenting and analyzing processes, procedures, and/or policies. Ability to handle full workload and meet proposed deadline
- Prior experience with C# a plus
- Prior experience with EDI a plus
- Prior experience with extract, transformation and load (ETL) tools a plus
- Prior experience with Salesforce.com a plus
Rewards
- Competitive compensation
- Excellent benefits including health, dental, vision, 401 (k), disability and life insurance
- Fitness membership discounts
- Generous paid time off policy including paid parental leave