TITLE: BI Architect II LOCATION: Charlotte, NC JOB SUMMARY: Responsible for creating solution blueprints, high-level design and implementation, logical and physical data models for end-to-end business intelligence, and data warehousing solutions. Work in collaboration with BI delivery team leaders, business analysts, and business leaders to understand business requirements and end user's needs. Utilize Data Warehouse Architecture to design data warehousing solutions to support architecture, data sourcing and acquisition, integration, transformation, and presentation of data models. Utilize SQL skills to perform SQL analysis on Teradata or other database Platforms including Netezza, Oracle, DB2, and SQL Server. Perform data modeling, including logical and physical database design for data warehousing. Utilize ETL tools to perform ETL job development for data warehousing.Translate business requirements and end-user's needs into architecture blueprints that deliver cost effective and high performing, high quality BI solutions in compliance with Charter standards, policies, and long-term technical strategies. Design, develop, and create logical and physical data models for the BI data marts. Develop integration jobs to load new and existing physical data models. Integrate new dimension and fact tables that meet business needs and follow current standards. Work with IT partners to review upstream data warehouse data models and assess/integrate the impact on business intelligence. Communicate database designs to business and technical audiences, including business users, program sponsors, database administrators, ETL developers and BI developers. Work with database architects to migrate schema changes between development, QA, and production environments. Coordinate with IT database administrators to migrate DDL and integration jobs through lower environments into production to support business intelligence software development life cycle. Propose blueprint for complex data solutions and present to the Architecture Review Board (ARB). Develop and document technical standards and best practices for the BI organization. Assist Project Manager and BI delivery team leaders in estimating effort and resources for new projects and enhancement requests. Design complete solutions to data integration efforts for all aspects of data movement through the Charter network. Participate in capacity planning for all layers in the BI technology stack and solve complex production issues spanning multiple tiers in the BI/DW technology stack.
EDUCATION/
REQUIREMENTS: Bachelor's degree, or foreign equivalent, in Computer Science, Electronics, Computer Information Systems, Engineering, or related field. 5 years of experience utilizing Data Warehouse Architecture to design data warehousing solutions to support architecture, data sourcing and acquisition, integration, transformation, and presentation of data models; and, utilizing SQL skills to perform SQL analysis on Teradata or other database Platforms including Netezza, Oracle, DB2, and SQL Server. 3 years of experience performing data modeling, including logical and physical database design for data warehousing. 2 years of experience utilizing ETL tools to perform ETL job development for data warehousing.
BBL602 306141 306141BR