**JOB SUMMARY**

This position is responsible for creating solution blueprints, high-level design and implementation strategies, logical and physical data models for end-to-end business intelligence and data warehousing solutions.

**MAJOR DUTIES AND RESPONSIBILITIES**

Work in collaboration with BI delivery team leaders, business analysts and business leaders to understand business requirements and end users needs

Translate business requirements and end users needs into architecture blueprints that deliver cost effective & high performing, high quality BI solutions in compliance with Charter standards, policies and long-term technical strategies

Design, develop, manage and update logical and physical data models) for the BI data marts

Work with IT partners to review the upstream data warehouse data models and assess/mitigate the impact on BI side

Communicate database designs to business and technical audiences, including business users, program sponsors, database administrators, ETL developers and BI developers

Work with DBAs to 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 other 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

Assist Project Managers and BI delivery team leaders in estimating effort and resources for new projects and enhancement requests

Engage with IT teams such as Data Management, DBAs, Security, Storage and Networking when their involvement is required to meet the project needs

Participate in capacity planning for all layers in the BI technology stack

Help solve complex production issues spanning multiple tiers in the BI/DW technology stack

Stay current in new BI /DW technologies, evaluate them and make adoption recommendations

Participate in developing and documenting technical standards and best practices for the BI organization

Perform other duties as requested

**REQUIRED QUALIFICATIONS**

Expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation)

Experience in logical and physical database design for data warehousing (3NF/Star Schemas) including SQL writing/tuning on MPP platforms such as Teradata and/or Netezza

Proven ability to quickly grasp business requirements and translate them into optimized solution blueprints

Strong problem solving, collaboration and communication skills Passion for leveraging data to improve business outcomes

Experience in developing roadmaps for BI Architecture discipline

Experience in developing and implementing complex data warehouse and BI solutions

**PREFERRED QUALIFICATIONS**

Certification on Teradata and/or MicroStrategy is a plus

Familiarity with predictive modeling tools like SAS and/or R

Familiarity with Big Data technologies such as Hadoop and Spark is a plus but not required

Experience in cable or another telecommunications service provider is a plus

Familiarity with Agile development methodologies such as Scrum, Kanban and SAFe

**Education**

Bachelors degree or foreign equivalent in Economics, Mathematics, Computer Science; or equivalent training, education and experience

Masters degree preferred

**Related Work Experience Number of Years**

Architect in large-scale, complex BI/DW environments, with

numerous data sources 8

Erwin Data Modeler, ER/Studio or similar data modeling tools 3

ELT/SQL Development on Teradata or similar MPP database platform 2

ETL platforms such as Informatica, Ab-initio or Data Stage 2

BI reporting/OLAP platforms such as

MicroStrategy (preferred), Cognos, Business Objects 2

**WORKING CONDITIONS**

Office environment

Travel - 10%.

BBL602 301092-1 301092BR

**Our Commitment During COVID-19** Your health and safety is important to us, as such were using virtual recruiting tools to safely meet with qualified candidates. We are working in the office, following CDC guidelines.

**Get to Know Us** Charter Communications is known in the United States by our Spectrum brands, including: Spectrum Networks, Spectrum Enterprise and Spectrum Reach. When you join us, youre joining a strong community of more than 95,000 individuals working together to serve more than 31 million customers in 41 states.

**Who You Are Matters Here** Were committed to growing a workforce that reflects our communities, and providing equal opportunities for employment and advancement.

Senior Data Warehouse Architect Business Intelligence, Information Technology Charlotte, North Carolina Areas of interestEnter a location and a category, and click "Add" to create your Job Alert. Select category

Select location

* Business Intelligence, Charlotte, North Carolina, United States

* Information Technology, Charlotte, North Carolina, United States