*Hi,* *Kindly let me know if you have a suitable fit for the following position.*
*Thanks* *Data Warehouse Modeler * *Location: Utah* *Duration :18months* *Please send the resume to [email protected] <[email protected]>* *Data Warehouse Modeler:* The Data Warehouse Modeler (DWM) is responsible for transforming business information into models (conceptual, logical and physical) and managing the enterprise warehouse data model. This goes beyond the role of a typical application level "data modeler" in that it requires modeling from an "enterprise perspective" rather than from a single business function perspective. The DWM is proficient in industry standard techniques for process and data modeling. Within data modeling, the DWM must be proficient in both 3rd normal form relational and dimensional modeling. This person must be experienced in group facilitation with participants from diverse business functions and work skills. Responsibilities include analyzing (reverse-engineering) source applications, modeling, designing, developing, implementing, and maintaining the data warehouse, data marts and the operational data store models; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. *Job Responsibilities: * Perform Business Requirement Analysis: » Interact with Business Analysts to obtain data and functional requirements » Interact with business users and identify reporting needs » Conduct interviews, brain storming discussions with project team to get additional requirements » Gather accurate data by performing data and functional analysis. » Analyzing source applications database structures and assist in building SQL extracts Perform Development of data models: » Create and document conceptual, logical and physical data models. » Communicate physical database designs to Data Warehouse Administrators. Reports: » Generate reports from data models. Review: » Review the data models with business and technical teams. Creation of database: » Create SQL DDL code from data model and co-ordinate with DBAs to create database. » Insure that see data models and databases are in synch. Support & Maintenance: » Assist developers, ETL, BI team and end users to understand the data model. » Maintain change log for each data model. » Establish and enforce overall modeling standards, guidelines, best practices, techniques and approaches. » Assist with the development of project estimates, plans, and schedules. » Communicate effectively with business and IT staff across functional departments » Maintain an in-depth knowledge of current and emerging methodologies, technologies and standards and provide direction to management and users » Evolves models to meet new and changing business requirements » Participate in data integration, information management programs and projects » Participate in tool evaluation and selection » Translate client user requirements into technical architecture vision and implementation plans. » Performs other duties, as assigned. *Position Interfaces With: * Business users, data warehouse business support staff, IT management, technicians and business administrators at multiple levels. Background and Expertise Required To Accomplish The Job: *Required:* - 8+ years of total IT experience - 2+ years experience with specific responsibility for modeling business intelligence within data warehouse or operational data store environments - Expert data modeling skills (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts) using an industry standard modeling tool (i.e. ER/Studio) - Expert knowledge in *SQL* - Expert knowledge of relational and dimensional database design concepts - Good understanding of both database and system performance tuning - Good understanding of database security management - Good facilitation skills to engage subject matter experts - Good background in database design and lifecycle management - Good understanding of Business Intelligence reporting tools and how they work - Knowledge of database loading methods - Strong knowledge of one or more of the leading database platforms ( i.e. Oracle, DB2, SQL Server, Teradata, Greenplum are preferred) - Good understanding of the MPP databases (like Teradata or Greenplum) - Knowledge of all phases of the system development life cycle - Strong problem resolution skills - Strong testing and debugging skills - Strong communication and interpersonal skills - Demonstrated ability to take ownership & responsibility for development and maintenance projects *Warm Regards,* *Charan** | IVY Tech Sols Inc.* 3403 N Kennecott Avenue, Suite B&C Arlington Heights, IL 60004 Direct: *(847) 350-1008 * *[email protected]* <[email protected]>*|Gtalk : charan.ivytech| Yahoo : charan_ivytech* -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
