Data Architect

Spectrum - Town and Country, MO

Full-time - Mid Level

Town and Country, MO

10,001+ employees

Telecommunications

About the position

The Data Architect will be responsible for the comprehensive design and implementation of data repositories and the flow of data through various stages. This role involves addressing data migration, validation, cleanup, and mapping, while emphasizing the importance of data dictionaries. The architect will collaborate with IT and cross-functional teams to develop enterprise solutions that address critical business challenges.

Responsibilities

• Partner with the IT/BI team and cross-functionally within the organization to provide insight and technology recommendations that result in enterprise solutions that solve critical business problems.
• Develop and maintain data structures which draw information from multiple sources of data such as corporate databases, corporate data warehouses, and field operational data stores.
• Design, deliver, and document multi-platform architecture with a focus on architectural standards, growth, performance, flexibility, reliability, scalability, and security.
• Identify architectural risks and plans to mitigate; quickly troubleshoot problems with data generation and reporting to correct problems with a minimum of downtime.
• Work with vendors to develop metadata structures for two-way data communications which allow interchange between existing and new data sources.
• Recommend and implement new ways of exchanging data with corporate or field customers using network or web-based reports, forms, or files.
• Generate new data products for data licensing which fit client requirements.
• Manage the transfer from prototype to scheduled report.
• Oversee the use of corporate data to create reports in Excel, Crystal Reports, and other reporting tools.
• Identify desktop tools which will improve reporting or data gathering ability and evaluate and recommend purchase if necessary.
• Quickly learn new tools (desktop or external) which enhance the department's ability to gather, process, or report data and integrate these tools with existing structures to improve information flow.
• Use knowledge of business processes to work with personnel in Sales, Marketing, Finance, and Operational disciplines to understand their problems and devise solutions.
• Design and help develop ETL, replication schemes, and query optimization techniques that support highly-varied and high-velocity data processing and delivery.
• Develop standards and methodologies for benchmarking, performance, evaluation, testing, data security, and data privacy.
• Perform impact analysis, performance tuning, and capacity planning for the data warehouse and its infrastructure as source systems are added and new integration business rules and logic are introduced.
• Provide recommendations, technical direction, and leadership for different technologies as part of the overall architecture.

Requirements

• Bachelor's degree in Management Information Systems; Preferred Master's degree in Management Information Systems or MBA with emphasis in MIS or associated experience.
• Minimum five (5) years of RDBMS solutions such as Access, SQL, and Oracle.
• Minimum five (5) years of designing databases.
• Minimum five (5) years of large relational database deployment experience.
• Advanced knowledge of Tables, Queries, and Views in MS SQL and Oracle.
• Knowledge of Relational Data Modeling, Database design, and analysis of data requirements and sources.
• Experience in architecting and building procedures, functions, views, and triggers with SQL relational databases.
• Proficient in complex database concepts and effectively employ different database design techniques.
• Ability to program in TS-SQL and VBA.
• Ability to use MS Office Suite (Word, Excel, PP, Access, Visio).

Nice-to-haves

• Ability to work independently and as a team player with minimal supervision and effectively meet project deliverables on time.
• Exceptional analytical, conceptual, problem-solving, and multi-tasking abilities.
• Ability to manage multiple projects at one time.
• Knowledge of report design.
• Ability to communicate with all levels of management and company personnel.
• Ability to make decisions and solve problems while working under strict deadlines.
• Ability to communicate orally and in writing in a clear and straightforward manner.
• Ability to prioritize and organize effectively.
• Ability to maintain confidentiality.
• Ability to show judgment and initiative and to accomplish job duties.
• Knowledge of cable and telecommunications products and services.
• A solid understanding of web application development processes.
• Experience working with Agile/Scrum implementation teams.

Benefits

• Opportunities for advancement
• Comprehensive pay and benefits package that rewards employees for their contributions to success
• Support for all aspects of employee well-being