Get in Touch

Live chat is currently offline, please check back later.


Data and Integration Engineer

Data and Integration Engineer

Location: Boulder,CO     Department: IT

Job Number: VB-14006

Apply Now

Data and Integration Engineer                                                                  

Boulder, CO



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, development, deployment of MSSQL data warehouse to support analysis and reporting. The position is also responsible for maintaining, supporting, and enhancing existing integration systems as well as assisting in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities. This is an individual contributor position with no personnel responsibilities.




  • Member of the data architecture team working to protect, improve, and leverage the value of our data assets
  • Implements interfaces to meet changing integration requirements after fully understanding company specific configurations
  • Maintain & develop current data warehouse integrations and processes
  • Production support for integration servers
  • SQL & Reporting support across various business groups
  • Manage and coordinate data loads in production environment
  • Follows standard test plan to test each client and ensure that configured functionality meets the needs of the company
  • Negotiates and makes changes to existing interfaces as needed
  • Ability to handle multiple priorities and meet aggressive deadlines
  • Required to be part of an on-call rotation and will occasionally be responsible for after-hours maintenance work




  • Intermediate to Advanced SQL skills
  • Proficiency in MS SQL Server, SSRS & MS BI stack preferred
  • Bachelor’s degree Business Intelligence, Computer Information Systems or similar
  • 5 or more years database design, data management, reporting and ETL.
  • The ability to collaborate across functional groups.
  • The ability to communicate effectively at all levels of the organization.
  • Prior experience with data migration/integration efforts
  • Prior experience with Salesforce.com a plus
  • Prior experience with Cast Iron integration application a plus
  • Prior experience with DbAmp a plus




  • 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





Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time

Physical Requirements

Physical Requirement Codes

  • NP Not Present
  • O Occasional (up to 25% of time)
  • F Frequent (26% – 74% of time)
Standing/walking: Remaining on one’s feet in an upright position at a workstation or moving about a work area. x      
Sitting: Remaining in the normal seated position.    


Carrying: Moving an object, usually by holding it in hands or arms or on shoulders. x      
Lifting: Raising or lowering an object from one level to another using hands, arms and/or shoulders, back and legs. x      
Pushing/pulling: Exerting force on an object so that the object moves away from/toward the force. x      
Climbing: Ascending or descending ladders, stairs, ramps, poles and the like, using feet and legs, and/or hands and arms. x      
Stooping: Bending body downward and forward by bending body down at the waist. x      
Kneeling: Bending legs at the knees to come to rest on knee or knees. x      
Crawling: Moving about on hands and knees or hands and feet. x      
Reaching: Extending hand(s) and arm(s) in any direction. x      
Handling: Seizing, holding, grasping, turning or otherwise performing precision work with hands. x      
Crouching: Bending the body downward and forward by bending at leg and spine. x      
Bending/twisting: Continual, intermittent flexion or rotation of the wrist or spine. x      
Talking: Expressing or exchanging ideas by means of the spoken word. x      
Hearing: Receiving detail information through oral communication. x      
Computer usage or other special equipment to be operated.       x
  • C Constant (75% – 100% of time)




Zayo is an Equal Opportunity Employer. Zayo does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

Apply Now