Sr Mgr, BI Architecture

Time Warner Cable Charlotte , NC 28201

Posted 7 days ago

Posting Job Description

JOB SUMMARY

This position is responsible for creating high-level solution designs, logical/physical data models and implementation strategies for end-to-end business intelligence and data warehousing solutions for various lines of business. This position also requires managing the team of architects who does the similar functions.

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

  • Manage team of BI Architects that involve: Assignment of work/tasks to others; Monitoring work of others; Perform all the HR related task such as onboarding, performance evaluation, career development, mentoring etc. for the direct reports

REQUIRED QUALIFICATIONS

Skills /Abilities and Knowledge

Ability to read, write, speak and understand English

Exceptionally strong written and verbal communication skills

Ability to work independently

Ability to supervise and motivate others

Ability to communicate orally and in writing in a clear, straightforward and professional manner

Ability to handle multiple projects and tasks and meet deadlines

Ability to make decisions and work collaboratively with others to solve problems

Ability to prioritize and organize effectively

Prior experience and passion for leveraging data to drive significant business impact

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

Related Work Experience Number of Years

Experience in IT with 5+ years of full life cycle experience as an architect in large-scale, complex BI/DW environments, with numerous data sources, diverse BI applications, tens of terabytes of data

and thousands of users : 10+ years

Team lead/supervisory experience ; 5+ years

of hands-on experience in Erwin Data Modeler, ER/Studio or similar data modeling tools ; 7+ years

Hands-on experience in ELT/SQL Development on Teradata or similar MPP database platform; 5+ years

Experience in ETL platforms such as Informatica, Ab-initio or Data Stage ; 5+ years

Experience in BI reporting/OLAP platforms such as MicroStrategy (preferred),Cognos, Business Objects ; 5+ years

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, Statistics, Mathematics, or Business Administration or relevant work experience.

Master's degree preferred

WORKING CONDITIONS

Office environment


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
Sr Manager BI Architecture

Spectrum

Posted 7 days ago

VIEW JOBS 3/13/2019 12:00:00 AM 2019-06-11T00:00 JOB SUMMARY This position is responsible for creating high-level solution designs, logical/physical data models and implementation strategies for end-to-end business intelligence and data warehousing solutions for various lines of business. This position also requires managing the team of architects who does the similar functions. 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 * Manage team of BI Architects that involve: Assignment of work/tasks to others; Monitoring work of others; Perform all the HR related task such as onboarding, performance evaluation, career development, mentoring etc. for the direct reports REQUIRED QUALIFICATIONS Skills /Abilities and Knowledge Ability to read, write, speak and understand English Exceptionally strong written and verbal communication skills Ability to work independently Ability to supervise and motivate others Ability to communicate orally and in writing in a clear, straightforward and professional manner Ability to handle multiple projects and tasks and meet deadlines Ability to make decisions and work collaboratively with others to solve problems Ability to prioritize and organize effectively Prior experience and passion for leveraging data to drive significant business impact 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 Related Work Experience Number of Years Experience in IT with 5+ years of full life cycle experience as an architect in large-scale, complex BI/DW environments, with numerous data sources, diverse BI applications, tens of terabytes of data and thousands of users : 10+ years Team lead/supervisory experience ; 5+ years of hands-on experience in Erwin Data Modeler, ER/Studio or similar data modeling tools ; 7+ years Hands-on experience in ELT/SQL Development on Teradata or similar MPP database platform; 5+ years Experience in ETL platforms such as Informatica, Ab-initio or Data Stage ; 5+ years Experience in BI reporting/OLAP platforms such as MicroStrategy (preferred),Cognos, Business Objects ; 5+ years 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, Statistics, Mathematics, or Business Administration or relevant work experience. Master's degree preferred WORKING CONDITIONS Office environment Spectrum Charlotte NC

Sr Mgr, BI Architecture

Time Warner Cable