Data Warehouse Modeler Required

""""PLEASE SEND ME YOUR UPDATED RESUME AT kevinb@amtexsystems.com"""""

Title: Data Warehouse Modeler

Duration: 6 – 12+ months

Location: Salt Lake City, UTAH

 

Job Description:

 

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.

 

 

Thanks & Regards,

Kevin

Amtex System,

Email: kevinb@amtexsystems.com

Ph: 917-463-4086

Gtalk: amtex.kevinb

Twitter: @Kevin_Amtex

LinkedIn: http://www.linkedin.com/pub/kevin-b/43/a07/b79/

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.