Full TimeStamford, ConnecticutPosted 09/20/2021Areas of interest: Business IntelligenceRequisition Number: 286578BRBBL606
JOB SUMMARY 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.
MAJOR DUTIES AND RESPONSIBILITIES: 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
REQUIRED QUALIFICATIONS 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
Education 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+
PREFERRED QUALIFICATIONS 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
WORKING CONDITIONS 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.