Data Architect

Client Reference Code: 193386
POSITION SUMMARY:

The Data Architect will be responsible for end-to-end vision on how a logical design will translate to one or more data repositories and how the data will flow through the stages involved. The architect will need to be able to address issues of data migration—validation, cleanup, and mapping—and will need to understand the importance of data dictionaries.

ESSENTIAL FUNCTIONS:

Actively and consistently support all efforts to simplify and enhance the customer experience
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 in the process
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. 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. 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. Be able to quickly understand their problems and devise solutions.
Design and help develop ETL, replication schemes, and query optimization techniques that support highly-varied (structured, semi-structured, and unstructured) and high-velocity (near real-time) 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

JOB REQUIREMENTS:

Ability to read, write, speak and understand English
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)

RELATED WORK EXPERIENCE:
Number Of Years
RDBMS solutions such as Access, SQL and Oracle 5+
Designing databases 5+
Large relational database deployment experience 5+

EDUCATION:

Bachelors of Science in Management Information Systems; Preferred Masters of Science in Management Information Systems or MBA with emphasis in MIS or associated experience

PREFERRED QUALIFICATIONS:

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

WORKING CONDITIONS:

Office Environment
Travel as required


Job Code : TWCIDB303 Data Architect Exempt

193386BR