BI Data Quality Architect II

Full Time Stamford, Connecticut Posted 09/20/2021 Areas of interest: Business Intelligence Requisition Number: 286578BR BBL606

The Data Quality Architect II is a senior Subject Matter Expert (SME) role within the BI Data Quality Management organization that is responsible for data quality assurance from various data sources to ensure data integrity and information usability for internal decision making. The Data Quality Solutions Architect II supports the data quality program through interaction with various business data owners, data production system owners, and decision makers to develop and implement proactive data quality practices.

This hybrid business-technical role requires a highly skilled and motivated professional who can with leadership and business units to understand information need, document strategic and operational needs, identify and remediate data quality framework capability gaps, design data quality tooling, and architect improvements to the landscape.

Work in collaboration with BI delivery team leaders, business analysts and business leaders to understand data quality requirements and end user’s needs
Translate business requirements and end user’s 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

Responsible for design and documentation of the architectural vision; conceptual, logical, and physical models; ER diagrams; data flows; and process models for the BI Data Quality data marts

Lead the process of identifying opportunities to improve data quality alignment in accordance with the business objectives

Provide architectural expertise, thought leadership, direction, and assistance across entire data Quality 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 BI architects and provide constructive feedback

Responsible for tool implementation and maintenance needed to perform quality processes for master and reference data

Perform impact analysis, performance tuning, and capacity planning for the data quality platform and its infrastructure as source systems are added and new integration business rules and logic are introduced
Engage with IT teams such as Data Management, DBAs, Security, Storage and Networking when their involvement is required to meet the project needs

Work with analytics and data engineering leaders to identify and drive data quality standard methodologies and consistency that align analytics & data science priorities to a data quality strategy and roadmap

Establish reusable tools and best practices for Data Quality analysis, tracking cleansing and escalation

Conduct code reviews for the Data Quality organization to ensure compliance with Charter standards

Work independently with minimal instruction to find solutions consistent with defined standards and approach

Foster best practices and create a culture of consistency, accountability and continuous improvement

Perform other duties as requested

Skills/Abilities and Knowledge

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
Experience with SQL performance tuning and batch optimization to handle and process large volume of data in Teradata
Expert knowledge of multiple Operating Systems server platforms (Redhat, CentOS, Microsoft OS, Solaris, AIX, AS/400, etc.)
Proficient in Linux and Unix Shell scripting
Strong mathematical and problems solving skills with a keen eye for identifying trends and data anomalies
Working knowledge of Data Governance, Data Quality and Data Lineage concepts is required
Expert knowledge of Data Management Principles and Data Quality Improvement
Experience with Big Data processing frameworks such as MapReduce Spark, Yarn, HDFS, S3, Kafka
An expert understanding of infrastructure technologies and concepts
Ability to demonstrate lateral thinking required to solve complex technical problems
Ability to perform duties in a fast-paced environment and ability to learn new technology quickly
Ability to prepare clear and concise documentation for technical and business audiences
Ability to communicate in a clear and straightforward manner (written and verbal)
Ability to deliver against several initiatives simultaneously
Ability to prioritize and organize effectively

Bachelor’s degree or foreign equivalent in Economics, Mathematics, Computer Science; or equivalent training, education and experience
Master’s degree preferred

Related Work Experience Number of Years
Architect in large-scale, complex BI/DW environments, with
numerous data sources 8+
Experience in data mining, large scale data acquisition, transformation, 8+
and cleaning, both structured and unstructured data
Experience providing data integration solutions in large-scale enterprise
primarily using MPP databases such as Teradata 7+
Experience in developing automated frameworks, templates and design
patterns 5+
Lead technical role experience 5+
Requirements gathering, analysis, and documentation 5+
Experience in managing the Data Lifecycle with specific focus on 5+
Data Quality practices and data issue management/root cause analysis
Experience selecting and implementing a data quality toolset 5+

Skills/Abilities and Knowledge

Teradata certifications are big plus
MicroStrategy or any other BI tool knowledge and experience
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
Working knowledge of a Business Process Management tool is a plus
Experience working within an AWS environment a plus

Office environment
Travel (<10%)

BBL606 286578 286578BR

Our Commitment During COVID-19 Your health and safety is important to us, as such we’re 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, you’re joining a strong community of more than 95,000 individuals working together to serve more than 31 million customers in 41 states. Watch this video to learn more.

Who You Are Matters Here We’re committed to growing a workforce that reflects our communities, and providing equal opportunities for employment and advancement. Learn about our inclusive culture.

Related jobs

View All of Our Available Opportunities

Sign up for job alerts

Sign up to receive the latest career opportunities directly to your inbox.

Areas of interestEnter a location and a category, and click "Add" to create your Job Alert.

  • Business Intelligence, Stamford, Connecticut, United StatesRemove

Spectrum employeeAre you currently a Spectrum employee?