BI ETL Developer II
Our fast-growing Business Intelligence (BI) groups are studying metrics across the company to maximize performance. With a foundation of expert analysis, BI groups are going beyond and inspiring us to greater things. As partners in innovation, they’re using imagination and collaboration to put us at the forefront of technology. They’re handling high-volume structured and unstructured data points, turning raw information into visions of Spectrum’s future. Find exciting growth potential in one of our most tech-forward groups.
- Full Time
- Job Level: Mid to Senior
- Travel: Minimal (if any)
What makes you successful in Business Intelligence?
Check out the top traits to see if you have the right mix.
- Tech Savvy
- Team Player
- Goal Oriented
- Detail Oriented
- Problem Solver
Hear from Our Team
Having interned at Spectrum, I knew the company culture and I liked what the team had to say about the position. I bring a good attitude and a strong drive to succeed, and everyone is very accommodating and patient as I learn. I just finished school, but am learning quickly and hope to make a greater difference as time goes on. My office has a really positive atmosphere. Everyone is very friendly and morale is high, which makes a huge difference. This starts at the top. I admire the leadership on my team. They go above and beyond to take care of their own. And the benefits are exceptional. This is a company I can see myself staying with for a long time.Gabriel, Business Intelligence Developer
TECHNOLOGY UNLOCKS THE FUTURE
Spectrum is proud to be the first U.S.-based broadband provider to introduce an integrated wireless router featuring next-generation 802.11ax technology.
CONNECTING YOU TO COMPREHENSIVE BENEFITS
We have plans to suit every individual and family.
THIS IS SPECTRUM
Learn about our 95,000 employees, products and services, and advertising solutions offered to 30 million customers in 41 states.
Medical, prescription drug, dental, and vision plans available.
Paid Time Off
Paid vacation, sick and personal time, and holidays.
401(k) Retirement Savings
We provide a 100% match for every dollar you contribute, up to 6% of your eligible pay.
Find high income potential with us.
We support continuing education for personal and professional growth.
Free and discounted Spectrum services where available.
ResponsibilitiesDate posted 04/23/2021 Requisition Number: 280276BR Location: United States - Connecticut - Stamford Area of Interest: Business Intelligence, Information Technology, Software Engineering Position Type: Full Time
The Spectrum ETL Developer II plays a key role in designing, developing and supporting new and existing solutions for our users. The ETL Developer’s primary contribution to the team involves transforming data into meaningful and accurate information which the business can consume.
MAJOR DUTIES AND RESPONSIBILITIES
Participate in active discussions with team members and users to understand business requirements
Work closely with IT, Architecture, Business Analysts and Report Developers to achieve business objectives
Understand and Implement best practice solutions per development standards
Produce Ad Hoc Reports to answer business questions quickly and thoroughly
Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions
Design and develop workflows and datasets in Alteryx to be used for Tableau reporting
Troubleshoot, diagnose and resolve data quality and performance issues
Communicate complex topics and analyses to non-technical business personnel
Provide accurate level of effort estimates for data integration development to management
Perform other duties as requested by supervisor
Skills/Abilities and Knowledge
- Ability to communicate orally and in writing in a clear and straightforward manner
- Ability to communicate with all levels of management and company personnel
- Ability to handle multiple projects and tasks
- Ability to make decisions and solve problems while working under pressure
- Ability to prioritize and organize effectively
- Ability to show judgment and initiative and to accomplish job duties
- Solid understanding of Microsoft Office Suite (Word, Excel, Visio, MS Project, etc.)
- Ability to work with others to resolve problems, handle requests or situations
- Ability to perform detailed business analysis and design
- Ability to transform business requirements into a technical solution
- Ability to learn new technologies and tools
- Knowledge of different ETL design and development methodologies
- Strong knowledge of Alteryx preferred
- Strong knowledge of SQL and Stored Procedures
- Strong understanding of BI/DW architecture and concepts
- Strong understanding of how data governance plays a role in BI
- Strong understanding of how multiple data sources can be consolidated together to produce BI Solutions
Bachelor’s degree or foreign equivalent in Information Technology or business related field, or equivalent experience
RELATED WORK EXPERIENCE
4+ years of SQL Query Design in large-scale data warehouse environments
4+ years of data integration development using ELT methodology
4+ years of data collection and database/report design
4+ years of work experience in delivering IT/BI solutions
2+ years of work experience using advanced analytics tools (Alteryx preferred)
Experience working with Alteryx, Tableau
Experience working with Telecom/Cable MSO data and applications
Experience working with ETL workflow and scheduling applications
The health and safety of our employees and candidates is very important to us. Spectrum has adopted virtual mobile recruiting tools that allow us to continue meeting new candidates. We look forward to “virtually” meeting you.
The Spectrum brands (including Spectrum Networks, Spectrum Enterprise and Spectrum Reach) are powered and innovated by Charter Communications. Charter Communications reaffirms its commitment to providing equal opportunities for employment and advancement to qualified employees and applicants. Individuals will be considered for positions for which they meet the minimum qualifications and are able to perform without regard to race, color, gender, age, religion, disability, national origin, veteran status, sexual orientation, gender identity, or any other basis protected by federal, state or local laws.