Be an Early Applicant
The growth of our industry and evolving technology powers our employees’ careers as they move up or around the company.
The Role
Design and govern end-to-end BI and data warehouse architectures. Create solution blueprints, logical and physical data models, and complex MPP SQL. Coordinate with BI teams, DBAs, and IT partners, perform ETL development, migrate schemas, present to Architecture Review Board, and research/adopt BI/DW technologies and best practices.
Summary Generated by Built In
TITLE: BI Architect III (Multiple Openings)
LOCATION: Maryland Heights, MO
JOB SUMMARY: Create solution blueprints, high-level design and implementation strategies, logical and physical data models for end-to-end business intelligence (BI) and data warehousing solutions. Set architecture direction for BI development verticals. Research data warehousing and BI technologies. Integrate BI architecture with Enterprise architecture and other enterprise level disciplines including security and engineering. Work in collaboration with BI delivery team leaders, business analysts and business leaders to understand business requirements and end user's needs. Translate business requirements and end user's needs into architecture blueprints that deliver cost effective and high performing, high quality BI solutions. Design, develop, manage, and update logical and physical data models for the BI data marts. Work with IT partners to review upstream data warehouse data models and assess/mitigate impact. Communicate database designs to business and technical audiences, including business users, program sponsors, database administrators, ETL developers, and BI developers. Migrate schema changes between development, QA, and production environments. Provide architectural expertise, thought leadership, direction, and assistance across entire BI organization. Present proposed solution blueprints to the Architecture Review Board. Communicate solution blueprints to project team members, business users, and program sponsors. Participate in Architecture Review Board meetings. Review solutions presented by other BI architects and provide constructive feedback. Engage with IT teams including Data Management, DBAs, Security, Storage, and Networking for project needs. Participate in capacity planning for all layers in the BI technology stack and solve complex production issues spanning multiple tiers in the BI/DW technology stack. Research and evaluate new BI /DW technologies and make adoption recommendations. Develop and document technical standards and best practices for the BI organization; develop and execute to BI Architecture roadmaps; develop training plans; and develop and refine BI Architecture roles and responsibilities. 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. Support logical and physical database design for data warehouses including Erwin, Visio, or similar leading data modeling tools. Develop and implement complex SQL on MPP platforms including AWS Redshift, Snowflake, or Teradata Vantage. Perform ETL job development for data warehousing in any data warehouse databases.
EDUCATION / REQUIREMENTS: Bachelor's degree in Computer Science, Information Technology, Economics, Mathematics, Computer Engineering, or a related field. 8 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. 5 years of experience in: logical and physical database design for data warehouses including Erwin or Visio; developing and implementing complex SQL on MPP platforms including at least one of the following: AWS Redshift, Snowflake, or Teradata Vantage; and performing ETL job development for data warehousing in any data warehouse databases.
Hybrid arrangement is available.
Requires 10% domestic travel.
#LI-ML6
BBL701 2026-74072 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.
LOCATION: Maryland Heights, MO
JOB SUMMARY: Create solution blueprints, high-level design and implementation strategies, logical and physical data models for end-to-end business intelligence (BI) and data warehousing solutions. Set architecture direction for BI development verticals. Research data warehousing and BI technologies. Integrate BI architecture with Enterprise architecture and other enterprise level disciplines including security and engineering. Work in collaboration with BI delivery team leaders, business analysts and business leaders to understand business requirements and end user's needs. Translate business requirements and end user's needs into architecture blueprints that deliver cost effective and high performing, high quality BI solutions. Design, develop, manage, and update logical and physical data models for the BI data marts. Work with IT partners to review upstream data warehouse data models and assess/mitigate impact. Communicate database designs to business and technical audiences, including business users, program sponsors, database administrators, ETL developers, and BI developers. Migrate schema changes between development, QA, and production environments. Provide architectural expertise, thought leadership, direction, and assistance across entire BI organization. Present proposed solution blueprints to the Architecture Review Board. Communicate solution blueprints to project team members, business users, and program sponsors. Participate in Architecture Review Board meetings. Review solutions presented by other BI architects and provide constructive feedback. Engage with IT teams including Data Management, DBAs, Security, Storage, and Networking for project needs. Participate in capacity planning for all layers in the BI technology stack and solve complex production issues spanning multiple tiers in the BI/DW technology stack. Research and evaluate new BI /DW technologies and make adoption recommendations. Develop and document technical standards and best practices for the BI organization; develop and execute to BI Architecture roadmaps; develop training plans; and develop and refine BI Architecture roles and responsibilities. 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. Support logical and physical database design for data warehouses including Erwin, Visio, or similar leading data modeling tools. Develop and implement complex SQL on MPP platforms including AWS Redshift, Snowflake, or Teradata Vantage. Perform ETL job development for data warehousing in any data warehouse databases.
EDUCATION / REQUIREMENTS: Bachelor's degree in Computer Science, Information Technology, Economics, Mathematics, Computer Engineering, or a related field. 8 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. 5 years of experience in: logical and physical database design for data warehouses including Erwin or Visio; developing and implementing complex SQL on MPP platforms including at least one of the following: AWS Redshift, Snowflake, or Teradata Vantage; and performing ETL job development for data warehousing in any data warehouse databases.
Hybrid arrangement is available.
Requires 10% domestic travel.
#LI-ML6
BBL701 2026-74072 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, Information Technology, Economics, Mathematics, Computer Engineering, or related field.
- 8 years of experience in a data warehousing environment and databases with experience in at least one: AWS Redshift, Snowflake, Teradata, Netezza, DB2, or SQL Server.
- 8 years of experience in data warehouse architecture including data sourcing/acquisition, integration, transformation, and presentation using SQL Stored Procedures, Shell Scripts, and Python.
- 5 years of experience in logical and physical database design for data warehouses using Erwin, Visio, or similar data modeling tools.
- 5 years developing and implementing complex SQL on MPP platforms including at least one: AWS Redshift, Snowflake, or Teradata Vantage.
- 5 years performing ETL job development for data warehousing in data warehouse databases.
- Ability to work hybrid (on-site/hybrid arrangement) and travel domestically up to 10%.
What the Team is Saying
Eilisa
Group Vice President, Service Delivery Applications
Stephanie
Sr. Director, Video Tools & Automation
Raquenel
Senior Director, Product Insights
Mary
GVP, Network Security Operations
Kat K.
Director of Field Operations
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?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
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
Spectrum Teams
Product & Tech
About our Teams
Spectrum Offices
OnSite Workspace
Typical time on-site:
None
Stamford, CT
Austin, TX
Charlotte, NC
Denver, CO
Los Angeles, CA
Saint Louis, MO
Stamford, CT
Learn more
