BI Architect II

Spectrum Charlotte , NC 28201

Posted 7 months ago

JOB SUMMARY

This position is responsible for creating solution blueprints, high-level design and implementation strategies, logical and physical data models for end-to-end business intelligence and data warehousing solutions.

MAJOR DUTIES AND RESPONSIBILITIES

Work in collaboration with BI delivery team leaders, business analysts and business leaders to understand business 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

Design, develop, manage and update logical and physical data models) for the BI data marts

Work with IT partners to review the upstream data warehouse data models and assess/mitigate the impact on BI side

Communicate database designs to business and technical audiences, including business users, program sponsors, database administrators, ETL developers and BI developers

Work with DBAs to migrate schema changes between development, QA and production environments

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

Assist Project Managers and BI delivery team leaders in estimating effort and resources for new projects and enhancement requests

Engage with IT teams such as Data Management, DBAs, Security, Storage and Networking when their involvement is required to meet the project needs

Participate in capacity planning for all layers in the BI technology stack

Help solve complex production issues spanning multiple tiers in the BI/DW technology stack

Stay current in new BI /DW technologies, evaluate them and make adoption recommendations

Participate in developing and documenting technical standards and best practices for the BI organization

Perform other duties as requested

REQUIRED QUALIFICATIONS

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

Proven ability to quickly grasp business requirements and translate them into optimized solution blueprints

Strong problem solving, collaboration and communication skills Passion for leveraging data to improve business outcomes

Experience in developing roadmaps for BI Architecture discipline

Experience in developing and implementing complex data warehouse and BI solutions

PREFERRED QUALIFICATIONS

Certification on Teradata and/or MicroStrategy is a plus

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

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 5+

Erwin Data Modeler, ER/Studio or similar data modeling tools 3+

ELT/SQL Development on Teradata or similar MPP database platform 2+

ETL platforms such as Informatica, Ab-initio or Data Stage 2+

BI reporting/OLAP platforms such as

MicroStrategy (preferred), Cognos, Business Objects 2+

WORKING CONDITIONS

Office environment

Travel - 10%.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
BI Analyst II

Time Warner Cable

Posted 2 weeks ago

VIEW JOBS 2/9/2020 12:00:00 AM 2020-05-09T00:00 Posting Job Description JOB SUMMARY This position is responsible for supporting and managing a program of business unit-focused initiatives designed to help business partners drive value from information. Contributes to Charter's success by ensuring business needs and goals are realized through analysis and reporting activities of the Business Intelligence Group. Responsible for supporting the Manager or Director of Business Intelligence to empower Charter business leaders with concise, high-quality information, helping them leverage it to identify and address business opportunities and threats. Provides consultation on the interpretation of data to various business partners throughout the organization. MAJOR DUTIES AND RESPONSIBILITIES Actively and consistently support all efforts to simplify and enhance the customer experience Provide advice and education in the usage and interpretation of business data relevant to the business unit Communicate data nuances and insights to all levels of the company in a clear and concise manner Instill best practices and assists users at all levels within the company on how to leverage BI capabilities for accurate reporting and analysis Leverage knowledge of Business Intelligence capabilities and familiarity with business trends in identifying patterns, opportunities and threats Work closely with business partners in gathering detailed business requirements, establishing business definitions, translating to technical requirements for development team and gaining approval Interact with senior management or executive level customers and provides support as needed Create report mock ups based on requirements and coordinates with technical team in finalizing design and receiving sign off Support all scheduled and non-recurring information needs of the business users Understand data elements in the warehouse at a very detailed grain to support any form of user needs from research to adhoc querying to managing large information projects Query large datasets and tables comfortably to provide information requested by business users Present data in a fashion that is easy to understand with proper documentation for successful user adoption Manage detailed plans on small to medium sized projects to ensure successful completion Maintain metadata dictionaries and report definitions Work with cross functional teams to ensure alignment in business needs, timelines and department standards Create test plans and scenarios and conducts testing to ensure quality and requirements traceability to final deliverable Actively identify solutions to enhance the existing Business Intelligence infrastructure processes and technology Understand and evaluates cross functional and system to system impacts of requirements and change requests Uses advanced Excel skills to capture and communicate data findings Liaison among the business, development and support teams to ensure solutions being developed meet or exceed business needs Perform other duties as requested REQUIRED QUALIFICATIONS Skills/Abilities and Knowledge Ability to read, write, speak and understand English Exceptionally strong communication skills both written and verbal Proven experience and passion for leveraging data to drive business impact Intermediate to advanced statistical knowledge and intuition ideally utilized in A/B or multivariate testing (or related analytics) Advanced SQL skills Experience with reporting/Business Intelligence tools is preferred (MicroStrategy, Terradata is a plus) Ability to speak to large groups with excellent presentation skills Ability to perform critical thinking in the area of data analysis with advanced analytical skills Strong team and relationship building skills High attention to detail and quality Ability to work independently with minimal guidance, prioritize and organize effectively and manage multiple projects/assignments Ability to perform in a fast-paced environment Project management skills Ability to understand complex business processes, rules and gain business acumen to become subject matter expert Experience with data visualization standards and techniques to visually summarize data and insights is a plus Expertise with BI Data Modeling concepts such as Star/Snowflake Schema, Dimensions and Facts Education Bachelor's degree or foreign equivalent in Economics, Mathematics, or Business Administration or relevant experience Related Work Experience 5+ years relevant technical or business work experience Experience with Cable TV, Internet, and/or Phone products & services or other related industry experience is a plus. WORKING CONDITIONS Office environment Time Warner Cable Charlotte NC

BI Architect II

Spectrum