Lead Business Intelligence Developer

$94,420 - $125,890/Yr

Lumen Technologies - Springfield, IL

Full-time - Mid Level

Remote - Springfield, IL

Telecommunications

About the position

We are currently seeking an experienced SQL developer to join our Business Intelligence, Reporting and Analytics team at Lumen. In this role, you will be involved in the entire development lifecycle, helping to define requirements, architect designs, develop complex ETL processes, design and code reports, test results, and produce analytics for internal use within the company. This position offers a unique 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 that support operational business performance reporting and internal customer self-service reporting. You will also analyze data, processes, and systems to identify opportunities for process and performance improvement. This is a fully remote position, allowing you to work from anywhere in the U.S., providing flexibility to thrive and deliver lasting impact in your role.

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.
• 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 procedures, views, etc.) to pull and manage data.
• Develop complex SSIS/Informatica packages to move and translate data.

Requirements

• 7+ years experience with Microsoft SQL Server and Oracle Database and the design and development of complex SQL based database objects, SSIS packages and Informatica Mappings.
• Strong knowledge of Data Modeling.
• Knowledgeable in performance tuning.
• Demonstrated ability to troubleshoot complex coding issues that require back tracing logic through multiple packages, stored procedures and data sources.
• Experience in finance domain and ERP knowledge.

Benefits

• Health insurance coverage
• Life insurance coverage
• Dental insurance coverage
• Vision insurance coverage
• 401(k) retirement savings plan
• 401(k) matching contributions
• Paid holidays
• Paid time off (PTO)
• Short-term incentives or sales compensation
• Long-term incentives for Director and VP positions
• Comprehensive benefits package enhancing physical, mental, emotional and financial wellbeing.