ARCHIVED
This job listing has been archived and is no longer accepting applications.
MisuJob - AI Job Search Platform MisuJob
Login Sign Up

Data Modeler - Short term contract

PyramidIT1

New York, NY, United States contract

Posted: June 2, 2015

Interested in this position?

Create a free account to apply with AI-powered matching

Register to Apply

Quick Summary

Data Modeler is responsible for designing and implementing data models for various applications, ensuring data integrity and consistency.

Required Skills

Domain Knowledge Data Modeling Data Warehousing OLAP BI Data Analysis OLTP Erwin ER Studio Dimensional Modeling Schema maintenance

Job Description

Pyramid is a leading Information Technology Consulting services company headquartered in metropolitan Atlanta, GA with prime emphasis on the following service offerings:
• Staff Augmentation
• Lifecycle IT solutions
o Application Development & Support
o Outsourced Testing
• Mobile Development and Test Automation

The company was incorporated in the State of Georgia in 1996 and has grown to over 2500 Information Technology consultants serving clients across the United States and around the globe. In addition to Atlanta, Pyramid has offices worldwide including Charlotte, NC; Chicago, IL; Dallas, TX; Richmond, VA; San Francisco, CA and Somerset, NJ in the United States, London in the United Kingdom, Singapore, and three offices in India (New Delhi, Hyderabad and Chandigargh).

Pyramid has been ranked by Staffing Industry Analysts as one of the largest diversity staffing firms specializing in IT and among the fastest growing U.S. staffing firm overall. In addition, Pyramid is a previous winner of the National Minority Supplier Development Council’s Supplier of the Year and has won numerous Supplier of the Year awards from the Georgia Minority Supplier Development Council.see less

SpecialtiesIT Staff Augmentation, Application Management Services, Enterprise Project Solutions, Mobile Development, Mobile Test Automation, Product and Engineering Services, Enterprise Mobility, Test Automation, QA - Manual and Automated Testing, QA Strategy

• Websitehttp://www.pyramidci.com

• IndustryInformation Technology and Services

• TypePrivately Held

• Company Size1001-5000 employees

• Founded1996

Role: Data Modeler
Location: New York City, NY
Duration: 3--4 Months to start

Domain Knowledge
• P&C Insurance Mandatory

Experience
• 10+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Warehousing (OLAP)/Business Intelligence (BI) applications and Data Analysis for Online Transaction Processing (OLTP).
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Exceptional communication and presentation skills and established track record of client interactions

Technical Skills
• Data Modeling Tools: Erwin and ER studio
• OLAP Tools: SAP Business Objects
• ETL Tools: Microsoft SSIS and Informatica 7.1.3
• Database Tools: Microsoft SQL Server 2000/2005/2008,2012
• Packages: Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects
• Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Technical Skills
• Data Modeling Tools: Erwin and ER studio
• OLAP Tools: SAP Business Objects
• ETL Tools: Microsoft SSIS and Informatica 7.1.3
• Database Tools: Microsoft SQL Server 2000/2005/2008,2012
• Packages: Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects
• Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Warm Regards

Ravi Jaiswal

Pyramid Consulting, Inc.

Associate Manager Resourcing

________________________________________

O: 770-255-3104 M: 404-891-0420

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.

Create Free Account Sign In
← Browse all jobs
Register to Apply