Pyramid is a leading Information Technology Consulting services company headquartered in metropolitan Atlanta, GA with prime emphasis on the following service offerings :
While professional experience and qualifications are key for this role, make sure to check you have the preferable soft skills before applying if required.
- 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.
Job Description
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
Additional Information
Warm Regards
J-18808-Ljbffr
Data Modeler - Short term contract
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). Created, documented and maintained logical and physical database models in comp...
ETL Developer
A company is looking for an ETL Developer to support the Return Revenue Program with the Internal Revenue Service. ...
Senior Analyst Data Operations, Central Activation
As a Senior Analyst on the Data Operations team, you will help our team build a robust foundation of reporting and analytics and help internal and external clients make better decisions by taking advantage of known data-driven techniques. The candidate must have strong technical skills in relational...
Senior Data Analyst
You're a naturally curious data professional who can combine complex data science techniques with the ability to find and share actionable insights relevant to the problem at hand. You're proactive, data-driven, diligent and focused on business results. You have a knack for spotting patterns...
Business Analyst, Data Governance
They behave like Business Analysts who understand the business requirements and are able to produce clear documentation to facilitate automation of data processing. As “The ROI Agency,” Zenith’s expertise lies in driving real, tangible business outcomes, not just media metrics, tha...
Data Entry Clerk - Remote Work From Home (Part-Time / Full-Time)
No Data Entry experience needed. Data Entry Clerk Work From Home - Part Time Remote Focus Group Panelists. Data entry clerk experience is not necessary. If you are a data entry clerk or someone just looking for a flexible part time remote work from home job, this is a great way to supplement your in...
Data entry clerk
The Data Entry Clerk will capture the data into relevant databases in a timely and accurate manner. We are looking for a focused Data Entry Clerk to continuously update our companys databases. The Data Entry Clerk will liaise with and follow up with employees within the company as well as with custo...
Senior Robotics Software Engineer
Senior Robotics Software Engineer. Your objectives will include collaborating with a talented cross-functional team of software engineers and roboticists to drive innovation and excellence. Senior Robotics Software Engineer. Aescape you'll work with an incredibly talented cross-functional team of so...
Pharma Biotech Data Scientist Assoc Dir
Provide subject matter expertise on commercial data and analytics, such claims, EMR, formulary data. Pursue and secure new business, which includes aligning client business problems to data/analytic plans, collaborating with advisory teams, identifying scalable solutions and services, and presenting...
Salesforce Business Analyst
As a Salesforce Business Analyst you will help shape Justworks’ internal operations by working within the Business Operations team to provide business systems analysis and product management, with a focus on Salesforce and its integrated systems. We’re helping businesses get off the ground by enabli...