Lead Business Intelligence Developer

Indianapolis, IN, United States

About Lumen

Lumen connects the world. We are igniting business growth by connecting people, data and applications – quickly, securely, and effortlessly. Together, we are building a culture and company from the people up – committed to teamwork, trust and transparency. People power progress.

Lumen’s commitment to workplace inclusion and employee support shines bright. We’ve made the Newsweek 2024 Greatest Workplaces for Diversity list and achieved a perfect score of 100 on the Human Rights Campaign Corporate Equality Index (CEI) for the fifth consecutive year. Plus, we’re the top employer in the communications and telecom industry, ranking 12th overall across all industries in The American Opportunity Index.

We’re looking for top-tier talent and offer the flexibility you need to thrive and deliver lasting impact. Join us as we digitally connect the world and shape the future.

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.

Location

This is a fully remote position open to candidates based anywhere in the U.S.

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.

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/Informatica packages to move and translate data

What We Look For in a Candidate

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 procs and data sources.

Experience in finance domain and ERP knowledge..

Compensation

The starting salary for this role differs based on the employee's primary work location. Employees typically do not start at the top of the range, though compensation depends on each individual's qualifications.

Location Based Pay Ranges

$94420 - $125890 in these states: AR, ID, KY, LA, ME, MS, NE, SC, and SD.

$99390 - $132510 in these states: AZ, AL, FL, GA, IN, IA, KS, MO, MT, NM, ND, OH, OK, PA, TN, UT, VT, WV, WI, and WY.

$104360 - $139140 in these states: CO, HI, MI, MN, NV, NH, NC, OR, and RI.

$109330 - $145770 in these states: AK, CA, CT, DE, DC, IL, MD, MA, NJ, NY, TX, VA, and WA.

As with the pay range variety that's based on the region of a country, specific offers are determined by various factors such as experience, education, skills, certifications and other business needs.

Requisition #: 334040

Background Screening

If you are selected for a position, there will be a background screen, which may include checks for criminal records and/or motor vehicle reports and/or drug screening, depending on the position requirements. For more information on these checks, please refer to the Post Offer section of our FAQ page (https://jobs.lumen.com/global/en/faq) . Job-related concerns identified during the background screening may disqualify you from the new position or your current role. Background results will be evaluated on a case-by-case basis.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Equal Employment Opportunities

We are committed to providing equal employment opportunities to all persons regardless of race, color, ancestry, citizenship, national origin, religion, veteran status, disability, genetic characteristic or information, age, gender, sexual orientation, gender identity, gender expression, marital status, family status, pregnancy, or other legally protected status (collectively, “protected statuses”). We do not tolerate unlawful discrimination in any employment decisions, including recruiting, hiring, compensation, promotion, benefits, discipline, termination, job assignments or training.

Disclaimer

The job responsibilities described above indicate the general nature and level of work performed by employees within this classification. It is not intended to include a comprehensive inventory of all duties and responsibilities for this job. Job duties and responsibilities are subject to change based on evolving business needs and conditions.

Salary Range

Salary Min :

94420

Salary Max :

145770

This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Individual pay is based on skills, experience and other relevant factors.

This position is eligible for either short-term incentives or sales compensation. Director and VP positions also are eligible for long-term incentive. To learn more about our bonus structure, you can view additional information here. (https://jobs.lumen.com/global/en/compensation-information) We're able to answer any additional questions you may have as you move through the selection process.

As part of our comprehensive benefits package, Lumen offers a broad range of Health, Life, Voluntary Lifestyle and other benefits and perks that enhance your physical, mental, emotional and financial wellbeing. You can learn more by clicking here. (https://centurylinkbenefits.com)

Note: For union-represented postings, wage rates and ranges are governed by applicable collective bargaining agreement provisions.

Application Deadline

07/09/2024