Position: Data Modeler
Location: Charlotte, North Carolina 28202
Rate: Your best
Primary Responsibilities: * Solution Delivery: Provide leadership and hands on support for the development and delivery of key business and technology-driven initiatives. *Architecture Development: Develop and maintain an architecture that describes the principles, standards, and operating model. * Platform Design & Implementation: Lead design and implementation activities including improvements to the technology platform, maintaining capacity projections, and working withsupport teams to ensure production support processes and controls are appropriately implemented. * Data Architecture and Strategy: Partner with enterprise data management team to ensure adherence to policies and standards as well as alignment to key enterprise initiatives. * Roadmap: Assist with building the strategic roadmap and all associated planning/activities to reach the target state. This role will be responsible for ETL design, development and performance optimization. The role will partner with business teams, technical analysts and ETL/reporting developers to determine appropriate technical solutions to address business needs. This role will also collaborate closely with the reporting and analytics team to identify, define and assist in accessing and analyzing the data. The architect will also oversee the process to create and maintain the master data dictionary, required metadata and ensure adherence to data modeling standards.
Required Skills: * Minimum 10 years of related responsibleexperienceworking with large and complex data warehouse systems with a minimum of 5years of hand-on data architectureexperience. * Minimum 10 years of Oracle database modeling and/or database administration experience. * Extensive hands-on technical knowledge of Data Warehouse Architecture, ETL, Database & SQL performance tuning. * Ability to analyze source system data, data modeling of logical and physical design and oversight of physical database implementation. *Experience with designing, building, configuring and supporting multi-terabyte data warehouses. * Strong experience with Netezza focused on performance tuning, best practices and administration. Also hands on experience with database platforms including Oracle, SQL Server, Teradata. * Strong understanding of relational database structures, theories, principles, and practices. * Proven experience with data architecture, data mining, large-scale data modeling. * Has led many complex data architecture solutions comprising the various phases of planning, design and implementation. * Must be abreast of data architecture and data management industry best practices, and the latest trends in data management technology. Preferred Skills: *5+ years Informatica Powercenter experience. *5+ years Banking/Finance industry experience. *3+ years of data modeling experience using Erwin or Sybase PowerDesigner. * Financial Risk Manager (FRM) certification.