Job Order #1287

Email this Job to a Friend
Posted Date: 4/25/2017
Job Category:
Position Title: Data Modeler
Salary Range: $75.00
Location: Kansas City, Missouri, USA
Desired Skills:
Description: PCM is currently looking for a Data Modeler for a contract position in the Kansas City area. The primary responsibility of the Modeling Contractor is to provide strategic leadership and guidance in the design, development, implementation, and maintenance of data models, data warehousing, and data integration solutions. It includes working with and building consensus among IT stakeholders including IT developers, management, and business partners. The Modeling Contractor will interact with all levels in the Information Technology and business organizations.

A key responsibility for this candidate will be to facilitate the creation of process for fast ingestion of data sources into an Enterprise Client Data Warehouse. Previous success in this space is desirable.

Major Responsibilities:
• Provide hands-on application design and development of data structures and applications to solve business problems.
• Work with other stakeholders to design, develop, install, and maintain data structures and applications to solve business problems.
• Advise management of the impact that business decisions will have on the applications development environment.
• Stay current about trends and technologies impacting Data warehousing, data management, metadata management, and data governance.
• Assist in establishing standards and guidelines for the design & development, deployment and maintenance of data and application solutions.

Specific Responsibilities:
• Possesses expert knowledge of the Distribution Technologies, including: enterprise data warehouse, systems processes and the supporting applications used in those processes.
• Develops data warehouse modeling processes and standards to support fast ingestion of data sources in a multi-layered warehouse environment.
• Collaborates with data management and data governance to integrate business definitions in data models, and escalates new sources and attributes for review and definition.
• Works within an agile delivery framework to be responsive to project and stakeholder requirements.
• Leverages industry standard data model patterns to increase speed of delivery and flexibility for future additions and enhancements.
• Provides support to data integration developers including source to target mapping and guidance for standard reusable transformations.

• Three or more years of experience with Data Quality, Data Warehousing, and Data Mart implementations, including experience designing and modeling Enterprise Data Warehouse. Experience with Kimball methodology, star schema, and snowflake.
• Hands on experience with Relational and Dimensional data modelling.
• Proficient in writing SQL.
• Knowledge of data modeling tools such as Embarcadero E/R Studio or Erwin.
• Knowledge of formal applications development methodologies including Agile and Devops.

• Knowledge of Salesforce development environments.
• Knowledge of Informatica Cloud, Informatica Data Quality and Informatica Power Center development environments.
• Knowledge of massively parallel processing (MPP) environments such as IBM Pure Data for Analytics or Netezza.
• Knowledge of a variety of Database Platforms (i.e. Oracle, SQL Server, MPP).

Share this job: