Company Description Zayo provides mission-critical bandwidth to the world’s most impactful companies, fueling the innovations that are transforming our society. Zayo’s 133,000-mile network in North America and Europe includes extensive metro connectivity to thousands of buildings and data centers. Zayo’s communications infrastructure solutions include dark fiber, private data networks, wavelengths, Ethernet, and dedicated Internet access. Zayo serves wireless and wireline carriers, media, tech, content, finance, healthcare and other large enterprises. Position Description This role is responsible for the design, development, deployment of an 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. Responsibilities Member of the data engineering team working to protect, improve, and leverage the value of our data assets Build and automate new ETL processes to pull from many disparate data sources to centralize information in a new data warehouse design Maintain and develop existing data warehouse integrations and ETL processes to move data efficiently between various enterprise systems. Miscellaneous automation of data processes across a wide variety of customer platforms • Implements interfaces to meet changing integration requirements after fully understanding company specific configurations Production support for integration servers SQL & Reporting support across various business groups 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 Qualifications Intermediate to Advanced SQL skills Proficiency in MS SQL Server, SSRS & MS BI stack preferred Experience computing in a Cloud Datalake/Warehouse environment preferred Experience with version control and deploy via GitHub/GitLab preferred Bachelor's degree Business Intelligence, Computer Information Systems or similar 3 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 or similar tools a plus Prior experience with DbAmp a plus Prior experience with dbt or similar data transformation tool a plus Base salary for CO $75,500-110,700 Benefits, Rewards & Wellness Excellent Health, Dental & Vision Insurance Retirement 401(k) Savings Plan Fitness membership discounts Generous paid time off policy including paid parental leave Please note, in accordance with Zayo's commitment to providing and maintaining a workplace free of recognized hazards, all U.S. and Canadian employees and any employee, vendor, customer, or visitor who enters a Zayo office or facility in the U.S. and Canada must be fully vaccinated against COVID-19 and provide proof of such vaccination. If you are hired by Zayo, you will be required to provide proof of vaccination or have a valid religious or medical reason not to be vaccinated.