Lead Business Intelligence Developer, Broomfield Co
Lumen

The Role

We are currently seeking an experienced SQL developer to join our Business Intelligence, Reporting and Analytics team.  You will be involved in the entire development lifecycle helping to define requirements, architect designs, develop complex ETL, design and code reports, test results and produce analytics for internal use within the company.  You will have the opportunity to participate in determining the direction of new development and actively share knowledge with other team members.

The primary purpose of this position is to develop reports in support of Operational business performance reporting and internal customer self-service reporting.  The secondary role will include analyzing data, processes, and systems to identify opportunities for process and performance improvement. 

The Main Responsibilities

• Be involved in all aspects of the development life cycle including, requirements gathering, architecture, development, testing, training, implementation and support of reporting applications to be used internally by our employees.
• Understand business requirements in BI context and design data models to transform raw data into meaningful insights
• Create dashboards and interactive visual reports using Power BI
• Analyzing data and present data through reports that aid decision-making
• Convert business requirements into technical specifications and decide timeline to accomplish
• Using your creativity and curiosity to partner with associates in other business areas to define business needs and help translate those needs into reporting system requirements
• Develop back end SQL Server and Oracle data marts in support of team data and reporting initiatives.
• Create complex SQL queries and database objects (stored procs, views, etc) to pull and manage data.
• Developing complex SSIS packages to move and translate data
• Interface with other teams and departments to develop new and modify existing reporting applications.
• Develop front end reporting applications using Microsoft PowerBI (including DAX) and Qlik Sense
• Resolve data and reporting issues from business partners.
• Provide data and programming expertise to meet internal ad hoc data requirements.
• Provide production support (generally during normal business hours) for scheduled reporting activities.

What We Look For in a Candidate

What you need to apply:

• Bachelors Degree in related field
• 6+ years experience with Microsoft SQL Server and the design and development of complex SQL based database objects and SSIS packages.
• Knowledgeable in performance tuning 
• Demonstrated ability to troubleshoot complex coding issues that require back tracing logic through multiple packages, stored procs and data sources.
• Excellent written and verbal communication skills required to communicate with business managers and end users.
• Strong problem-solving skills.
• Telecommunications industry experience a plus.
• Strong troubleshooting and investigation skills
• Work with a team and manage code through a source code repository
• Design, develop and deploy business intelligence solutions as per needs including potential app development utilizing ASP.net, C#, and JavaScript libraries
• An ideal candidate will have a proven history utilizing best practices in Business software development
• Identify key performance indicators (KPIs) with clear objectives and consistent monitoring