Data Architect
Town and Country, Missouri
Spectrum’s growth and success in the ever-evolving technological landscape are built on the sophisticated innovations and service reliability our Network Operations groups provide. Our Operating Model focuses on maintaining operational excellence and reliability of Spectrum’s network to enhance our customer’s experience. The Network Operations environment is based on our Key Laws of Focus which values accuracy, resiliency and response time.
The mission of the NOC is to protect, improve and support a superior customer experience. Our NOC engineers identify network issues when they arise and escalate them to the proper fix agents. We’re driving quick and high-quality resolutions. NOC teams also ensure successful network Change Management, perform Root Cause Analysis of outages, and develop processes for standardizing work and partners with vertical teams with solutions for Continual Service Improvement. Our reporting and metrics teams provide data and analyze reports to enable support of all Network Operations.
- Full-time
- Job level: Entry to Senior
- Travel: Occasional
Success profile
What makes you successful in Network Operations Centers (NOC)? Check out the top traits we’re looking for and see if you have the right mix.
- Analytical
- Problem Solving
- Detail-oriented
- Flexible
- Leadership
- Team Player
Hear from our team
Trending
Rewards
Spectrum wants to help you get more out of life and take care of things outside the office to make life a little easier. We provide:
-
Health Insurance
Medical, prescription drug, dental, and vision plans available.
-
Paid Time Off
Paid vacation, sick and personal time, and holidays.
-
401(k) Retirement Savings
We provide a 100% match for every dollar you contribute, up to 6% of your eligible pay.
-
Education Assistance
Get reimbursed up to $10,000 a year for undergraduate and graduate degrees through our partnership with Guild.
-
Career Progression
Advancement is a very real and achievable goal.
-
Training and Certification
Sponsored courses help enhance your skills.
Responsibilities
JOB SCOPE
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.
DUTIES AND RESPONSIBILITIES
- 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.
- 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.
- 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.
- 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.
- Works in development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
- Designs, develops, and delivers data from operational systems and files into a staging area, ODSs (operational data stores), Data Warehouse, downstream Data Marts and files.
- With MS SQL Server, SSIS, SSRS responsible for developing and deploys ETL job workflow with reliable error/exception handling and rollback framework.
- Understands automation of file processing as well as all ETL processes within a job workflow.
- Performs the unit testing, system integration testing and assist with user acceptance testing.
- Adapts ETL code to accommodate changes in source data and new business.
BASIC / MINIMUM QUALIFICATIONS
- Bachelor's degree in Management Information Systems or related field, and / or equivalent work experience.
- Minimum five (5) years of experience in Relational Database Management Systems solutions such as Access, SQL and Oracle.
- Minimum five (5) years of experience in Designing databases.
- Minimum five (5) years of experience in large relational database deployment experience.
ADDITIONAL JOB REQUIREMENTS
- 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 architecture 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 post-gres Sql and MS Office Suite (Word, Excel, PP, Access, Visio).
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, critical thinking 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, make decisions and solve problems while working under strict deadlines.
- Capable of prioritizing and organizing effectively and to maintain confidentiality.
- Shows judgment and initiative to accomplish job duties.
- Knowledge of cable and telecommunications products and services.
- Experience working with Agile/Scrum implementation teams.
- Experience with big data and KAFKA knowledge.
- Experience with AWS and cloud computing.
WORKING CONDITIONS
- Office Environment
- Travel as required
Here, employees don’t just have jobs, they build careers. That’s why we believe in offering a comprehensive pay and benefits package that rewards employees for their contributions to our success, supports all aspects of their well-being, and delivers real value at every stage of life.
A qualified applicant’s criminal history, if any, will be considered in a manner consistent with applicable laws, including local ordinances.
Get to Know Us Charter Communications is known in the United States by our Spectrum brands, including: Spectrum Internet®, TV, Mobile and Voice, Spectrum Networks, Spectrum Enterprise and Spectrum Reach. When you join us, you’re joining a strong community of more than 100,000 individuals working together to serve nearly 32 million customers in 41 states and keep them connected to what matters most. 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. EOE, including disability/vets. Learn about our inclusive culture.
