Business Intelligence ETL Developer III

Charter Communications; Charlotte (NC); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Charter Communications is seeking a BI ETL Developer III in Charlotte, NC, to design, develop, and support data integration jobs across Teradata, Redshift, and Oracle. You will monitor 24x7 production loads, manage incidents and changes, and mentor junior team members as SME.

You will work with Python, SQL, Unix scripting and AWS to build scalable data pipelines, with hybrid work arrangements available. The ideal candidate has strong BI/ETL, data warehousing, and orchestration experience.

Qualifications

• 7 years of production operations including 24x7 batch load monitoring, incident management, change management, and break-fix patch development.
• Designing, developing and troubleshooting complex SQL processes and stored procedures for data marts (Teradata, Redshift, Oracle).
• 5 years of workflow orchestration design, scheduling, monitoring using Automic Automation, Airflow, or Tivoli; deployment across environments with Git/Bitbucket.
• 2 years of AWS usage (EC2, Redshift, S3) to design, build, and manage data pipelines.

Responsibilities

• Design, develop, implement and support new and existing data integration jobs.
• Lead and mentor junior team members as SME and provide expert data guidance.
• Monitor production operations, load monitoring, incident management, and change management.
• Collaborate with partners to gather requirements and translate to technical specs for the team.
• Optimize performance and manage cross-system impacts of changes.

Skills

SQL

ETL

Python

Unix scripting

Data warehousing

Workflow orchestration

Jira

AWS

Airflow

Git/Bitbucket

Education

Bachelor's degree in IT/CS/Business or related field

Master's degree in IT/CS/Business or related field

Tools

Jira

Git/Bitbucket

SVN

Airflow

Broadcom Automic Automation

IBM Tivoli

AWS (EC2/Redshift/S3)

Teradata

Redshift

Oracle

Job description

TITLE

BI ETL Developer III (Multiple Openings)

LOCATION

Charlotte, NC

JOB SUMMARY

Responsible for Business Intelligence (BI) technology implementation and management. Responsible for production operations activities, including load monitoring, incident management, change management, break/fix development, performance tuning and optimization and application administration. Design, develop, implement and support new and existing data integration jobs using wide variety of tools. Lead and mentor junior team members and take responsibilities as subject matter expert (SME). Provide expert advice and education in the usage and interpretation of business data relevant to the business unit. Work closely with partners in gathering detailed requirements, establishing definitions, translating to technical requirements for team and gaining approval. Support all scheduled and non-recurring information needs of the business users. Query large datasets and tables comfortably to provide information requested by users. Actively identify solutions to enhance the existing BI infrastructure processes and technology. Understand and evaluate cross functional and system to system impacts of requirements and change requests.

EDUCATION/REQUIREMENTS

Bachelor's degree in Information Technology, Computer Science, Business or a related field. 7 years of experience: in production operations including working with 24x7 batch load monitoring, incident management, change management, and break-fix patch development and implementation to address production failures; utilizing Atlassian Jira to manage incidents, code changes, and deployments; designing, developing and troubleshooting complex SQL processes and stored procedures to load and update data according to business requirements in reporting data marts including Teradata, Redshift, and Oracle; and performing data integration using ETL methodologies, Python, SQL, and Unix scripting in large scale environments built using relational database systems including Redshift and Teradata. 5 years of experience: in workflow orchestration design, scheduling, monitoring and troubleshooting issues using a combination of Broadcom Automic Automation, Apache Airflow, or IBM Tivoli; managing deployment and code changes across environments using Git, Bitbucket, or SVN; and delivering reporting solutions in a Business Intelligence or Information Technology environment. 2 years of experience using AWS applications including EC2, Redshift, and S3 to design, build, and manage data pipelines and workflows on AWS cloud platform. In the alternative, the employer will accept a Master's degree in Information Technology, Computer Science, Business or a related field with 5 years of experience in the experience required above.

Hybrid arrangement is available.

GET TO KNOW US

Charter Communications provides superior communication and entertainment products for residential and business customers through the Spectrum brand. Our offerings include Spectrum Internet, TV, Mobile and Voice. Beyond our connectivity solutions, we also provide local news, programming and regional sports via Spectrum Networks and multiscreen advertising solutions via Spectrum Reach. When you join our team, you'll be keeping our customers connected to what matters most in 41 states across the U.S. Watch this video to learn more.

GROW YOUR CAREER HERE

We're committed to growing a workforce that reflects the customers and communities we serve - providing opportunities for employment and advancement to all team members. Spectrum is an Equal Opportunity Employer, including job seekers with disabilities and veterans. Learn about Life at Spectrum.

Here, our employees don't just have jobs, they're building careers. That's why we offer a comprehensive pay and benefits package that rewards employees for their contributions to our success, supporting all aspects of their well-being at every stage of life.

A qualified applicant's criminal history, if any, will be considered in a manner consistent with applicable laws, including local ordinances.