Business Intelligence Architect II

Posted Yesterday
Be an Early Applicant
Charlotte, NC, USA
In-Office
Senior level
Information Technology • Internet of Things • Mobile • On-Demand • Software
The growth of our industry and evolving technology powers our employees’ careers as they move up or around the company.
The Role
Design and implement end-to-end BI and data warehouse architectures. Translate business requirements into solution blueprints, logical/physical data models, and scalable BI metrics/cubes. Develop SQL, ETL/data movement patterns, and standards; review upstream sources, advise architecture boards, lead proofs-of-concept, and provide cross-team governance and guidance. Work with cloud/on-prem MPP platforms and data modeling tools.
Summary Generated by Built In
TITLE: BI Architect II (Multiple Openings)
LOCATION: Charlotte, NC
JOB SUMMARY: Create solutions blueprints, high-level design and implementation strategies, and logical and physical data models for end-to-end business intelligence (BI) and data warehousing solutions. Translate business requirements and end user's needs into architecture blueprints deliver cost effective, high performing, and high-quality BI solutions. Cross-reference diverse requirements from different verticals to coalesce requirements into standard scalable companywide catalog of metrics, BI data models, cubes, and reporting solutions. Architect, develop, implement, and support logical and physical data models for BI data repositories, including data movement infrastructures. Review upstream data source data models and assess/mitigate the impact on BI side for new integrations or changes. Develop road maps for BI applications, align development plans, and ensure effective integration to support end-to-end data solutions. Provide architectural expertise, thought leadership, direction, and assistance across entire BI organization. Participate in Architecture Review Board meetings. Review solutions presented by BI architects and provide constructive feedback. Define new architectural and data movement patterns. Define, implement, and promote BI architectural guidelines/standards, best practices, governing mechanisms, key processes, controls, and supporting tools. Ensure conceptual and architectural integrity of BI platforms and analytical solutions. Diagnose highly complex issues and evaluate, recommend, and execute best resolution spanning multiple tiers in the BI/DW technology stack. Advise on allocation of budget to meet BI architectural initiatives critical to business success. Contribute to the execution of proofs-of-concept for new approaches and platforms through research of trends and technological innovations in BI, data warehousing and analytics space. Identify tools and components used within the domain based on the enterprise toolset and define exceptions. Work in a data warehousing environment and databases including AWS Redshift, Snowflake, Teradata, Netezza, DB2, or SQL Server. Support data warehouse architecture including data sourcing/acquisition, integration, transformation, and presentation using technologies including SQL Stored Procedures, Shell Scripts, and Python. Develop and implement complex SQL on MPP platforms including AWS Redshift, Snowflake, or Teradata Vantage. Translate business requirements into solution blueprints. Support logical and physical database design for data warehousing including 3NF and Star Schemas using Erwin, Vision, or similar leading data modeling tools. Develop roadmaps, standards, guideline, and principles for BI architecture.
EDUCATION / REQUIREMENTS: Bachelor's degree in Computer Science, Computer Engineering, Electronic Engineering, Mathematics, or a related field. 5 years of experience in: data warehousing environment and databases including experience in at least one of the following: AWS Redshift, Snowflake, Teradata, Netezza, DB2, or SQL Server; and data warehouse architecture including data sourcing/acquisition, integration, transformation, and presentation using technologies including SQL Stored Procedures, Shell Scripts, and Python. 3 years of experience: developing and implementing complex SQL on MPP platforms including at least one of the following: AWS Redshift, Snowflake, or Teradata Vantage; and translating business requirements into solution blueprints. 2 years of experience in: logical and physical database design for data warehousing including 3NF and Star Schemas using Erwin or Vision; and developing roadmaps, standards, guidelines, and principles for BI architecture.
Hybrid arrangement is available.
10% domestic travel required.
#LI-ML6
BBL602 2026-75418 2026
Here, our employees don't just have jobs, they're building careers. That's why we offer a comprehensive 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.
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.
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.

Skills Required

  • Bachelor's degree in Computer Science, Computer Engineering, Electronic Engineering, Mathematics, or related field.
  • 5 years experience in data warehousing and databases with experience in at least one: AWS Redshift, Snowflake, Teradata, Netezza, DB2, or SQL Server.
  • 5 years experience with data warehouse architecture including data sourcing/acquisition, integration, transformation, and presentation using technologies including SQL Stored Procedures, Shell Scripts, and Python.
  • 3 years experience developing and implementing complex SQL on MPP platforms (at least one: AWS Redshift, Snowflake, Teradata Vantage).
  • 3 years experience translating business requirements into solution blueprints.
  • 2 years experience in logical and physical database design for data warehousing including 3NF and Star Schemas using Erwin or Vision.
  • 2 years experience developing roadmaps, standards, guidelines, and principles for BI architecture.
  • Ability to travel domestically up to 10%.

What the Team is Saying

Eilisa
Stephanie
Raquenel
Mary
Kat K.

Spectrum Compensation & Benefits Highlights

  • Retirement Support 401(k) match is dollar-for-dollar up to 6% of pay, plus an additional 3% company contribution for most employees, creating up to 9% in annual employer retirement funding. This structure provides meaningful, predictable long-term savings support.
  • Affordable Benefits Medical, dental, and vision options are positioned as affordable, with the company absorbing annual cost increases for the past 12 years to keep employee premiums lower. 24/7 EAP counseling expands access to no-cost mental health support.
  • Parental & Family Support Six weeks paid parental leave (14 weeks for birth mothers), fertility benefits, and up to $15,000 for adoption and surrogacy indicate strong family-building support. These benefits complement standard PTO and paid holidays that increase with tenure.

Spectrum Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Stamford, CT
100,000 Employees
Year Founded: 1993

What We Do

Our Product and Technology team creates, develops, and operates the nation’s fastest mobile service, most reliable internet service, most viewed live TV app, and the most advanced WiFi, serving nearly 100 million users and 500 million devices. We are transforming the next era of connectivity and entertainment experiences together.   The experience within Spectrum’s Product and Technology team is unmatched and there are opportunities to grow your career as a designer, architect, engineer, developer, operator, or data scientist.  We are creative, disciplined, hard-working, complex-problem solvers that believe in collaborating to deliver the highest quality customer experience.

Why Work With Us

At Spectrum, we continually refine technology, process, and structure. We are committed to delivering a superior network infrastructure, the most competitive products, and highly rated customer experiences. Our talented team of experts deploys technology solutions and builds systems and tools for our employees to provide exceptional operations.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Spectrum Teams

Team
Product & Tech
About our Teams

Spectrum Offices

OnSite Workspace

Typical time on-site: None
Company Office Image
HQStamford, CT
Austin, TX
Company Office Image
Charlotte, NC
Company Office Image
Denver, CO
Los Angeles, CA
Company Office Image
Saint Louis, MO
Stamford, CT
Learn more

Similar Jobs

Spectrum Logo Spectrum

Manager, Outside Sales

Information Technology • Internet of Things • Mobile • On-Demand • Software
In-Office
Greensboro, NC, USA
100000 Employees

Spectrum Logo Spectrum

BI ETL Developer III (Multiple Openings)

Information Technology • Internet of Things • Mobile • On-Demand • Software
In-Office
Charlotte, NC, USA
100000 Employees

Spectrum Logo Spectrum

Application Engineer

Information Technology • Internet of Things • Mobile • On-Demand • Software
In-Office
Charlotte, NC, USA
100000 Employees

Spectrum Logo Spectrum

Product Owner

Information Technology • Internet of Things • Mobile • On-Demand • Software
Hybrid
Charlotte, NC, USA
100000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account